[IblackhawkI]

Hey all,

So I went updating from a really old version of MySQL (Which is unknown to me, might be R6).
Currently I'm trying to set up the R39-2, just for testing if everything still works. Then I'll update it further to R43.

The script is compiled and updated, no errors left. But unfortunately, the server is not able to find the mysql.dll.

Also, just for your information: It's a windows server. Currently running W10 X64.

The server.cfg

Код:

echo Executing Server Config...
lanmode 0
rcon_password ..admin..
maxplayers 200
port 8080
hostname TestingServer
gamemode0 GM
filterscripts Animlist GMcustommapping
plugins streamer sscanf crashdetect socket mysql
announce 0
query 1
weburl n/a
mapname San Andreas
maxnpc 0
onfoot_rate 50
incar_rate 50
weapon_rate 50
stream_distance 200.0
stream_rate 2000
logtimeformat [%d/%m/%Y %H:%M:%S]
rcon 0
ackslimit 10000

Код:

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

SA-MP Dedicated Server
----------------------
v0.3.DL-R1, ©2005-2018 SA-MP Team

[22/06/2018 16:42:34] 
[22/06/2018 16:42:34] Server Plugins
[22/06/2018 16:42:34] --------------
[22/06/2018 16:42:34]  Loading plugin: streamer
[22/06/2018 16:42:34] 

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

[22/06/2018 16:42:34]   Loaded.
[22/06/2018 16:42:34]  Loading plugin: sscanf
[22/06/2018 16:42:34] 

[22/06/2018 16:42:34]  ===============================

[22/06/2018 16:42:34]       sscanf plugin loaded.     

[22/06/2018 16:42:34]          Version:  2.8.2        

[22/06/2018 16:42:34]    © 2012 Alex "******" Cole  

[22/06/2018 16:42:34]  ===============================

[22/06/2018 16:42:34]   Loaded.
[22/06/2018 16:42:34]  Loading plugin: crashdetect
[22/06/2018 16:42:34]   crashdetect v4.8.3 is OK.
[22/06/2018 16:42:34]   Loaded.
[22/06/2018 16:42:34]  Loading plugin: socket
[22/06/2018 16:42:35]  Socket plugin v0.1b loaded.
[22/06/2018 16:42:35]   Loaded.
[22/06/2018 16:42:35]  Loading plugin: mysql
[22/06/2018 16:42:35]   Failed.
[22/06/2018 16:42:35]  Loaded 4 plugins.

[22/06/2018 16:42:35] 
[22/06/2018 16:42:35] Filterscripts
[22/06/2018 16:42:35] ---------------
[22/06/2018 16:42:35]   Loading filterscript 'Animlist.amx'...
[22/06/2018 16:42:35] 
--------------------------------------
[22/06/2018 16:42:35]    -G.O-Anim Sytem     By: G4M3Ov3r         
[22/06/2018 16:42:35] --------------------------------------

[22/06/2018 16:42:35]   Loading filterscript 'GMcustommapping.amx'...
[22/06/2018 16:42:35] Loading mapping: pilota's house (including ints)
[22/06/2018 16:42:35] Loading mapping: PDIR 
[22/06/2018 16:42:35] Loading mapping: gym 
[22/06/2018 16:42:35] Loading mapping: amunation
[22/06/2018 16:42:35] Loading mapping: studio
[22/06/2018 16:42:35] Loading mapping: ranch
[22/06/2018 16:42:35] Loading mapping: Bowling
[22/06/2018 16:42:35] Loading mapping: Bar And Stripclub
[22/06/2018 16:42:35]   Loaded 2 filterscripts.

[22/06/2018 16:42:36] [debug] Run time error 19: "File or function is not found"
[22/06/2018 16:42:36] [debug]  cache_get_field_content
[22/06/2018 16:42:36] [debug]  mysql_query
[22/06/2018 16:42:36] [debug]  mysql_connect
[22/06/2018 16:42:36] [debug]  cache_insert_id
[22/06/2018 16:42:36] [debug]  cache_save
[22/06/2018 16:42:36] [debug]  cache_get_row_count
[22/06/2018 16:42:36] [debug]  cache_get_row
[22/06/2018 16:42:36] Script[gamemodes/GM.amx]: Run time error 19: "File or function is not found"
[22/06/2018 16:42:36] Number of vehicle models: 0

I've got the MySQL.dll and the MySQL.pdb in the /plugins directory. And the libmySQL.dll is placed in the root dir.

What can I do to solve this?

[Akeem]

You have to update the mysql plugin.
Note: i find this happening when i don't have matching inc and plugin version.

[jasperschellekens]

Akeem is right i think. When compiling with a different include version then the plugin this may occur.

[Akeem]

https://github.com/pBlueG/SA-MP-MySQL/releases

You can get the latest inc and plugin version there ^

[div]

the MySQL plugin is compiled with the gamemode, but it isn't available as a PLUGIN to carry out functions..


Install the latest VCREDIST, or if the windows is pirated, try VCREDIST AIO INSTALLER REPACK


If that doesn't help, use MySQL R39 plugin, that will work for sure, and is easy as hell, I'm using due to pirated windows, i can help you if you want .

[IblackhawkI]

Quote:

Originally Posted by Akeem You have to update the mysql plugin. Note: i find this happening when i don't have matching inc and plugin version.

& @Jasper

I did update the plugins. It might be that the inc wasn't there whilst compiling, now I think about it... Will check it tomorrow. I had the R33 on this one before, but that had the same error.

Quote:

Originally Posted by div the MySQL plugin is compiled with the gamemode, but it isn't available as a PLUGIN to carry out functions.. Install the latest VCREDIST, or if the windows is pirated, try VCREDIST AIO INSTALLER REPACK If that doesn't help, use MySQL R39 plugin, that will work for sure, and is easy as hell, I'm using due to pirated windows, i can help you if you want .

I've installed the VCREDIST, as I've got a legal version of W10. But that didn't help either. The R39 is currently installed. Or what's the difference between the 39 and 39-2?

I'll keep you updated about this one.
Thanks so far!

[Calisthenics]

If the version of the include and plugin do not match, it can indeed give run time error 19 but in his case the plugin fails to load from the beginning so it is not that.

https://github.com/pBlueG/SA-MP-MySQL#faq
Read 5th question, you need to have these installed. The x86 version only.