I've done my best to search on a fix, but nothing so far. My first post, as Vbulletin has worked flawlessly for nearly 2 years for me.
When any user clicks/access usercp.php directly I get a database error.
I've backed up, optimized. I even replaced the usercp.php with a freshcopy, to no evail. Any assitance would be very apprecaited. Thank you.
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT thread.threadid, thread.forumid
FROM rt_thread AS thread, rt_subscribethread AS subscribethread
LEFT JOIN rt_deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE subscribethread.threadid = thread.threadid
AND subscribethread.userid = 1
AND thread.visible = 1
AND lastpost > 1145715016
AND deletionlog.primaryid IS NULL
mysql error: Unknown column 'thread.threadid' in 'on clause'
mysql error number: 1054
Date: Saturday 22nd of April 2006 05:37:21 PM
Script: http://www.route204.com/forums/usercp.php?
Referer: http://www.route204.com/forums/index.php?
Username: Senza
IP Address: 142.161.171.121
When any user clicks/access usercp.php directly I get a database error.
I've backed up, optimized. I even replaced the usercp.php with a freshcopy, to no evail. Any assitance would be very apprecaited. Thank you.
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT thread.threadid, thread.forumid
FROM rt_thread AS thread, rt_subscribethread AS subscribethread
LEFT JOIN rt_deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE subscribethread.threadid = thread.threadid
AND subscribethread.userid = 1
AND thread.visible = 1
AND lastpost > 1145715016
AND deletionlog.primaryid IS NULL
mysql error: Unknown column 'thread.threadid' in 'on clause'
mysql error number: 1054
Date: Saturday 22nd of April 2006 05:37:21 PM
Script: http://www.route204.com/forums/usercp.php?
Referer: http://www.route204.com/forums/index.php?
Username: Senza
IP Address: 142.161.171.121
Comment