c0nka Posted February 12, 2008 Posted February 12, 2008 heya could someone help i have a webbased rpg game and it is powered by mccodes 2.0 everytime i try to create a new item i get this error 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, '1', 'a:4:{s:4:\"stat\";s:4:\"will\";s:3:\"dir\";s:3:\"pos\";s:8:\"inc_type\' at line 1 Query was INSERT INTO items VALUES('',1,'Will Potion','Restores all your will',,,0, '1', 'a:4:{s:4:\"stat\";s:4:\"will\";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) could someone help thanks in advanced :| Quote
Guest Anonymous Posted February 12, 2008 Posted February 12, 2008 Re: HELP PLEASE Have you edited the staff_items file in any way or edited the tables in the database ? Quote
c0nka Posted February 12, 2008 Author Posted February 12, 2008 Re: HELP PLEASE Nope i have'nt mate :S :| Quote
Floydian Posted February 12, 2008 Posted February 12, 2008 Re: HELP PLEASE There are 3 commas before where you got the error. Is there a reason those 3 commas have nothing between them? Most likely, you'll have to submit something there. Perhaps you left a couple fields in the form blank? I've found mc codes is very slack on validation, and I can see leaving out fields in a form causing a query to fail. Quote
c0nka Posted February 12, 2008 Author Posted February 12, 2008 Re: HELP PLEASE wa shall i do then mate becouse i dont no alot about these things Quote
Guest Anonymous Posted February 12, 2008 Posted February 12, 2008 Re: HELP PLEASE Make shoure you fill in all form fields before you submit your item. Quote
solar Posted February 12, 2008 Posted February 12, 2008 Re: HELP PLEASE even if the item cannot be bought you still need to add a buy price Quote
c0nka Posted February 13, 2008 Author Posted February 13, 2008 Re: HELP PLEASE omg thanks ppl soo easy Quote
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.