[Bigj85]

getting this error after I set permissions for my group and try to visit the market

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT *, COUNT(marketid) FROM vbmarket_transactions
GROUP BY marketid ORDER BY COUNT( marketid ) DESC LIMIT 0 , 1;

MySQL Error : Invalid use of group function
Error Number : 1111

any ideas what I'm doing wrong?
thx

EDIT: nevermind I just saw some previous posts about it not working on mysql version