viper357
Customer
I was running 1.0.11, upgraded to 1.0.14 and received a database error when clicking on any thread, I had to go back to 1.0.11 for my forum to work again.
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadread.readtime AS threadread, forumread.readtime AS forumread,
thread.*
, post.pagetext AS description
FROM thread AS thread
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND subscribethread.canview = 1)
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)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 52637;
MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Monday, May 5th 2014 @ 01:53:42 AM
Error Date : Monday, May 5th 2014 @ 01:53:42 AM
Script : http://www.marineaquariumsa.com/showthread.php?t=52637
Referrer : Marine Aquariums South Africa
IP Address : ******
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.73-cll
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadread.readtime AS threadread, forumread.readtime AS forumread,
thread.*
, post.pagetext AS description
FROM thread AS thread
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND subscribethread.canview = 1)
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)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 52637;
MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Monday, May 5th 2014 @ 01:53:42 AM
Error Date : Monday, May 5th 2014 @ 01:53:42 AM
Script : http://www.marineaquariumsa.com/showthread.php?t=52637
Referrer : Marine Aquariums South Africa
IP Address : ******
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.73-cll