Mysql not loading. - 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 not loading. (/showthread.php?tid=655498)
+- 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 not loading. (/showthread.php?tid=655498)
Mysql not loading. - IblackhawkI - 22.06.2018
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
What can I do to solve this?
Re: Mysql not loading. - Akeem - 22.06.2018
You have to update the mysql plugin.
Note: i find this happening when i don't have matching inc and plugin version.
Re: Mysql not loading. - jasperschellekens - 22.06.2018
Akeem is right i think. When compiling with a different include version then the plugin this may occur.
Re: Mysql not loading. - Akeem - 22.06.2018
https://github.com/pBlueG/SA-MP-MySQL/releases
You can get the latest inc and plugin version there ^
Re: Mysql not loading. - div - 22.06.2018
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
.
Re: Mysql not loading. - IblackhawkI - 22.06.2018
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. |
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'll keep you updated about this one.
Thanks so far!
Re: Mysql not loading. - Calisthenics - 23.06.2018
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.