any ideas what would cause this error?
Code:
Database error in vBulletin 3.8.2:
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 = 54;
MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Thursday, August 28th 2014 @ 07:13:34 PM
Error Date : Thursday, August 28th 2014 @ 07:13:34 PM
Script : http://www.********.com/forum/showthread.php?goto=newpost&t=54
Referrer : http://www.********.com/forum/index.php
IP Address : ******
Username : harry
Classname : vB_Database
MySQL Version : 5.5.37-cll
tried disabling all plugins but mentions, tried a fresh install of vbulletin and uninstalled and reinstalled countless times
I've got an idea it's something to do with my php or mysql version? Just wanted to see if anyone has any suggestions before I give up all hope, cheers :up: