7 messages in com.mysql.lists.eventum-usersProblems with huge attachments
FromSent OnAttachments
Frank Tilmans29 Aug 2006 02:58 
Srivathsan, M IN BLR SISL29 Aug 2006 03:08 
Frank Tilmans29 Aug 2006 03:30 
Tibor Gellert29 Aug 2006 03:43 
Frank Tilmans30 Aug 2006 04:00 
Frank Tilmans31 Aug 2006 00:19 
Frank Tilmans01 Sep 2006 08:01 
Subject:Problems with huge attachments
From:Frank Tilmans (tilm@incas-voice.de)
Date:08/29/2006 02:58:03 AM
List:com.mysql.lists.eventum-users

Hi,

this morning I found out that I couldn't reply to an associated email. I got a very blank page. Also, when I clicked on the plus (+) in the associated email list I got an javascript error. The issue had an attachment with a size of 4MB, so my first thought was: It's too great. All entries in php.ini and mysql.ini where changed to 8MB. So where's the problem?

After a little bit testing I found out, that it was indeed the huge attachment. Sending another email with a 4MB attachment to a testproject caused the same problem.

So I looked into the database with phpmyadmin. But I had problems to open the related entries in the tables eventum_issue_attachment_file and eventum_support_email_body. The only way to solve it was to delete the entry in eventum_issue_attachment_file and to update the column seb_full_email in eventum_support_email_body to any text.

Is it possible that MySQL cannot handle with such huge entries?

Is there a way to save attachments in folders and to save in the database the link to this file instead of saving the attachment in the database?