When i try to add a second store item i get this error . who can help????
PHP Code:
nvalid SQL:
SELECT * FROM market_store_transactions AS mt CROSS JOIN ( SELECT marketid, COUNT(*) AS cnt FROM market_store_transactions where marketid=3 ORDER BY cnt DESC LIMIT 1) AS sq USING (marketid);
MySQL Error : Column 'marketid' cannot be null
Error Number : 1048
Request Date : Sunday, October 17th 2010 @ 07:24:28 PM
Error Date : Sunday, October 17th 2010 @ 07:24:28 PM
Script : [url]http://www.hydrocanna.com/market.php[/url]
Referrer :
IP Address : 000000000
Username : me
Classname : vB_Database
MySQL Version : 5.0.91-community