No announcement yet.

Please help, Database Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Please help, Database Error

    Okay, i just changed hosts, and i implamented my database from my old host to my new host, and now when i click on any topic or try to view any thread i get this error.

    Database error in vBulletin 3.6.5:
    Invalid SQL:
                IF(votenum >= 1, votenum, 0) AS votenum,
                IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
             post.pagetext AS preview,
                thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
                thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
                hiddencount, deletedcount
                , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
                , threadredirect.expires
                , post.pagetext AS previewbbcode
            FROM thread AS thread
                LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                 LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
                LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                LEFT JOIN threadredirect AS threadredirect ON( = 10 AND thread.threadid = threadredirect.threadid)
            WHERE thread.threadid IN (0,1628,93,107,9,1261,114,1000,23) 
            ORDER BY sticky DESC, lastpost DESC;
    MySQL Error  : Table 'merlin_forum.deletionlog' doesn't exist
    Error Number : 1146
    Date         : Thursday, May 3rd 2007 @ 09:09:19 AM
    Script       :
    Referrer     :
    IP Address   :
    Username     : MERLiN
    Classname    : vb_database

  • #2
    This looks like the database was not transfered completly. Are there any more tables missing (check old and new server with phpMyAdmin)?
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications:


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