Announcement

Collapse
No announcement yet.

Can anyone help with this db error?

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

  • Can anyone help with this db error?

    I have just moved servers, installed vb3.0.8 and had my database restored, but now the UserCP isn't working. It just gives this error:

    ____________________________________________________
    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 > 1134669616
    AND deletionlog.primaryid IS NULL

    mysql error: Unknown column 'thread.threadid' in 'on clause'

    mysql error number: 1054

    Date: Thursday 15th of December 2005 06:25:34 PM
    Script: http://forums.astra-sri.co.uk/usercp.php?
    Referer: http://forums.astra-sri.co.uk/online...e&pp=25&page=1
    Username: RiK
    IP Address: 82.38.194.200
    ____________________________________________________

    Any help is much appriciated.

    Thanks
    Rik

  • #2
    What you did was the incorrect path to move from one server to another.

    You have to move the files from the old server to the new server. Update the config.php file to point to the new database, and restore the old database.

    Don't do a fresh installation first, and then restore the database. This will cause problems.

    To fix this now, drop the current database, make sure the files you run are of the same version as on the old server. And restore the backup of the old database again. Update config.php and you're set. No need to run upgrade.php or install.php

    That said, once everything works, I suggest to upgrade to 3.5.2.

    Comment


    • #3
      Thanks for the help.

      Unfortunately I didn't have the option to copy the files from my old server as their drives have failed and as yet no backups have been restored so it was a rush job to get set up on a new server.

      Comment


      • #4
        If you were running 3.0.8, you can download the .zip from the members area and use those files. Just don't run install.php or upgrade.php, simply restore the database backup.sql

        Comment


        • #5
          Hi,

          I managed to get access to my old server, so I deleted vB from my host and dropped the db. Then I transferred all the files from my old server and imported my vbulletin.sql file, but I'm still getting the same error?

          Any ideas?

          Thanks

          Comment


          • #6
            Why did you drop the database from the old server?

            I hope you made a backup first, and then did a drop database?

            Comment


            • #7
              Sorry, I meant I deleted the vB and dropped the db on my new server so I could start again. Copied all the files from my old server and uploaded the to the new one. But I'm using a 5 day old backup of the db as when my old host died they lost my db.

              Comment


              • #8
                Here are our online manual instructions on how to restore a vBulletin database:

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

                Comment


                • #9
                  I have got the database restored and evrything works except the userCP which gives this error:
                  __________________________________________________ __
                  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 > 1134669616
                  AND deletionlog.primaryid IS NULL

                  mysql error: Unknown column 'thread.threadid' in 'on clause'

                  mysql error number: 1054

                  Date: Thursday 15th of December 2005 06:25:34 PM
                  Script: http://forums.astra-sri.co.uk/usercp.php?
                  Referer: http://forums.astra-sri.co.uk/online...e&pp=25&page=1
                  Username: RiK
                  IP Address: 82.38.194.200
                  __________________________________________________

                  Thats what I need help fixing?

                  Any ideas?

                  Comment


                  • #10
                    Never mind. I've upgraded to 3.5.2 and all is now well.

                    Comment


                    • #11
                      out of interest what mysql version are you running, i just moved a forum from one server to another and got exactly the same problem. I did import the database correctly.
                      Some of my Mods:
                      Advanced IP Ban Manager (vb3.6+ version) - Fine grained control over blocking trouble makers.
                      Advanced IP Ban Manager (vb4 version) - Fine grained control over blocking trouble makers.
                      Use Original thread for Comments - Uses the original thread for comments for any forum threads promoted to CMS articles.
                      Custom Friendly Urls - Allows customisation of forum urls from the admin CP.

                      Comment

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