[almac]

Database error in vBulletin 3.6.2:

Invalid SQL:
 
		SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle, post.pagetext AS preview 
		FROM forum f 
		INNER JOIN thread t ON t.forumid = f.forumid
		LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid = 82 AND visible = 1
		ORDER BY dateline DESC 
		LIMIT 10;

MySQL Error  : Column 'visible' in where clause is ambiguous
Error Number : 1052
Date         : Monday, January 22nd 2007 @ 01:10:59 AM
Referrer     : 
IP Address   : 72.234.55.40
Username     : Jesse
Classname    : vb_database

Running on:
PHP version 4.4.3
MySQL 4.1.21-standard


And its in my root.
MySQL version 4.1.21-standard