mysql error need a hand - Printable Version

mysql error need a hand - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql error need a hand (/showthread.php?tid=421932)

mysql error need a hand - thistooshallpass93 - 11.03.2013

Hoping for some help

PHP код:



[18:49:01] >> mysql_store_result( Connection handle: 1 )

[18:49:01] CMySQLHandler::StoreResult() - Result was stored.

[18:49:01] >> mysql_num_rows( Connection handle: 1 )

[18:49:01] CMySQLHandler::NumRows() - Returned 0 row(s)

[18:49:01] >> mysql_free_result( Connection handle: 1 )

[18:49:01] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:49:01]  

[18:49:01] ---------------------------

[18:49:01] MySQL Debugging activated (03/11/13)

[18:49:01] ---------------------------

[18:49:01]  

[18:49:04] >> mysql_real_escape_string( Connection handle: 1 )

[18:49:04] CMySQLHandler::EscapeString(*******); - Escaped 7 characters to *******.

[18:49:04] >> mysql_query( Connection handle: 1 )

[18:49:04] CMySQLHandler::Query(INSERT INTO playerdata (user, password, score, admin, money, level, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, posx, posy, posz, posa, IP) VALUES('****************', SHA1('*******'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Not Banned', 0, 0, 0, 0, 0, '66.131.***.***') - 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)

ERROR: 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)

Re: mysql error need a hand - thistooshallpass93 - 12.03.2013

help.. anyone?

Re: mysql error need a hand - Ranama - 12.03.2013

Something is wrong typed with the MySQL code, check that all strings have ' ' or " ".
Do you got all the tables and are you connected to your MySQL Server?

Re: mysql error need a hand - Patrick - 12.03.2013

can you show us your code? as i can see you have Not Banned which have space and MySQL Database doesn't allow space.but im not sure if im right

try changing on your MySQL database and things uses

pawn Код:

Not Banned

pawn Код:

Not_Banned

Re: mysql error need a hand - iggy1 - 12.03.2013

Quote:

Originally Posted by pds2012

pawn Код:

Not Banned

pawn Код:

Not_Banned

That's allowed, it would be bad if it didn't allow that. If you wanted to store a string of words you need spaces.

Re: mysql error need a hand - thistooshallpass93 - 12.03.2013

Quote:

Originally Posted by Ranama

Something is wrong typed with the MySQL code, check that all strings have ' ' or " ".
Do you got all the tables and are you connected to your MySQL Server?

Yeah I am. Used a mysql base and I added 1 row to an existing table which is "admin" and as you can see it's formatted properly. It was working even after that, I verified all of the tables the strings and the sizes. I have no clue to which why it could be doing that, I'm taking a look at the " and ' now if i find any of them missing ill respond to see if that works.

Re: mysql error need a hand - thistooshallpass93 - 12.03.2013

Turns out it was because I had an Underscore in my name and I forgot to add my remove underscore function.

SORRY for the double post.