1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development

Threaded Mode
[Plugin] [REL] MySQL Plugin (Now on github!)
iZN
High-roller
*****
Posts: 2,368
Threads: 27
Joined: Jun 2010
Reputation: 0
#1,421

18.11.2013, 19:12
Quote:
Originally Posted by Andrejs
Посмотреть сообщение
Somebody have R6-2 verison of plugin for Linux(CentOS)?
R6 isn't working because of mysql_format using..
That version was released and the links got removed because, R7 got released with threaded queries.
Find
Reply
SlonCHL
Big Clucker
***
Posts: 135
Threads: 40
Joined: Nov 2012
Reputation: 0
#1,422

19.11.2013, 17:14
I don't understand how do I get the returned variables, lets say it's $Result['username'] in PHP, how do I get it using this plugin?
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#1,423

19.11.2013, 22:10
This is for SA-MP, not PHP. PHP uses it's own built in MySQL functions.
Find
Reply
Awankz
Big Clucker
***
Posts: 143
Threads: 19
Joined: Mar 2012
Reputation: 0
#1,424

20.11.2013, 09:50
Good Job Man .
Find
Reply
Grex
Big Clucker
***
Posts: 65
Threads: 7
Joined: Mar 2008
Reputation: 0
#1,425

24.11.2013, 10:55
Hello,

I want to compile the R6 Code on Debian 7, first I got an error
main.cpp:193:3: error: "usleep" was not declared in this scope


Then I added in main.cpp following line on top: #include "unistd.h"

Now I got this error:
/usr/bin/ld: CAmxString.o: relocation R_X86_64_32 against `.bss' can not be used when making a shared object; recompile with -fPIC
CAmxString.o: could not read symbols: Bad value
collect2: error: ld returned 1 exit status
make: *** [all] Fehler 1



can anyone help me to get it running on debian7?
Find
Reply
MyNinja
Banned
Posts: 186
Threads: 3
Joined: Jan 2013
#1,426

24.11.2013, 12:05
pawn Код:
[06:28:17] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:28:17] [ERROR] ExecuteT[Group_QueryFinish(ii)] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[Group_QueryFinish(ii)] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[Server_OnLoadStats()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[Server_OnLoadStats()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[Admin_CMDAuthOnLoad()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[Admin_CMDAuthOnLoad()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadGates()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadGates()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadTurfs()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadTurfs()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadHouses()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadHouses()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadDynamicMapIcons()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadDynamicMapIcons()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadDynamicDoors()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadDynamicDoors()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadBusinesses()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadBusinesses()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadGangs()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadGangs()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadATM()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadATM()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadArrestPoints()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadArrestPoints()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadImpoundPoints()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadImpoundPoints()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadRadioStations()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadRadioStations()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadShipment()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadShipment()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadRepairPoints()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadRepairPoints()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadJobs()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadJobs()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadDynamicVehicles()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadDynamicVehicles()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[LoadLockers()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[LoadLockers()] - lost connection, requesting reconnect
[06:28:18] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:28:43] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:28:43] [ERROR] ExecuteT[Group_QueryFinish(ii)] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[Group_QueryFinish(ii)] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[Server_OnLoadStats()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[Server_OnLoadStats()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[Admin_CMDAuthOnLoad()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[Admin_CMDAuthOnLoad()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadGates()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadGates()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadTurfs()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadTurfs()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadHouses()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadHouses()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadDynamicMapIcons()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadDynamicMapIcons()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadDynamicDoors()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadDynamicDoors()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadBusinesses()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadBusinesses()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadGangs()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadGangs()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadATM()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadATM()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadArrestPoints()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadArrestPoints()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadImpoundPoints()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadImpoundPoints()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadRadioStations()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadRadioStations()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadShipment()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadShipment()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadRepairPoints()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadRepairPoints()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadJobs()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadJobs()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadDynamicVehicles()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadDynamicVehicles()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[LoadLockers()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[LoadLockers()] - lost connection, requesting reconnect
[06:28:44] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:29:47] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:29:47] [ERROR] ExecuteT[Group_QueryFinish(ii)] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[Group_QueryFinish(ii)] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[Server_OnLoadStats()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[Server_OnLoadStats()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[Admin_CMDAuthOnLoad()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[Admin_CMDAuthOnLoad()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadGates()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadGates()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadTurfs()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadTurfs()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadHouses()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadHouses()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadDynamicMapIcons()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadDynamicMapIcons()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadDynamicDoors()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadDynamicDoors()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadBusinesses()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadBusinesses()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadGangs()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadGangs()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadATM()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadATM()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadArrestPoints()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadArrestPoints()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadImpoundPoints()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadImpoundPoints()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadRadioStations()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadRadioStations()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadShipment()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadShipment()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadRepairPoints()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadRepairPoints()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadJobs()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadJobs()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadDynamicVehicles()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadDynamicVehicles()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[LoadLockers()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[LoadLockers()] - lost connection, requesting reconnect
[06:29:48] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
Any help? The MySQL server is working fine as well.
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#1,427

24.11.2013, 15:06
Quote:
Originally Posted by Grex
Посмотреть сообщение
Hello,

I want to compile the R6 Code on Debian 7, first I got an error
main.cpp:193:3: error: "usleep" was not declared in this scope


Then I added in main.cpp following line on top: #include "unistd.h"

Now I got this error:
/usr/bin/ld: CAmxString.o: relocation R_X86_64_32 against `.bss' can not be used when making a shared object; recompile with -fPIC
CAmxString.o: could not read symbols: Bad value
collect2: error: ld returned 1 exit status
make: *** [all] Fehler 1



can anyone help me to get it running on debian7?
The solution is already in the error message:
Quote:

recompile with -fPIC
So open the makefile and append that compiler argument to the other arguments.

Quote:
Originally Posted by MyNinja
Посмотреть сообщение
pawn Код:
[06:28:17] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:28:17] [ERROR] ExecuteT[Group_QueryFinish(ii)] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[Group_QueryFinish(ii)] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[Server_OnLoadStats()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[Server_OnLoadStats()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[Admin_CMDAuthOnLoad()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[Admin_CMDAuthOnLoad()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadGates()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadGates()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadTurfs()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadTurfs()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadHouses()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadHouses()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadDynamicMapIcons()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadDynamicMapIcons()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadDynamicDoors()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadDynamicDoors()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadBusinesses()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadBusinesses()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadGangs()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadGangs()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadATM()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadATM()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadArrestPoints()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadArrestPoints()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadImpoundPoints()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadImpoundPoints()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadRadioStations()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadRadioStations()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadShipment()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadShipment()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadRepairPoints()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadRepairPoints()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadJobs()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadJobs()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[OnLoadDynamicVehicles()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[OnLoadDynamicVehicles()] - lost connection, requesting reconnect
[06:28:17] [ERROR] ExecuteT[LoadLockers()] - (error #2006) MySQL server has gone away
[06:28:17] [WARNING] ExecuteT[LoadLockers()] - lost connection, requesting reconnect
[06:28:18] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:28:43] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:28:43] [ERROR] ExecuteT[Group_QueryFinish(ii)] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[Group_QueryFinish(ii)] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[Server_OnLoadStats()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[Server_OnLoadStats()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[Admin_CMDAuthOnLoad()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[Admin_CMDAuthOnLoad()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadGates()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadGates()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadTurfs()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadTurfs()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadHouses()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadHouses()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadDynamicMapIcons()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadDynamicMapIcons()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadDynamicDoors()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadDynamicDoors()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadBusinesses()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadBusinesses()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadGangs()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadGangs()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadATM()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadATM()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadArrestPoints()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadArrestPoints()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadImpoundPoints()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadImpoundPoints()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadRadioStations()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadRadioStations()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadShipment()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadShipment()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadRepairPoints()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadRepairPoints()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadJobs()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadJobs()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[OnLoadDynamicVehicles()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[OnLoadDynamicVehicles()] - lost connection, requesting reconnect
[06:28:43] [ERROR] ExecuteT[LoadLockers()] - (error #2006) MySQL server has gone away
[06:28:43] [WARNING] ExecuteT[LoadLockers()] - lost connection, requesting reconnect
[06:28:44] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:29:47] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
[06:29:47] [ERROR] ExecuteT[Group_QueryFinish(ii)] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[Group_QueryFinish(ii)] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[Server_OnLoadStats()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[Server_OnLoadStats()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[Admin_CMDAuthOnLoad()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[Admin_CMDAuthOnLoad()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadGates()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadGates()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadTurfs()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadTurfs()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadHouses()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadHouses()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadDynamicMapIcons()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadDynamicMapIcons()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadDynamicDoors()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadDynamicDoors()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadBusinesses()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadBusinesses()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadGangs()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadGangs()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadATM()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadATM()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadArrestPoints()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadArrestPoints()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadImpoundPoints()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadImpoundPoints()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadRadioStations()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadRadioStations()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadShipment()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadShipment()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadRepairPoints()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadRepairPoints()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadJobs()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadJobs()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[OnLoadDynamicVehicles()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[OnLoadDynamicVehicles()] - lost connection, requesting reconnect
[06:29:47] [ERROR] ExecuteT[LoadLockers()] - (error #2006) MySQL server has gone away
[06:29:47] [WARNING] ExecuteT[LoadLockers()] - lost connection, requesting reconnect
[06:29:48] [ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on '66.150.214.164' (10061)
Any help? The MySQL server is working fine as well.
Are you sure the connection data is alright (especially the port) and the MySQL server is configured to accept remote connections?
Find
Reply
SlonCHL
Big Clucker
***
Posts: 135
Threads: 40
Joined: Nov 2012
Reputation: 0
#1,428

29.11.2013, 13:07
AASDHGSJKHEJHRVDSJKNKD

%E NOT WORKING FOR MY PLAYER NAME ONPLAYERCONNECT, INSERTING NULL CHARACTER ARGH

Nevermind, it's working now, My connection failed
Find
Reply
im
Huge Clucker
***
Posts: 213
Threads: 16
Joined: Mar 2012
Reputation: 0
#1,429

02.12.2013, 13:10
Why isn't there a function to check if a cache id is valid? So you could do:
pawn Код:
if(is_valid_cache(cache_id[playerid)
{
 cache_set_active(cache_id[playerid]);
}
else
{
 // run a query to get the data.
}
That is useful for dialogs. I use dialogs for in game messages, so when a player uses the command /pms he sees a list dialog with latest recived messages and from there he can click a message to read it. So when the player types /emails, I save all the data using cache_save() and if the player clicks a message, I just use the cached data to show the message to the player, without running the query agains. When the player clicks back he returns to the /pms command and the script checks if the player has anything stored in the cache or not. If there is data stored in the cache for that player, the script loads the data from the cache, if not, it runs a query to get the data.
Find
Reply
maddinat0r
Banned
Posts: 845
Threads: 3
Joined: Jun 2010
#1,430

02.12.2013, 15:04
Quote:
Originally Posted by im
Посмотреть сообщение
Why isn't there a function to check if a cache id is valid? So you could do:
pawn Код:
if(is_valid_cache(cache_id[playerid)
{
 cache_set_active(cache_id[playerid]);
}
else
{
 // run a query to get the data.
}
That is useful for dialogs. I use dialogs for in game messages, so when a player uses the command /pms he sees a list dialog with latest recived messages and from there he can click a message to read it. So when the player types /emails, I save all the data using cache_save() and if the player clicks a message, I just use the cached data to show the message to the player, without running the query agains. When the player clicks back he returns to the /pms command and the script checks if the player has anything stored in the cache or not. If there is data stored in the cache for that player, the script loads the data from the cache, if not, it runs a query to get the data.
It should be no problem to add a native like "cache_is_valid(Cache:id);". You can track the current status of R35 here: http://git.my-reallife.de/root/mysql...a/commits/beta
Find
Reply
Damian
Beta Tester
*****
Posts: 121
Threads: 1
Joined: Jan 2006
Reputation: 0
#1,431

03.12.2013, 02:49
LS-RP is currently on R34 now and it's working great so far.
Find
Reply
Kar
Banned
Posts: 2,938
Threads: 162
Joined: May 2010
#1,432

03.12.2013, 03:10
Quote:
Originally Posted by Damian
Посмотреть сообщение
LS-RP is currently on R34 now and it's working great so far.
No crashes?

Mine is alot better, but still unclear to me

Start:

Crashes 1-3 times one day.
4 days without crashes
Crashes 1-3 times one day.
4 days without crashes
recuring...

I'm thinking that I just have some bad code somewhere.
Find
Reply
iJumbo
High-roller
*****
Posts: 2,175
Threads: 235
Joined: Sep 2009
Reputation: 0
#1,433

03.12.2013, 13:11
Why not use crashdetect? maybe you have some simple "divide by zero" or some wrong code that make a infinite loop..
Find
Reply
IstuntmanI
High-roller
*****
Posts: 1,801
Threads: 27
Joined: Mar 2009
Reputation: 0
#1,434

03.12.2013, 16:28
Quote:
Originally Posted by Kar
Посмотреть сообщение
No crashes?

Mine is alot better, but still unclear to me

Start:

Crashes 1-3 times one day.
4 days without crashes
Crashes 1-3 times one day.
4 days without crashes
recuring...

I'm thinking that I just have some bad code somewhere.
I've got no crashes or problems as well, it's something wrong with your code.
Find
Reply
Ted67
Big Clucker
***
Posts: 150
Threads: 13
Joined: Dec 2012
Reputation: 0
#1,435

06.12.2013, 19:05
Hi guys. I try to compare the date:
pawn Код:
mysql_format(1, STR256, 188, "SELECT `date` FROM `"TABLE_BLACKLIST"` WHERE `date` <= 'NOW()+0'");
Test = mysql_query(1, STR256);
cache_get_data(rows, fields, 1);
if(rows == 1) print("Yeah");
else print("No...");
and I always get: "Yeah" in the log.
My question is - Why?) Someone can help me, please? Where's my error?)

Thank you in advance!
Find
Reply
26_RUSSS
Huge Clucker
***
Posts: 222
Threads: 74
Joined: Jun 2010
Reputation: 0
#1,436

10.12.2013, 22:48
help
log start server
Код:
v0.3x-R2-1000p, ©2005-2013 SA-MP Team

[02:58:07] filterscripts = ""  (string)
[02:58:07] weburl = "http:"  (string)
[02:58:07] password = ""  (string)
[02:58:07] 
[02:58:07] Server Plugins
[02:58:07] --------------
[02:58:07]  Loading plugin: sscanf.so
[02:58:07] 

[02:58:07]  ===============================

[02:58:07]       sscanf plugin loaded.     

[02:58:07]          Version:  2.8.1        

[02:58:07]    © 2012 Alex "******" Cole  

[02:58:07]  ===============================

[02:58:07]   Loaded.
[02:58:07]  Loading plugin: streamer.so
[02:58:07] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[02:58:07]   Loaded.
[02:58:07]  Loading plugin: mysql.so
[02:58:07]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[02:58:07]  Loaded 2 plugins.

[02:58:07] 
[02:58:07] Filterscripts
[02:58:07] ---------------
[02:58:07]   Loaded 0 filterscripts.
operating system debian 6 x64 - that necessary where throw describe please for operating system debian 6 x64
Find
Reply
SHOROOP
Big Clucker
***
Posts: 123
Threads: 2
Joined: Feb 2012
Reputation: 0
#1,437

11.12.2013, 04:09
26_RUSSS, I've already answered your question in your another thread.
Find
Reply
Ted67
Big Clucker
***
Posts: 150
Threads: 13
Joined: Dec 2012
Reputation: 0
#1,438

11.12.2013, 17:40
Someone can help me, please?) post
Find
Reply
Mellnik
Gangsta
*****
Posts: 767
Threads: 40
Joined: Dec 2011
Reputation: 0
#1,439

11.12.2013, 20:29
Quote:
Originally Posted by Ted67
Посмотреть сообщение
Someone can help me, please?) post
It is 1 because you apparently have one row in your table matching your query. If you want to fetch the data use cache_get_row.
Find
Reply
Leenert
Little Clucker
**
Posts: 25
Threads: 11
Joined: Nov 2011
Reputation: 0
#1,440

21.12.2013, 14:36
Hey everyone,
since updating to r34 i got the following error on server start:
Код:
[16:36:35] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Maybe someone knows how to fix that...I use the static version of the plugin, because the dynamic did not work
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Plugin Development