Hi,
I keep getting this error:
Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;
MySQL Error : Column 'dateline' in order clause is ambiguous
Error Number : 1052
Is this because I use 3.6.1?
|