
01-27-2007, 11:21 AM
|
|
|
Join Date: Jul 2004
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Fist time trying to install anything like this so I might just be missing something out, I'm gretting this error.
Quote:
Database error in vBulletin 3.6.4:
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 = 0 AND visible = 1
ORDER BY dateline DESC
LIMIT 3;
MySQL Error : Column 'visible' in where clause is ambiguous
Error Number : 1052
|
Can anyone help me? T.I.A.
|