Delete visitor messages sent by User clik for in admincp but error
Database error in vBulletin 3.8.0 Beta 2:
Invalid SQL:
SELECT user.userid, COUNT(*) AS total
FROM visitormessage AS vm
LEFT JOIN user AS user ON (user.userid = vm.userid)
WHERE userid IN (13,19,26,27,36,52,103,1648,2010,2772,3247,4591,54 68,6646,8006,8297,8339,10846)
AND vm.messageread = 0
AND vm.postuserid = 8297
GROUP BY user.userid;
MySQL Error : Column 'userid' in where clause is ambiguous
Error Number : 1052
Request Date : Wednesday, November 12th 2008 @ 02:57:35 PM
Error Date : Wednesday, November 12th 2008 @ 02:57:36 PM
Script : http://www.yaprakforum.com/forum/adm...do=killsentvms
Referrer : http://www.yaprakforum.com/forum/adm...sentvms&u=8297
IP Address : 88.235.29.232
Username : Admin
Classname : vB_Database
MySQL Version : 6.0.0-alpha-community-nt-debug
11-12-2008, 07:33 PM
Threaded Mode