Get error when trying to add item

[Harley]

I'm getting this error anytime I try to add an item to my game. Anyone have any ideas?

 

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',0, '0', 'a:4:{s:4:\"stat\";s:6:\"energy\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_typ' at line 1
Query was INSERT INTO items VALUES('',5,'The Ultimate Weapon','The beats them all',,,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', '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;}', 1000, 0)

[AlabamaHit]

Re: Get error when trying to add item

Don't leave anything blank.

If you don't want to enter anything put a 0

Example, unbuyable item, sell price and buy price needs to be 0.

[Harley]

Re: Get error when trying to add item

Thank you very much! That was exactly the issue. :-o