[mikem164]

Database error in vBulletin 4.0.2:

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

MySQL Error   : Invalid use of group function
Error Number  : 1111
Request Date  : Monday, May 3rd 2010 @ 01:46:04 PM
Error Date    : Monday, May 3rd 2010 @ 01:46:06 PM
Script        : http://trtap/elite/upload/market.php
Referrer      : http://trtap/elite/upload/forum.php
IP Address    : 174.54.72.228
Username      : Highrise
Classname     : vB_Database
MySQL Version : 4.1.22-standard

If I click on Market in the Navbar, I get this sql error as well. I re upped all files to site to make sure nothing got corrupt on the way up, and re imported the xml. Same error. I would really, really like to get this working bro. THANKS and keep up the good work!