Adding items such as "Will Potion"

[Wman21]

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)

[hamster01]

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!

[Wman21]

Re: Adding items such as "Will Potion"

you mean this?

 

 
Dont post database info.

Removed ~LostOne

[hamster01]

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!

[Decepti0n]

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 :(

[Wman21]

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

[hamster01]

Re: Adding items such as "Will Potion"

try this:

 

, '', '', ''

[Wman21]

Re: Adding items such as "Will Potion"

and where should I ask it if I may as ... ( soz for this noob quiz)