[GONUMBER6]

I am getting this DB error when I add a market item that is over 1000 points. If I put it at 1000 or less it is fine. But it needs to be over 1000 thanks

PHP Code:

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

MySQL Error   : Column 'marketid' cannot be null
Error Number  : 1048
Request Date  : Thursday, January 6th 2011 @ 02:45:58 PM
Error Date    : Thursday, January 6th 2011 @ 02:45:59 PM
Script        : http://www.englishbulldognews.com/forums/market.php
Referrer      : http://www.englishbulldognews.com/forums/community.php
IP Address    : 
Username      : desertskybulldogs
Classname     : vB_Database
MySQL Version : 5.0.77 


***********
EDIT: I fixed it by having forum items on the storefront instead of market items.