Announcement

Collapse
No announcement yet.

Can anyone help with this db error?

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

  • Carnage-
    replied
    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.

    Leave a comment:


  • Astra-SRi
    replied
    Never mind. I've upgraded to 3.5.2 and all is now well.

    Leave a comment:


  • Astra-SRi
    replied
    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?

    Leave a comment:


  • Floris
    replied
    Here are our online manual instructions on how to restore a vBulletin database:

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

    Leave a comment:


  • Astra-SRi
    replied
    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.

    Leave a comment:


  • Floris
    replied
    Why did you drop the database from the old server?

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

    Leave a comment:


  • Astra-SRi
    replied
    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

    Leave a comment:


  • Floris
    replied
    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

    Leave a comment:


  • Astra-SRi
    replied
    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.

    Leave a comment:


  • Floris
    replied
    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.

    Leave a comment:


  • Astra-SRi
    started a topic Can anyone help with this db error?

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X