Database error in vBulletin 3.0.6:

[pyd]

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...

[Jose Amaral Rego]

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.

[Steve Machol]

Jose is right about the compatibility issue. You'll need to upgrade to 3.6.8.

[pyd]

Ok, thanks!