any idea why this isnt working anymore?

[Nicholas]

yesterday the item adding/creating worked, but today some reason i get this query error, any idea why?

QUERY ERROR: Column count doesn't match value count at row 1

Query was INSERT INTO items VALUES('',3,'Brave Potion','refills brave by 100%',0,0,1, '1', 'a:4:{s:4:\"stat\";s:5:\"brave\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\";s:7:\"percent\";s:10:\"inc_amount\";i:100;}', '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)

can anyone figure out why this is happening?

[wolfe]

Re: any idea why this isnt working anymore?

*sigh*

This question pops up A LOT. The input you are inserting in doesnt equal the number of fields in the table. You have to make sure that you are inserting into the right fields and that every field is covered. If you made a change to the items table (added or removed a field) you have to make sure this query also reflects that change.