For small sizes, files saved into the database are OK, but for filesbigger than 1MB,
wouldn't it be better to save them in the file system (blocked direct access via http,
but accesed via php proxy for authentication/authorization)?
Regards
----- Mensaje original ----
De: Anders Klarström <anders.klarstrom@stripped>
Para: "eventum-users@stripped" <eventum-users@stripped>
Enviado: jueves, 11 de septiembre, 2008 2:20:54
Asunto: SV: File Uploads larger than 1mb
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
>
>
--
Eventum Users Mailing List
For list archives: http://lists.mysql.com/eventum-users
To unsubscribe: http://lists.mysql.com/eventum-users?unsub=1
____________________________________________________________________________________
Yahoo! MTV Blog & Rock >¡Cuéntanos tu historia, inspira una
canción y gánate un viaje a los Premios MTV! Participa aquí
http://mtvla.yahoo.com/
