AW: Problems with huge attachments - Frank Tilmans - com.mysql.lists.eventum-users

7 messages in com.mysql.lists.eventum-usersAW: Problems with huge attachments

From	Sent On	Attachments
Frank Tilmans	29 Aug 2006 02:58
Srivathsan, M IN BLR SISL	29 Aug 2006 03:08
Frank Tilmans	29 Aug 2006 03:30
Tibor Gellert	29 Aug 2006 03:43
Frank Tilmans	30 Aug 2006 04:00
Frank Tilmans	31 Aug 2006 00:19
Frank Tilmans	01 Sep 2006 08:01

Subject:	AW: Problems with huge attachments
From:	Frank Tilmans (tilm...@incas-voice.de)
Date:	08/31/2006 12:19:28 AM
List:	com.mysql.lists.eventum-users

It's a little bit strange. I hope that the problem can be solved.

Okay, first of all, it seems that phpmyadmin cannot handle with large files. I uploaded a 4MB file with phpmyyadmin directly to MySQL. The upload failed, the inserted data cannot or will not be found. But something was uploaded. As long as I don't delete this entry I have problems with the table where I inserted the large file.

A colleague gave me the hint to install Firefox and the AddOn FireBug. With that I can see xml http requests. Well I did so, sent an email with a 4MB to eventum and an issue was created. Under Attached Files I can see the attachment and I can open ist. That's good. The attachment was successfully saved in MySQL.

But, unfortunately, I cannot click on the plus in Associated Emails to open/load the email details. Neither I can click on the reply icon nor on the subject line to open the email detail window. I get an empty popup. By clicking on the plus Firefox and FireBug returned the following error:

GET http://[urltoeventum]/get_remote_data.php?action=getEmail&ec_id=email&li st_id=8-263

Reponse tab is empty currentDiv has no properties - expandCell view.php?id=288 (line 232) - handleCallback view.php?id=288 (line 232) - anonymous view.php?id=288 (line 226) - anonymous view.php?id=288 (line 152) - anonymous view.php?id=288 (line 152) - anonymous view.php?id=288 (line 185) - anonymous view.php?id=288 (line 161) - anonymous firebug.js (line 951) - anonymous firebug.js (line 2049)

It seems that the select function which is called in get_remote_data.php at line 63 (Support::getEmailDetails) failed. The data cannot be selected from the MySQL table.

I hope that these informations can help in solving this problem. Or anybody can give me a hint what I have to do. Maybe reinstall MySQL? Or I have to set the maximum limit to 2MB.

Hi Bryan,

thanks for your email.

I increased memory_limit to 64, and then to 128M. I checked the value by calling the ini_get function. After that I could upload a file with a size of 3.5MB. Unfortunately, I couldn't open the email by clicking the plus in Associated Emails. Looking with phpmyadmin into the table eventum_issue_attachment_file I got the same problems. I couldn't select the database entry with the huge file directly. Also, selecting the last 5 entries (i.e. with a select clause iaf_iat_id > 70) didn't work correctly.

When I create an export with phpmyadmin the export stops at this entry. The following entries in the table and all other tables below aren't exported, too.

Maybe it's a general problem with MySQL? Btw, version 3.23.54 is installed, PHP version is 4.4.0.

Frank,

Frank Tilmans wrote:

Hi Tibor,

as I wrote in my first email the limits were changed up to 8MB. The entries are:

php.ini: memory_limit: 16MB upload_max_filesize: 8MB post_max_size: 8MB max_input_time: 300

upload_max_filesize and post_max_size deal with uploads from a browser, not email attachments. Everytime you go to view an email, we use the mime_decode class to parse the email. Unfortunately, this class is very wasteful, and can take between 2 and 5 times the memory. Just for testing purposes, try increasing the memory limit in php.ini, and seeing if it works. You can also just increase it in config.inc.php by calling ini_set('memory_limit', '64M');

/bryan