SA-MP Forums Archive
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.