List:Eventum General Discussion« Previous MessageNext Message »
From:Anders Klarström Date:September 11 2008 6:20am
Subject:SV: File Uploads larger than 1mb
View as plain text  
This may be a timeout in SQL. I have seen this before, not with Eventum, but with another
application. I'll have a look in my archived emails and get back later.

//Anders

-----Ursprungligt meddelande-----
Från: Curtis Von Lintel [mailto:curtis.vonlintel@stripped]
Skickat: den 11 september 2008 04:51
Till: georger_br@stripped
Kopia: eventum-users@stripped
Ämne: Re: File Uploads larger than 1mb

We are getting closer. I can now upload files larger than 1mb but they
must be smaller than 10mb, php.ini is set at 225mb and my.ini
max_allowed_packet=225mb. But yet I can not upload larger than 10mb,
actually the largest I have uploaded is 8.0mb.

Again error log below

Thanks
Curtis

E:\wamp\www\support\eventum\include\class.attachment.php:476
  Attachment::add((string )'', (string )'3', (string )'', true)
E:\wamp\www\support\eventum\file_upload.php:44
  Attachment::attach((string )'3', (string )'public')


[Wed Sep 10 21:48:17 2008] An error was found on line '534' of script
'E:\wamp\www\support\eventum\include\class.attachment.php'.

The error message passed to us was:

'DB Error: syntax error'

A more detailed error message follows:

'INSERT INTO
                    eventum.eventum_issue_attachment_file
                 (
                    iaf_iat_id,
                    iaf_filename,
                    iaf_filesize,
                    iaf_filetype,
                    iaf_file
                 ) VALUES (
                    ,
                    'sawmill6.4.0_x86_win32.exe',
                    '8345927',
                    'application/x-sdlc',

'MZ?\0\0\0\0\0\0\0ÿÿ\0\0¸\0\0\0\0\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
º
\0´
Í!¸LÍ!This program cannot be run in DOS
mode.\r\r\n$\0\0\0\0\0\0\0".ô~Ðôs(ËÐôs(ËÐôs(ËSè"ËÌôs(Ë¿ë?ˤôs(Ë«è--ËÑôs(Ë¿ë'ËÝôs(Ë8ë'ËÒôs(Ë+ë0/00ËÙôs(ËÐôs(ËÓôs(ËÐô>ËÙõs(˲ë0/00Ëßôs(ËÖ×'Ëòôs(ËòoeËÑôs(ËRichÐôs(Ë\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0PE\0\0L\0,õ<\0\0\0\0\0\0\0\0à\0
\0\0à\0\0EUR\0\0\0\0\0oX\0\0\0\0\0ð\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0p\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0è\0È\0\'
... [nativecode=1064 ** You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '
                    'sawmill6.4.0_x86_win32.exe',
                    '8345927'' at line 10]

A backtrace is available:
Georger Araujo wrote:
> Hi Curtis,
> Please see http://lists.mysql.com/eventum-users/3345
> max_allowed_packet at 16M is just a suggestion. Set it to the size you find most
> adequate to your deployment.
> Regards,
>
> Georger
>
> --- Em qua, 10/9/08, Curtis Von Lintel <curtis.vonlintel@stripped>
> escreveu:
>
>
>> De: Curtis Von Lintel <curtis.vonlintel@stripped>
>> Assunto: File Uploads larger than 1mb
>> Para: eventum-users@stripped
>> Data: Quarta-feira, 10 de Setembro de 2008, 19:02
>> We are just getting started using eventum, a major feature
>> for us is the
>> file upload. Like in this
>> <http://lists.mysql.com/eventum-users/841>
>> post files that are larger than 1mb fail. On upload, the
>> upload window
>> goes white and when the issue page is refreshed it shows
>> uploaded
>> entries without filenames. I have tested up to 817Kb with
>> success and
>> 1,438Kb fail. We are running PHP 5.2.6, Apache 2.2.8,
>> Eventum 2.1.1 on
>> Windows 2003.
>>
>> Anyone know how to fix this?
>> Thanks
>>
>> The error log from failed uploads:
>> Lookoutbelow
>> An error was found on line '534' of script
>> 'E:\wamp\www\support\eventum\include\class.attachment.php'.
>>
>> The error message passed to us was:
>>
>> 'DB Error: unknown error'
>>
>> A more detailed error message follows:
>>
>> 'INSERT INTO
>>                     eventum.eventum_issue_attachment_file
>>                  (
>>                     iaf_iat_id,
>>                     iaf_filename,
>>                     iaf_filesize,
>>                     iaf_filetype,
>>                     iaf_file
>>                  ) VALUES (
>>                     11,
>>                     'analog_60w32.zip',
>>                     '1757232',
>>                     'multipart/x-zip',
>>
>> 'PK\n\0\0\0\0\0+"1\0\0\0\0\0\0\0\0\0\0\0\0\0\0analog
>> 6.0/UT
>> \0°ÅAEURÄÄAUx\0¢Ù
>> PK\0\0\0\0u"1+û,öEUR\0\0\0¤\0\0\0\0\0analog
>>
>> 6.0/SETUP.txtUT    \0ø'ÅAEURÄÄAUx\0¢Ù
>>
> 5̱Â0нRÿá~\nKþ?±+??6.?HíÊv$Ú¯\'qÛ?z(îαÈIÈxp0QB"'×=Ð>FJ1p?V¾ôÝÈæZgÏÂ+¨"Ìx4²QX}+ßê+a''HÛ÷l}++--«(v1ËS9~(Û_å++TEå3ïhû¤ò\"¾...¾û\0PK\n\0\0\0\0\0+"1\0\0\0\0\0\0\0\0\0\0\0\0\0\0analog
>>
>> 6.0/examples/U'..., (integer )0, true, (string
>> )'error', true, true)
>> E:\wamp\www\support\eventum\include\class.error_handler.php:127
>>   Mail_API->send((string
>> )'support@stripped', (string
>> )'curtis.vonlintel@stripped', (string
>> )'Eventum - Error found! -
>> 09/10/2008 16:11:42', (integer )0, true, (string
>> )'error')
>> E:\wamp\www\support\eventum\include\class.error_handler.php:75
>>   Error_Handler::_notify((string )'An error was found
>> on line '534' of
>> script
>> 'E:\wamp\www\support\eventum\include\class.attachment.php'.
>>
>> The error message passed to us was:
>>
>> 'DB Error: unknown error'
>>
>> A more detailed error message follows:
>>
>> 'INSERT INTO
>>                     eventum.eventum_issue_attachment_file
>>                  (
>>                     iaf_iat_id,
>>                     iaf_filename,
>>                     iaf_filesize,
>>                     iaf_filetype,
>>                     iaf_file
>>                  ) VALUES (
>>                     11,
>>                     'analog_60w32.zip',
>>                     '1757232',
>>                     'multipart/x-zip',
>>
>> 'PK\n\0\0\0\0\0+"1\0\0\0\0\0\0\0\0\0\0\0\0\0\0analog
>> 6.0/UT
>> \0°ÅAEURÄÄAUx\0¢Ù
>> PK\0\0\0\0u"1+û,öEUR\0\0\0¤\0\0\0\0\0analog
>>
>> 6.0/SETUP.txtUT    \0ø'ÅAEURÄÄAUx\0¢Ù
>>
> 5̱Â0нRÿá~\nKþ?±+??6.?HíÊv$Ú¯\'qÛ?z(îαÈIÈxp0QB"'×=Ð>FJ1p?V¾ôÝÈæZgÏÂ+¨"Ìx4²QX}+ßê+a''HÛ÷l}++--«(v1ËS9~(Û_å++TEå3ïhû¤ò\"¾...¾û\0PK\n\0\0\0\0\0+"1\0\0\0\0\0\0\0\0\0\0\0\0\0\0analog
>>
>> 6.0/examples/UT    \0ì°Å'..., (string
>> )'support@stripped',
>> (string )'curtis.vonlintel@stripped', (string
>> )'E:\wamp\www\support\eventum\include\class.attachment.php',
>> (integer )534)
>> E:\wamp\www\support\eventum\include\class.attachment.php:534
>>   Error_Handler::logError((array )Array, (string
>> )'E:\wamp\www\support\eventum\include\class.attachment.php',
>> (integer )534)
>> E:\wamp\www\support\eventum\include\class.attachment.php:478
>>   Attachment::addFile((integer )11, (string
>> )'analog_60w32.zip', (string
>> )'multipart/x-zip', (string )'PK
>>
>
>
>       Novos endereços, o Yahoo! que você conhece. Crie um email novo com
> a sua cara @ymail.com ou @rocketmail.com.
> http://br.new.mail.yahoo.com/addresses
>
>
Thread
File Uploads larger than 1mbCurtis Von Lintel10 Sep
  • Re: File Uploads larger than 1mbGeorger Araujo11 Sep
    • Re: File Uploads larger than 1mbCurtis Von Lintel11 Sep
      • SV: File Uploads larger than 1mbAnders Klarström11 Sep
Re: SV: File Uploads larger than 1mbGerman Pizarro11 Sep
  • Re: SV: File Uploads larger than 1mbBryan Alsdorf11 Sep
    • Re: SV: File Uploads larger than 1mbCurtis Von Lintel11 Sep
    • RE: SV: File Uploads larger than 1mbM  IN BLR SISL Srivathsan12 Sep
Re: SV: File Uploads larger than 1mbGerman Pizarro12 Sep
  • RE: SV: File Uploads larger than 1mbFaisal Siddiqui12 Sep
Re: SV: File Uploads larger than 1mbGerman Pizarro12 Sep
Re: SV: File Uploads larger than 1mbGerman Pizarro12 Sep
  • RE: SV: File Uploads larger than 1mbFaisal Siddiqui12 Sep
    • RE: SV: File Uploads larger than 1mbAndrew Coghlan12 Sep
Re: SV: File Uploads larger than 1mbGerman Pizarro12 Sep
  • Re: SV: File Uploads larger than 1mbGeorger Araujo12 Sep
    • RE: SV: File Uploads larger than 1mbFaisal Siddiqui14 Sep
      • RE: SV: File Uploads larger than 1mbGeorger Araujo14 Sep