Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT * , thread.forumid
FROM dbtech_usertag_mention AS dbtech_usertag_mention
LEFT JOIN post AS post USING(postid)
LEFT JOIN thread AS thread USING(threadid)
WHERE 1=1
AND dateline >= 1280638800 AND dbtech_usertag_mention.userid = 1;
MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Request Date : Sunday, November 20th 2011 @ 10:51:28 PM
Error Date : Sunday, November 20th 2011 @ 10:51:34 PM
Script : Log in - Personality Nation - vBulletin Admin Control Panel
Referrer : Log in - Personality Nation - vBulletin Admin Control Panel
IP Address : 71.207.220.171
Username : Limit
Classname : vB_Database
MySQL Version : 5.1.58-1~dotdeb.0
Invalid SQL:
SELECT * , thread.forumid
FROM dbtech_usertag_mention AS dbtech_usertag_mention
LEFT JOIN post AS post USING(postid)
LEFT JOIN thread AS thread USING(threadid)
WHERE 1=1
AND dateline >= 1280638800 AND dbtech_usertag_mention.userid = 1;
MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Request Date : Sunday, November 20th 2011 @ 10:51:28 PM
Error Date : Sunday, November 20th 2011 @ 10:51:34 PM
Script : Log in - Personality Nation - vBulletin Admin Control Panel
Referrer : Log in - Personality Nation - vBulletin Admin Control Panel
IP Address : 71.207.220.171
Username : Limit
Classname : vB_Database
MySQL Version : 5.1.58-1~dotdeb.0