Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[dmkmonkey]

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?

[JoshuaDams]

Is what it says

The code that Inserts the Data into the Database Has more or less slots than The Database Table

Example

The code may say insert "id number, name, total"

But the database may only have  ID, NAME


So you're trying to insert 3 items, you'd need 3 tables

could be a coding error, or could be your database table isnt set up properly.