Account not registering into MySQL

Account not registering into MySQL - 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: Account not registering into MySQL (/showthread.php?tid=611257)

MySQL errors! - IamPuzo - 04.07.2016

Well, I got too many error for mysql.
[ERROR] CMySQLQuery::Execute[] - (error #1366) Incorrect integer value: '' for column 'FactionID' at row 1
Help!

Re: Account not registering into MySQL - Vince - 04.07.2016

My crystal ball says you have a file called mysql_log.txt. It also says that in that file you will probably find something along the lines of "syntax error".

Re: Account not registering into MySQL - IamPuzo - 04.07.2016

[ERROR] CMySQLQuery::Execute[] - (error #1366) Incorrect integer value: '' for column 'FactionID' at row 1
What's wrong here?

Re: Account not registering into MySQL - iGetty - 04.07.2016

Show the query, please. (In the script)

Re: Account not registering into MySQL - IamPuzo - 04.07.2016

Код HTML:

cache_get_field_content(0, "FactionID", iGet, MySQLPipeline); PlayerInfo[playerid][playerteam] = strval(iGet);

and

Код HTML:

cache_get_field_content(row, "FactionID", iGet, MySQLPipeline); VehicleInfo[vid][vFaction] = strval(iGet);

Re: Account not registering into MySQL - iGetty - 04.07.2016

Try:

pawn Код:

variable = cache_get_field_content_int(0, "FactionID", MySQLPipeline);

and

pawn Код:

variable = cache_get_field_content_int(row, "FactionID", MySQLPipeline);

For the SQL error, I have no idea really. Try changing it from "SMALLINT" to "INT" to see if that does anything at all, and change it from "2" to "11" for testing.