No announcement yet.

Database error in vBulletin 3.0.6:

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in vBulletin 3.0.6:

    I get this error emailed to me when my users are clicking "user cp":

    Database error in vBulletin 3.0.6:
      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 = 817
                 AND thread.visible = 1
                 AND lastpost > 1196111864
                 AND deletionlog.primaryid IS NULL
      mysql error: Unknown column 'thread.threadid' in 'on clause'
      mysql error number: 1054

    The error came up when my mysql was upgraded from 4.x to 5.x...
    And yes, I will upgrade to 3.6.x (just renewd my licens... )
    But I need this to work while I'm prepering to upgrade...

  • #2
    I do not think vBulletin version 3.0.x is compatible with php 5.x and mysql 5.x newer version.

    I also do not know if you would be able to create a backup in newer mysql version without any troubles. I have not been able to test to see what will result if you were to try to backup in a non-capatible version. I will wait till you get an answer from Staff that know if you can just upgrade or you can backup in newer mysql version without a hickup.
    Last edited by Jose Amaral Rego; Tue 27 Nov '07, 3:29pm. Reason: More infromation


    • #3
      Jose is right about the compatibility issue. You'll need to upgrade to 3.6.8.
      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.


      • #4
        Ok, thanks!


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