Error with MySQL when put on the server

Error with MySQL when put on the server - 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: Error with MySQL when put on the server (/showthread.php?tid=642262)

Error with MySQL when put on the server - Dello - 26.09.2017

Hi there. I'm so stressed of this error. I dont know if my PC is has to do with this problem, because is a little new. In my other Notebook, i didnt had this problem with any server, but now, some servers open and others not.
I tried all, upgrade the plugins, upgrade the includes and the .NET framework.
I had already installed a C++.

Error example on server "Watts City".

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[14:19:58] 
[14:19:58] Server Plugins
[14:19:58] --------------
[14:19:58]  Loading plugin: mysql
[14:19:58]   Failed.
[14:19:58]  Loading plugin: sscanf
[14:19:58] 

[14:19:58]  ===============================

[14:19:58]       sscanf plugin loaded.     

[14:19:58]          Version:  2.8.1        

[14:19:58]    © 2012 Alex "******" Cole  

[14:19:58]  ===============================

[14:19:58]   Loaded.
[14:19:58]  Loading plugin: crashdetect
[14:19:58]   CrashDetect v4.15.1 is OK.
[14:19:58]   Loaded.
[14:19:58]  Loading plugin: streamer
[14:19:58] 

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

[14:19:58]   Loaded.
[14:19:58]  Loading plugin: nativechecker
[14:19:58]   Loaded.
[14:19:58]  Loaded 4 plugins.

[14:19:58] 
[14:19:58] Filterscripts
[14:19:58] ---------------
[14:19:58]   Loading filterscript 'TextDrawEditor1.0.amx'...
[14:19:59] 
--------------------------------------
[14:19:59]  Text Draw Editor 1.0RC2 by Zamaroht for SA-MP 0.3 Loaded.
[14:19:59] --------------------------------------

[14:19:59]   Loaded 1 filterscripts.

[14:19:59]    Error: Function not registered: 'mysql_escape_string'
[14:19:59]    Error: Function not registered: 'mysql_query'
[14:19:59]    Error: Function not registered: 'cache_get_row_count'
[14:19:59]    Error: Function not registered: 'cache_get_row_int'
[14:19:59]    Error: Function not registered: 'cache_get_row_float'
[14:19:59]    Error: Function not registered: 'cache_get_row'
[14:19:59]    Error: Function not registered: 'cache_get_field_count'
[14:19:59]    Error: Function not registered: 'mysql_log'
[14:19:59]    Error: Function not registered: 'mysql_connect'
[14:19:59]    Error: Function not registered: 'mysql_errno'
[14:19:59]    Error: Function not registered: 'cache_get_data'
[14:19:59]    Error: Function not registered: 'cache_insert_id'
[14:19:59] [debug] Run time error 19: "File or function is not found"
[14:19:59] [debug]  mysql_escape_string
[14:19:59] [debug]  mysql_query
[14:19:59] [debug]  cache_get_row_count
[14:19:59] [debug]  cache_get_row_int
[14:19:59] [debug]  cache_get_row_float
[14:19:59] [debug]  cache_get_row
[14:19:59] [debug]  cache_get_field_count
[14:19:59] [debug]  mysql_log
[14:19:59] [debug]  mysql_connect
[14:19:59] [debug]  mysql_errno
[14:19:59] [debug]  cache_get_data
[14:19:59] [debug]  cache_insert_id
[14:19:59] [debug] Run time error 19: "File or function is not found"
[14:19:59] [debug]  mysql_escape_string
[14:19:59] [debug]  mysql_query
[14:19:59] [debug]  cache_get_row_count
[14:19:59] [debug]  cache_get_row_int
[14:19:59] [debug]  cache_get_row_float
[14:19:59] [debug]  cache_get_row
[14:19:59] [debug]  cache_get_field_count
[14:19:59] [debug]  mysql_log
[14:19:59] [debug]  mysql_connect
[14:19:59] [debug]  mysql_errno
[14:19:59] [debug]  cache_get_data
[14:19:59] [debug]  cache_insert_id
[14:19:59] Script[gamemodes/gm.amx]: Run time error 19: "File or function is not found"
[14:19:59] Number of vehicle models: 0

Thanks to all.

Re: Error with MySQL when put on the server - Dayrion - 26.09.2017

Код:

[14:19:58] --------------
[14:19:58]  Loading plugin: mysql
[14:19:58]   Failed.

That's what your problem come from. Try to reinstall the plugin and follow the author's instructions.

Re: Error with MySQL when put on the server - Dello - 28.09.2017

I had already do this. Idk do now, i tried with all.

Re: Error with MySQL when put on the server - MEW273 - 28.09.2017

Quote:

Originally Posted by Dello

I had already do this. Idk do now, i tried with all.

You should check your server.cfg file to make sure that the MySQL plugin is listed as a plugin and that the .dll (or .so if Linux) is in the plugins folder. The name in the server.cfg and in the plugins folder must match.

Re: Error with MySQL when put on the server - jlalt - 28.09.2017

https://github.com/pBlueG/SA-MP-MySQ...eb30/README.md

Q: The plugin fails to load on Windows, how can I fix this?
A: You have to install these Microsoft C++ redistributables. You'll need the x86/32bit downloads.

2010 (x86)
2010 SP1 (x86)
2012 (x86)
2015 (x86)

Q: I'm not on Windows 10 and the plugin still fails to load after installing all the redistributables. Is there a solution for this?
A: Download the universal Windows CRT. Requirements for this:

Windows 8.1 and Windows Server 2012 R2: KB2919355
Windows 7 and Windows Server 2008 R2: Service Pack 1
Windows Vista and Windows Server 2008: Service Pack 2

Re: Error with MySQL when put on the server - R4nd4ll - 28.09.2017

Try to add " mysql_static.so "
In your server.cfg if you are using linux
It worked for me