Monkey644 Posted February 25, 2011 Share Posted February 25, 2011 QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO items VALUES('',1000,'IQ Potion','Gain 50,000 IQ through drinking this magic Potion',0,0,1, '1', 'a:4:{s:4:\"stat\";s:2:\"IQ\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:50000;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:6:\"figure\";s:10:\"inc_amount\";i:0;}', 0, 0, 0, 0, 0, 0) Is the error i get. any help? Quote Link to comment Share on other sites More sharing options...
Danny696 Posted February 25, 2011 Share Posted February 25, 2011 QUERY ERROR: Column count doesn't match value count at row 1 Read it :) Youve edited the item table, and havnt updated the query. Theres 100000's of topics like this, please use the search next time :) Quote Link to comment Share on other sites More sharing options...
Monkey644 Posted February 25, 2011 Author Share Posted February 25, 2011 Cheers :) Quote Link to comment Share on other sites More sharing options...
Dave Posted February 26, 2011 Share Posted February 26, 2011 Or you didn't fill in one of the fields! Even if you don't want the item to say have a buy price you still have to put a 0 into the box or it'll error like it has for you. Or as Danny has said you've got extra fields in your database which you've not modified your control panel to handle. Quote Link to comment Share on other sites More sharing options...
Danny696 Posted February 26, 2011 Share Posted February 26, 2011 It looks like he did dave. As there are no , , in the erroring query. Quote Link to comment Share on other sites More sharing options...
rednspirited Posted November 17, 2020 Share Posted November 17, 2020 ok i cant figure what im doing wrong i have all the fields filled but i still get an error saying that they are not filled Quote Link to comment Share on other sites More sharing options...
PHPStudent Posted November 17, 2020 Share Posted November 17, 2020 1 hour ago, rednspirited said: ok i cant figure what im doing wrong i have all the fields filled but i still get an error saying that they are not filled If you find the if statement for that error message and completely remove it, it should work as it did for me 1 Quote Link to comment Share on other sites More sharing options...
rednspirited Posted November 17, 2020 Share Posted November 17, 2020 ok ty Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.