When users click on the UserCP this error occurs.
I recently upgraded to MySQL 5.0, I'm thinking perhaps something is different in the mysql syntax on the new version..?
If I run this query manually (to ensure it's working on the right database) I get the same error.
If I check the thread table, the column 'threadid' does indeed exist.
URL: http://forums.deadgod.net/usercp.php
(Prolly need to login though)
Edit: vBulletin 3.5.0
Edit Edit: 3.5.1 patch applied, no luck.
Edit Edit Edit: full error attached below
I recently upgraded to MySQL 5.0, I'm thinking perhaps something is different in the mysql syntax on the new version..?
If I run this query manually (to ensure it's working on the right database) I get the same error.
If I check the thread table, the column 'threadid' does indeed exist.
URL: http://forums.deadgod.net/usercp.php
(Prolly need to login though)
Edit: vBulletin 3.5.0
Edit Edit: 3.5.1 patch applied, no luck.
Edit Edit Edit: full error attached below
Code:
Database error in vBulletin 3.5.0: Invalid SQL: SELECT thread.threadid, thread.forumid, IF(threadread.readtime IS NULL, 1132286050, IF(threadread.readtime < 1132286050, 1132286050, threadread.readtime)) AS threadread, IF(forumread.readtime IS NULL, 1132286050, IF(forumread.readtime < 1132286050, 1132286050, forumread.readtime)) AS forumread, thread.lastpost, subscribethread.subscribethreadid FROM thread AS thread, subscribethread AS subscribethread LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1) LEFT JOIN 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 : Sunday, November 27th 2005 @ 09:54:10 PM Script : http://forums.deadgod.net/usercp.php Referrer : http://forums.deadgod.net/ IP Address : 64.93.28.207 Username : LiQUiD_X Classname : vb_database
Comment