Bug Database Error since upgrading to 3.1.4

Status
Not open for further replies.

mirageboss

Customer
Database error in vBulletin 3.8.8:

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 = 672;

MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Thursday, August 21st 2014 @ 02:27:31 PM
Error Date : Thursday, August 21st 2014 @ 02:27:31 PM
Script : *REMOVED*
Referrer : *REMOVED*
IP Address : *REMOVED*
Username : *REMOVED*
Classname : vB_Database
MySQL Version : 5.5.37-cll

Removed some PII for confidentiality reasons, but getting this error ever since running the most recent upgrade?
I have disabled the plugin temporarily.
 
Status
Not open for further replies.

Legacy Advanced User Tagging

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
2,505
Customer rating
0.00 star(s) 0 ratings
Back
Top