What Causes This Error Message?

[rnmcd]

Any idea how I can resolve this?

 

Here is an error message I get when I try to upload a file (attachment) into a vbulletin forum:

 

Database error in vBulletin 3.6.4:

Invalid SQL:

INSERT INTO attachment

(dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)

VALUES

(1176246436, 1176246436, 1, 25, 'zip', 'addrcial_csv.zip', '0759a59bebd6acfc62df251a18d06ffb', 'dbe8706c97b5bbaf4002c706f73bb15c', 1149811, 'PK\

¹ûqljÚJ”}4™\Z½”ÍR‹]gUÒ ãÙ­¬z†Ò´§Õ€ /;¢­åþ€²©¥ÆY…ôUVu{AP–=á`fÙªû°»4Y«eFPþFÉÈT$<æ ÄÑšØvA_ùÇÕŽ‹ß¼£Ñì72‚Ÿ²€üãÆ€(±½ê-F“¢ã… ©P|±–¯‰¼¹ä4°L™ÍÆ2áJ˜äÁ®$ØCê„ñÜ_

‰(‹Ý>‡Ñ™bkæ)åò ɯóÒeW4].1,ŠŸúB&áOøá6•2?ò”[?°s×Íœ·‰qˆñ>ÖáÁ‚°#^F,I®Å†\\#î V Zÿ-O¸ÁØzõ†¿Mf:g>–ê&ÆûÀü&Eppwq{Våm?†Bý]½³.ŸúçðJw­Z\'úPK\—¤}6\Z ümP+w\\\ \\\5-digit addrcial_csv.csvPK\1MÅ4“„‚Ö

\©\'\\n\\\ \nreadme.htmPK\7n!5˜ˆQM “$\\r\\\ \.zMSA Codes.txtPK\\·\¦Š\\');

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

Error Number : 1153

Date : Tuesday, April 10th 2007 @ 07:07:16 PM

Script : http://www.xxxxxx.com/boards/newattachment...geattach&p=

Referrer : http://www.xxxxxx.com/boards/newattachment...176246401&p osthash=0759a59bebd6acfc62df251a18d06ffb

IP Address : 68.4.111.47

Username : Me

Classname : vb_database

[TCH-Dick]

How large is the file you are trying to add to the DB?

 

 

The error you are seeing is because your query packet size(the amount of data you sent) is larger than the allowed setting in the MySQL configuration.

You will need to open a ticket to have us check the server setting. If the query you are trying to send is extremely large, we may not be able to increase the setting to accommodate it.

[rnmcd]

How large is the file you are trying to add to the DB?

The error you are seeing is because your query packet size(the amount of data you sent) is larger than the allowed setting in the MySQL configuration.

You will need to open a ticket to have us check the server setting. If the query you are trying to send is extremely large, we may not be able to increase the setting to accommodate it.

 

The file is 1.3 MB.

 

Is that considered 'too large'?

[YoLoL]

The file is 1.3 MB.

 

Is that considered 'too large'?

so... what's the max_allowed_packet size for mysql?

[TCH-Bruce]

Easiest way to get that answer is open a ticket with the help desk.

[YoLoL]

Thanks, I just did. Just to leave it documented, it may be useful to someone else, max_allowed_packet is 1Mb and it can't be increased on a shared server.