[IamPuzo]

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

[Vince]

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".

[IamPuzo]

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

[iGetty]

Show the query, please. (In the script)

[IamPuzo]

Код 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);

[iGetty]

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.