Impex Attachment Crash

[sdotson]

The importing of a large phpbb2 board has gone reasonable well until I got to the attachments. It get through about 300 of them then bombs with the following message:


UPDATE vb_attachment
SET
filedata = '%PDF-1.2
%âãÏÓImpEx Database errormysql error: Invalid SQL:

2 0 obj
<<
/Type/ExtGState
/HT/Default
>>
endobj
3 0 obj
<<
/Length 32216
/Type /XObject
/Subtype /Image
/Name /Im1
/Width 714
/Height 90
/BitsPerComponent 8
/ColorSpace/DeviceRGB
/Filter[/ASCII85Decode/DCTDecode]
>>

<snip>

filesize = 1930751
WHERE attachmentid = 104


mysql error: MySQL server has gone away

mysql error number: 2006

Date: Tuesday 27th 2007f November 2007 12:13:47 PM
Database: cdotson
MySQL error: I have already bumped the MYSQL max_packet_size up pretty high.

Any suggestions?

Also I'm not seeing the imported data in my forums. It says it successfully imported 1000s of posts but there are no posts when I view the forums.

Thanks, -Sean

[Jerry]

mysql error: MySQL server has gone away

That is a server issue meaning the database is failing.

I would change the vBulletin attachment storage type to the file system and not the database before the import, use the file system over the database for most set ups.