Wman21 Posted April 7, 2007 Share Posted April 7, 2007 Hello everybody, I got this weird error when I try to add the donators items ( I haven't set up the PayPal stuff, becsuse I don't have an account there, I can't make one either there) This is the error I get: 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 ',1, '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','Some sweets for the donators',,,1, '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) Quote Link to comment Share on other sites More sharing options...
hamster01 Posted April 7, 2007 Share Posted April 7, 2007 Re: Adding items such as "Will Potion" did you make that query? btw, \" can only be used in php not sql! Please post ur mysq query! Quote Link to comment Share on other sites More sharing options...
Wman21 Posted April 7, 2007 Author Share Posted April 7, 2007 Re: Adding items such as "Will Potion" you mean this? Dont post database info. Removed ~LostOne Quote Link to comment Share on other sites More sharing options...
hamster01 Posted April 9, 2007 Share Posted April 9, 2007 Re: Adding items such as "Will Potion" thanlk you for showing me ur db name and structure XD no i mean the script you got that error from! Quote Link to comment Share on other sites More sharing options...
Decepti0n Posted April 9, 2007 Share Posted April 9, 2007 Re: Adding items such as "Will Potion" VALUES('',1,'Will Potion','Some sweets for the donators',,,1, You can't have 3 commas in a row :( Quote Link to comment Share on other sites More sharing options...
Wman21 Posted April 10, 2007 Author Share Posted April 10, 2007 Re: Adding items such as "Will Potion" But that wasn't my fault, time to time I get this message not every time ... and I didn't put 4 , in a row Quote Link to comment Share on other sites More sharing options...
hamster01 Posted April 10, 2007 Share Posted April 10, 2007 Re: Adding items such as "Will Potion" try this: , '', '', '' Quote Link to comment Share on other sites More sharing options...
Wman21 Posted April 11, 2007 Author Share Posted April 11, 2007 Re: Adding items such as "Will Potion" and where should I ask it if I may as ... ( soz for this noob quiz) 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.