Bug Database Errors with new update

Status
Not open for further replies.

viper357

Customer
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
 
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.
 
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,502
Customer rating
0.00 star(s) 0 ratings
Back
Top