Announcement

Collapse
No announcement yet.

Error when import attachment from SMF 1.1.5

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

  • Error when import attachment from SMF 1.1.5

    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˜\0L@ ¬¸Ø @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

  • #2
    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.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


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

      Thanks

      Comment


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

        I wrote ImpEx.

        Blog | Me

        Comment

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