[capt gary]

Getting Database error after new install....Here's the error when I attempt to load market.php.

Database error in vBulletin 4.0.5:

Invalid SQL:
SELECT * FROM market_store_transactions AS mt CROSS JOIN ( SELECT marketid, COUNT(*) AS cnt FROM market_store_transactions where marketid=6 ORDER BY cnt DESC LIMIT 1) AS sq USING (marketid);

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Friday, August 13th 2010 @ 07:22:15 AM
Error Date : Friday, August 13th 2010 @ 07:22:15 AM
Referrer :
Username : Capt Gary
Classname : vB_Database
MySQL Version : 5.0.45