Bug Database Errors with new update

[viper357]

Hi, just updated to 3.1.4 lite and it caused database errors when clicking on any thread. I had to go back to 3.1.3 to get my forum running again.

Some of the DB errors

Database error in vBulletin 3.8.5:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*

, post.pagetext AS description
FROM thread AS thread





LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 33878;

MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Wednesday, August 27th 2014 @ 10:36:52 AM
Error Date : Wednesday, August 27th 2014 @ 10:36:52 AM
Script : 12v Circulation Pump - Marine Aquariums South Africa
Referrer : https://www.google.co.za/
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :

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

MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Wednesday, August 27th 2014 @ 10:36:44 AM
Error Date : Wednesday, August 27th 2014 @ 10:36:44 AM
Script : http://www.marineaquariumsa.com/large-tanks/55009-setup-new-post.html
Referrer : Marine Aquariums South Africa
IP Address :
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.73-cll

 

[Fillip H.]

I have uploaded a temporary fix to /dbtech/usertag/hooks/fetch_threadinfo_query.php

This will temporarily create an invalid display in the Thread Tagging email, which will be corrected in the next version.