The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
database error help needed please!!
Hi my host has just upgraded to Mysql5.0.21-standard and PHP5.1.4
and now i'm getting a database error, clicking the userCP in the navbar the error returned is as follows Code:
Database error in vBulletin 3.5.0: Invalid SQL: SELECT thread.threadid, thread.forumid, IF(threadread.readtime IS NULL, 1147835566, IF(threadread.readtime < 1147835566, 1147835566, threadread.readtime)) AS threadread, IF(forumread.readtime IS NULL, 1147835566, IF(forumread.readtime < 1147835566, 1147835566, forumread.readtime)) AS forumread, thread.lastpost, subscribethread.subscribethreadid FROM sg_thread AS thread, sg_subscribethread AS subscribethread LEFT JOIN sg_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1) LEFT JOIN sg_forumread AS forumread ON (forumread.forumid = thread.forumid AND forumread.userid = 1) WHERE subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND thread.visible = 1 HAVING thread.lastpost > IF(threadread > forumread, threadread, forumread); MySQL Error : Unknown column 'thread.threadid' in 'on clause' Error Number : 1054 Date : Saturday, July 15th 2006 @ 11:12:46 PM Script : http://www.sats-general.com/forum/usercp.php Referrer : http://www.sats-general.com/forum/index.php? IP Address : xxxxxxxxxxxxxxx Username : Rickie3 Classname : vB_Database |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|