PDA

View Full Version : Error when import attachment from SMF 1.1.5


Syscomp
Wed 7th Jan '09, 2:27pm
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\0T\0^}\0ª/83 \0 \0\0InfinityUpdate_BModule_v1.30.exe\0\\Q*d t݁@bQNH
@Y.NB$$:#rc$(8@82@Db#n+ W!%MW$_y{<ֽ^Z\\|\\\'΋ʻ4Z1\0L@ @84@\0\0Ѐb\\/HȪr[\0 j5XH!=˜? 0\0\"#3H0.ͺ}H+k(-)\0?
#lLWdN78ҏr0]WvmLc1;
.
.
.
.
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
Steve Machol
Wed 7th Jan '09, 2:35pm
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
Wed 7th Jan '09, 2:39pm
is there any other way to use attachment without import to database ?

Thanks
Jerry
Wed 7th Jan '09, 2:45pm
Configure vBulletin to use the filesystem for attachments opposed to the database before the import.

http://www.vbulletin.com/docs/html/main/attachment_storage