Announcement

Collapse
No announcement yet.

cannot complete attachment move to file system

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

  • [Forum] cannot complete attachment move to file system

    I have about 168mg of attachments that I moved into the database during the upgrade process from 3.8.5 to 4.0.3 in order to avoid the "path not found" error I was getting during vb4 installation process. After successfully moving attachments into the database I was able to complete the upgrade to 4.0.3 successfully.

    I've been trying to move the attachments back to the file system, the folder is chmod 777 and the path is correct. The process simply goes to a out of memory database error as shown below and in the attached image. I don't want to leave these attachments in the database so is there anything that can be done?

    Code:
    Database error in vBulletin 4.0.3:
    
    Invalid SQL:
    
            SELECT filedataid, filedata, filesize, userid, thumbnail
            FROM vbfiledata
            WHERE filedataid >= 3 AND filedataid < 303
            ORDER BY filedataid ASC;
    
    MySQL Error   : Lost connection to MySQL server during query
    Error Number  : 2013
    Request Date  : Friday, April 16th 2010 @ 12:56:47 PM
    Error Date    : Friday, April 16th 2010 @ 12:56:55 PM
    Script        : http://www.dflgaming.com/admincp/attachment.php?do=domoveattachment
    Referrer      : http://www.dflgaming.com/admincp/attachment.php?do=doswitchtype
    IP Address    : 71.56.148.173
    Username      : sHooter
    Classname     : vB_Database_MySQLi
    MySQL Version :
    Click image for larger version

Name:	attach.jpg
Views:	1
Size:	56.4 KB
ID:	3715668

  • #2
    What is your max_allowed_packet setting in your /etc/my.cnf file?

    Comment


    • #3
      Originally posted by Andy View Post
      What is your max_allowed_packet setting in your /etc/my.cnf file?
      16777216, data from vb diagnostics in admincp. I'm on a shared host, hostgator.

      Comment


      • #4
        Originally posted by shooterdfl View Post
        16777216, data from vb diagnostics in admincp.
        That is the same number I have.

        Have you called hostgator to ask if they can help?

        Comment

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