Announcement

Collapse
No announcement yet.

MYSQL usercp error after server move and database backup... PLEASE HELP!

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

  • MYSQL usercp error after server move and database backup... PLEASE HELP!

    All users now get a similar error on our forums whenever attempting to use usercp...

    PLEASE HELP!

    Database error in vBulletin 3.0.8:
    Invalid SQL:
    SELECT thread.threadid, thread.forumid
    FROM thread AS thread, subscribethread AS subscribethread
    LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
    WHERE subscribethread.threadid = thread.threadid
    AND subscribethread.userid = 1
    AND thread.visible = 1
    AND lastpost > 1140021559
    AND deletionlog.primaryid IS NULL

    mysql error: Unknown column 'thread.threadid' in 'on clause'
    mysql error number: 1054
    Date: Wednesday 15th of February 2006 11:45:11 AM
    Script:
    http://www.topshelfexotic.com/vbulletin/usercp.php?
    Referer: xxxxxxxxxxxxxxxxxxxx

    Username: xxxxxxxxx
    IP Address: xxxxxxxxxxxx

    Chris Johnson
    Top Shelf Exotics
    LeoMorphs.com
    TSE Hosting

  • #2
    It would appear that the database was not correctly backed up and restored. Do you still have access to the old db?
    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
      yes i beleive I do, any particular method I should take to ensure it is done correctly?

      also, everything else seems to be working flawlessly, is it possible it is something else??

      thanks
      Chris Johnson
      Top Shelf Exotics
      LeoMorphs.com
      TSE Hosting

      Comment


      • #4
        The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

        Backup:
        http://www.vbulletin.com/docs/html/m...nce_ssh_backup

        Restore:
        http://www.vbulletin.com/docs/html/m...ce_ssh_restore

        This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.
        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

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