Harley Posted May 3, 2009 Share Posted May 3, 2009 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) Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted May 4, 2009 Share Posted May 4, 2009 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. Quote Link to comment Share on other sites More sharing options...
Harley Posted May 5, 2009 Author Share Posted May 5, 2009 Re: Get error when trying to add item Thank you very much! That was exactly the issue. :-o 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.