Attachment Help needed

[Khalid-B]

Hello.

I am getting error when i try to attach MP3 files.
i am getting this erro.

Fatal error: Allowed memory size of 23068672 bytes exhausted (tried to allocate 4712039 bytes) in /home/user/public_html/forum/includes/class_core.php on line 3139

How can i fix this issue?

Plz help.

Thank you

[Marco van Herwaarden]

You will need to raise the PHP memory limit. You might have to contact your host about this.

[Khalid-B]

Hi.

I followed your instructions nad increased memory limmite and now getting database error.

Invalid SQL:
INSERT INTO attachment
(dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)
VALUES
(1216895199, 1216895199, 1, 1, 'mp3', 'song.mp3', '16c07d00ac44b4abdc8f133e1cd42ccc', '5c150877203d3cb159416c9dc764f51a', 2279519, 'ID3 \0\0\0\0 vPRIV\0\0\0 \0\0PeakValue\0? \0\0PRIV\0\0\0 \0\0AverageLevel\


Thanks for the help.

[Marco van Herwaarden]

Please provide the full error mesage.

[Khalid-B]

hi.
its too long and so gonna attach it.
plz check attach file

thank you

[Marco van Herwaarden]

That is still missing the important last few lines.

[Opserty]

Delete the big load of stuff in the middle. All the text before and after it is what we need.

[Khalid-B]

hi.

well i got this in my email and i just copied and pasted so there is no line missing any more as i seen again in my email.

Thank You

[Marco van Herwaarden]

Please test again with a small and a large attachement. Does it only happen with a large attachment?

You might need to change some other settings like Max Post Size (PHP) and the MySQL maximum size.

[Khalid-B]

Hi.
hi i treid as u said and still same error and here are the sizes that u asked..

PHP Max Post Size 1,000.00 MB
PHP Maximum Upload Size 1,000.00 MB
PHP Memory Limit 32.00 MB
MySQL Version 5.0.51a-community
MySQL Packet Size 1.00 MB


Thank you

--------------- Added 1216901057 at 1216901057 ---------------

Delete the big load of stuff in the middle. All the text before and after it is what we need.


here it is as u said.

Invalid SQL:
INSERT INTO attachment
(dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)
VALUES
(1216900745, 1216900745, 1, 1, 'mp3', 'terebin sanu.mp3', '5f4c3acf322574b1b6a2b081cd9e8a36', '55d3091366abf22cbbb00dfbed98df3b', 1982505, 'ID3 \0\0\0\0\0


Thank you

[Marco van Herwaarden]

I would start by raising the MySQL packet size.

[Khalid-B]

Hi.

its working fine for me know without changing any thing.
i just moved attachemet folder from database to a folder and its work fine now .

Thanks a lot both u guys for giving me some good suggestions.

Thanks
-------- SOLVED ------

[Marco van Herwaarden]

That indicates, like already suspected, that it was a MySQL limit. The large attachments are now not stored in the database anymore, thus the MySQL limits can be set at a lower value.