04.01.2011, 11:16
Hi,
I got this strange problem.. I get this:
And the pawn code is:
Why it disconnects from mysql server?
If I try to put this query:
through phpMyAdmin, it works with no problems.. :S
I'm using this mysql plugin:
https://sampforum.blast.hk/showthread.php?tid=122983
Other queries works OK, except this one..
I got this strange problem.. I get this:
Quote:
[Tue Jan 04 14:15:45 2011] Function: mysql_query executed: "UPDATE `table` SET `field`='101,103,' WHERE (`id` = '1')" with result: "1". [Tue Jan 04 14:15:45 2011] Error (0): Failed to exeute query. Lost connection to MySQL server during query. |
pawn Код:
MySQLCheck();
new items[20] = "",queryStr[150];
if(GPS[playerid] == 1)
{
format(items,20,"%i,",ITEM_GPS);
}
if(Phone[playerid] == 1)
{
format(items,20,"%s%i,",items,ITEM_PHONE);
}
if(hMetter[playerid] == 1)
{
format(items,20,"%s%i,",items,ITEM_HEALTH);
}
if(Radio[playerid] == 1)
{
format(items,20,"%s%i,",items,ITEM_RADIO);
}
format(queryStr,150,"UPDATE `table` SET `field`='%s' WHERE (`id` = '%i')",items,GetPVarInt(playerid, "pID"));
mysql_query(queryStr);
If I try to put this query:
Quote:
UPDATE `table` SET `field`='101,103,' WHERE (`id` = '1') |
I'm using this mysql plugin:
https://sampforum.blast.hk/showthread.php?tid=122983
Other queries works OK, except this one..