MySQL not making a new account
#1

Hey guys,

It started again... I tested my script and MySQL would not make a new account. I get this error in the debug:

pawn Код:
- An error has occured. (Error ID: 1064, 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 '' at line 1)
On this line:

pawn Код:
format(query, sizeof(query), "INSERT INTO playerdata (user, password, Adminlevel, Warnings, score, money, IP, Seconds, Minutes, Hours, register_date, Deaths, Kills) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, '%s', 0, 0, 0, NOW(), 0, 0)", pname, passwordstring, IP);
I don't see anything wrong in the script, I hope you can help me!

Thanks
Reply


Messages In This Thread
MySQL not making a new account - by FunnyBear - 10.03.2013, 13:00
Re: MySQL not making a new account - by dusk - 10.03.2013, 13:02
Re: MySQL not making a new account - by FunnyBear - 10.03.2013, 13:03
Re: MySQL not making a new account - by dusk - 10.03.2013, 13:05
Re: MySQL not making a new account - by Smally - 10.03.2013, 13:07
Re: MySQL not making a new account - by FunnyBear - 10.03.2013, 13:08
Re: MySQL not making a new account - by Smally - 10.03.2013, 13:14
Re: MySQL not making a new account - by FunnyBear - 10.03.2013, 13:28
Re: MySQL not making a new account - by Smally - 10.03.2013, 13:36
Re: MySQL not making a new account - by Vince - 10.03.2013, 13:38

Forum Jump:


Users browsing this thread: 1 Guest(s)