Item Creation Error! Need Help!

[Monkey644]

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?

[Danny696]

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 :)

[Monkey644]

Cheers :)

[Dave]

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.

[Danny696]

It looks like he did dave. As there are no , , in the erroring query.

[rednspirited]

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 

[PHPStudent]

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 

[rednspirited]

ok ty