Announcement

Collapse
No announcement yet.

Impex Attachment Crash

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Impex Attachment Crash

    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:

    Code:
    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

  • #2
    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.
    I wrote ImpEx.

    Blog | Me

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X