Error when import attachment from SMF 1.1.5

[Jerry]

Configure vBulletin to use the filesystem for attachments opposed to the database before the import.

http://www.vbulletin.com/docs/html/m...chment_storage

[Syscomp]

is there any other way to use attachment without import to database ?

Thanks

[Steve Machol]

This is a server issue. You or your host will need to increase the 'max_allowed_packet' in my.cnf, then restart MySQL. I recommend at least 32M for this setting. If that doesn't work, try 64M.

[Syscomp]

Hello,

I got error while converting the attachment
Full path /home/user/public_html/attachments

The result

ImpEx Database errormysql error: Invalid SQL:
UPDATE attachment
SET
filedata = 'Rar!\0ϐs\0\0
\0\0\0\0\0\0\0Ñ^t E\0ÅT\0^}\0»Œ£öª/83 \0 \0\0InfinityUpdate_BModule_v1.30.exe\0°ˆÙ\\ÕQ‰˜*úd²t݁€@bQN˜„€Hà
@¸Y.ÁN˜Bå$$ª:#rc$¢(ˆ¸8@ƒ˜8¹‰˜¸¢¦€[email protected]#ˆ¬Á»n+†ï•W!%ôMï•W$_Îyçí{¯<Ö½÷^Z—\\ìÞ÷Íôó|å\\ÿ\'¿à šùóî÷΋©Ê»«4ZÿÅ1˜\[email protected] ¬¸Ø @84À@\0\0‰Ð€¬—b†\\ÉÉ/HȪ˜•rˆªÉ[\0 «j5X¢H!°‘ô¸þ=‡Â˜? 0\0\"#¥à3H0„éá.ͺ}H+k(ëœ-’)‰Çîà\0?ñÊÇý
€#àlŠLWdNæíÏ7…8¸Òðrœ0]¯»W³vø»mâL½©›c1;
.
.
.
.
filesize = 1660197
WHERE attachmentid = 1


mysql error: Got a packet bigger than 'max_allowed_packet' bytes

mysql error number: 1153

Date: Wednesday 07th 2009f January 2009 01:20:56 PM
Database: bestnche_demo
MySQL error:

Need help about this

Thanks