vBulletin 3.8.0 Beta 2 Released

[memomemo]

Hello

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