Mysql - server has gone away - Printable Version

Mysql - server has gone away - 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 - server has gone away (/showthread.php?tid=487326)

. - reckst4r - 12.01.2014

no use

Re: Mysql - server has gone away - SerieWoordenaar - 12.01.2014

downgrade the plugin or use Dan's MySQL plugin

Re: Mysql - server has gone away - reckst4r - 13.01.2014

I installed Dan's plugin, and I receive this:

PHP код:



SA-MP Dedicated Server

----------------------

v0.3x-R2, (C)2005-2013 SA-MP Team


[05:49:37] 

[05:49:37] Server Plugins

[05:49:37] --------------

[05:49:37]  Loading plugin: sscanf.so

[05:49:37] 


[05:49:37]  ===============================


[05:49:37]       sscanf plugin loaded.     


[05:49:37]          Version:  2.8.1        


[05:49:37]    (c) 2012 Alex "******" Cole  


[05:49:37]  ===============================


[05:49:37]   Loaded.

[05:49:37]  Loading plugin: streamer.so

[05:49:37] 


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


[05:49:37]   Loaded.

[05:49:37]  Loading plugin: MapAndreas.so

[05:49:37]   Loaded.

[05:49:37]  Loading plugin: sql.so

[05:49:37]   >> SQL plugin v2.6 successfully loaded.

[05:49:37]       + MySQL support is enabled.

[05:49:37]   Loaded.

[05:49:37]  Loading plugin: Whirlpool.so

[05:49:37]  

[05:49:37]  ==================

[05:49:37]  

[05:49:37]   Whirlpool loaded

[05:49:37]  

[05:49:37]  ==================

[05:49:37]  

[05:49:37]   Loaded.

[05:49:37]  Loading plugin: crashdetect.so

[05:49:37]   CrashDetect v4.12 is OK.

[05:49:37]   Loaded.

[05:49:37]  Loaded 6 plugins.


[05:49:37] 

[05:49:37] Filterscripts

[05:49:37] ---------------

[05:49:37]   Loaded 0 filterscripts.


[05:49:37] [debug] Run time error 19: "File or function is not found"

[05:49:37] [debug]  cache_get_data

[05:49:37] [debug]  cache_get_field_content

[05:49:37] [debug]  mysql_tquery

[05:49:37] [debug]  mysql_escape_string

[05:49:37] [debug]  mysql_connect

[05:49:37] [debug]  mysql_close

[05:49:37] [debug]  cache_get_row

[05:49:37] [debug]  cache_affected_rows

[05:49:37] [debug]  mysql_reconnect

[05:49:37] [debug] Run time error 19: "File or function is not found"

[05:49:37] [debug]  cache_get_data

[05:49:37] [debug]  cache_get_field_content

[05:49:37] [debug]  mysql_tquery

[05:49:37] [debug]  mysql_escape_string

[05:49:37] [debug]  mysql_connect

[05:49:37] [debug]  mysql_close

[05:49:37] [debug]  cache_get_row

[05:49:37] [debug]  cache_affected_rows

[05:49:37] [debug]  mysql_reconnect

[05:49:37] Script[gamemodes/mrp.amx]: Run time error 19: "File or function is not found"

[05:49:37] Number of vehicle models: 0

Re: Mysql - server has gone away - reckst4r - 13.01.2014

Does anyone know how this can be solved?

Re: Mysql - server has gone away - Flake. - 13.01.2014

Make sure all your plugins are updated/downgraded to the correct version, re-compile the relevant scripts and attempt to start it once again.

Re: Mysql - server has gone away - Yashas - 13.01.2014

You can't use another plugin unless you change your code because the function names and the way they work differ.Check if you have mysql_connect and also check weather you have given the right parameters.The do

pawn Код:

printf("%d",mysql_connect(....));

So that we can see if the connection at the first place was established or not.

Re: Mysql - server has gone away - reckst4r - 13.01.2014

Everything is exactly the same as it is on the windows server. The hostname is the same, the username is the same, the password is the same, the port is the same. I'd downgrade to the mysql version that I used on windows, however, I can't find it anywhere anymore. I was using BlueG's R27 static.

I added the mysql_connect function to ongamemodeinit, and it returns 1.