Bug DB error in threads after upgrade

[motd2]

Test on localhost
Upgrade 3.1.3 to 3.1.4
if you go to any thread:

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,threadrate.vote,threadread.readtime AS threadread, forumread.readtime AS forumread,
			thread.*
			
			, post.pagetext AS description 
			FROM test_thread AS thread
			
			LEFT JOIN test_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1  AND subscribethread.canview = 1)
			LEFT JOIN test_threadrate AS threadrate ON (threadrate.threadid = thread.threadid AND threadrate.userid = 1)
			
				LEFT JOIN test_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
				LEFT JOIN test_forumread AS forumread ON (forumread.forumid = thread.forumid AND forumread.userid = 1)
			
			
			 LEFT JOIN test_post AS post ON(post.postid = thread.firstpostid) 
			WHERE thread.threadid = 4310;

MySQL Error   : Column 'visible' in field list is ambiguous
Error Number  : 1052
Request Date  : Monday, August 18th 2014 @ 05:25:26 PM
Error Date    : Monday, August 18th 2014 @ 05:25:28 PM
Script        : http://localhost/forum/showthread.php?t=4310
Referrer      : http://localhost/forum/forumdisplay.php?f=5
IP Address    : 127.0.0.1
Username      : motd2
Classname     : vB_Database
MySQL Version : 5.5.38-log

if you turn off Advanced User Tagging - all displayed
if you install v3.1.3 - all displayed

 

[Fillip H.]

You can disable the plugin for this mod running at fetch_threadinfo_query, although some functionality may be lost as a result.

 

[mirageboss]

But why are we getting the error and how do we fix as you stated?

 

[mirageboss]

Never mind! Fixed