MySql lost connection on query - 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 lost connection on query (
/showthread.php?tid=562582)
MySql lost connection on query -
Maximus0 - 10.02.2015
It's kinda dumb asking this question, but when I send a query to my localhost, everything works fine as it should. But when it comes for my host from GoDaddy, it shows me this cute error on server log.
Код:
errorid: 2013 | error: Lost connection to MySQL server during query
Tried so many way, such as
*) Breaking my query
*) Change the size of query
*) Changing host -_-
The query I used:
pawn Код:
format(sQuery, sizeof(sQuery), "INSERT INTO `playervehicles` \
VALUES('0', '%d','%s','%s','%d','2811.12','928.864','10.709','20','1387','704.609','10.709', \
'20','0','6','229','0','1','1','3','0','New')", Selected_VEHID[playerid], VehicleNames[Selected_VEHID[playerid]-400], PlayerName(playerid), Selected_VEHPRICE[playerid]);
mysql_query(sQuery);
Note: Only works for my localhost.
Re: MySql lost connection on query -
Kar - 10.02.2015
What MySQL plugin version are you using?
Re: MySql lost connection on query -
Maximus0 - 10.02.2015
The plugin I am using is by
BlueG (R6) for my gamemode.
Server version: 5.5.41-cll-lve - MySQL Community Server (GPL) is running on my mysql host.
Re: MySql lost connection on query -
Maximus0 - 10.02.2015
I would like to bump this post as I still having the same issue.