Quote:
Originally Posted by PT
Any idea what this:
pawn Код:
[23:04:12] [ERROR] "mysql_format" - invalid connection handle (id: -1)
[23:04:12] [ERROR] "mysql_tquery" - invalid connection handle (id: -1)
can be?
i'm trying save this:
pawn Код:
mysql_format(SQL, szQuery, sizeof(szQuery),"UPDATE `accounts` SET `skin` = '%d', `sex` = '%d', `age` = '%d', `from` = '%d', `sta` = '%d' WHERE `x` = '%d' LIMIT 1", PlayerInfo[playerid][Skin], PlayerInfo[playerid][Sex], PlayerInfo[playerid][Age], PlayerInfo[playerid][From], PlayerInfo[playerid][sta], PlayerInfo[playerid][X]);
mysql_tquery(SQL, szQuery, "OnQueryFinish", "ii", THREAD_NO_RESULT, playerid);
but is not saving.
p.s: its loading and registering new accounts, only that values dont save, strange. |
Are you saving the connection ID through mysql_connect? Or you might have messed up the pool parameter of mysql_connect?
pawn Код:
new SQL = mysql_connect( ... );
pawn Код:
native mysql_connect(const host[], const user[], const database[], const password[], port = 3306, bool:autoreconnect = true, pool_size = 2); // <-- this one
If anything doesn't works, try replacing SQL with 1 instead.
pawn Код:
mysql_tquery(1, szQuery, "OnQueryFinish", "ii", THREAD_NO_RESULT, playerid);
