[TheMayhem]

Originally Posted by VBUsers

when i add a second category in the market i get this sql error

Database error in vBulletin 4.0.8:

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

MySQL Error : Column 'marketid' cannot be null
Error Number : 1048
Request Date : Friday, October 22nd 2010 @ 08:21:55 PM
Error Date : Friday, October 22nd 2010 @ 08:21:55 PM
Script : http://www.----------.com/market.php
Referrer : http://www.--------------.com/market.php
IP Address : 72.------------
Username : N----
Classname : vB_Database
MySQL Version : 5.0.91-community

Upgrade to version 3.0.1 and your error should be fixed