[Bigj85]

I just uninstalled,reuploaded all files and then reimported the product and the same error,I've tried with ucash and kbank just to see if it would make a difference but nothing

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
Request Date : Sunday, May 16th 2010 @ 01:21:40 AM
Error Date : Sunday, May 16th 2010 @ 01:21:40 AM
Script : xxxxxxxxxxxxxxxxxxxxxx/forum/market.php
Referrer : xxxxxxxxxxxxxxxxxxx/forum/forum.php
IP Address : xxxxxxxxxx
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version : 4.1.20

gonna just disable it for now but if anyone had this problem and got it fixed plz help,I'll try tomorrows version also and hope it helps