SA-MP Dedicated Server ---------------------- v0.3z, ©2005-2014 SA-MP Team [18:20:23] filterscripts = "" (string) [18:20:23] [18:20:23] Server Plugins [18:20:23] -------------- [18:20:23] Loading plugin: mysql.so [18:20:24] > MySQL plugin R7 successfully loaded. [18:20:24] Loaded. [18:20:24] Loading plugin: sscanf.so [18:20:24] [18:20:24] =============================== [18:20:24] sscanf plugin loaded. [18:20:24] Version: 2.8.1 [18:20:24] © 2012 Alex "******" Cole [18:20:24] =============================== [18:20:24] Loaded. [18:20:24] Loading plugin: streamer.so [18:20:24] *** Streamer Plugin v2.6.1 by Incognito loaded *** [18:20:24] Loaded. [18:20:24] Loading plugin: nativechecker.so [18:20:24] Loaded. [18:20:24] Loading plugin: FileFunctions.so [18:20:24] Loaded. [18:20:24] Loading plugin: CTime.so [18:20:24] � CTime Library Plugin For Pawn v0.1.0 - Copyright � 2011 RyDeR` [18:20:24] Loaded. [18:20:24] Loading plugin: crashdetect.so [18:20:25] crashdetect v4.8.5 is OK. [18:20:25] Loaded. [18:20:25] Loaded 7 plugins. [18:20:28] [18:20:28] Ban list [18:20:28] -------- [18:20:28] Loaded: samp.ban [18:20:28] [18:20:30] [18:20:30] Filterscripts [18:20:30] --------------- [18:20:30] Loaded 0 filterscripts. [18:24:45] Error: Function not registered: 'mysql_tquery' [18:24:45] Error: Function not registered: 'mysql_log' [18:24:45] Error: Function not registered: 'cache_get_row_count' [18:24:45] Error: Function not registered: 'cache_get_field_content_int' [18:24:45] Error: Function not registered: 'cache_get_field_content_float' [18:24:45] Error: Function not registered: 'cache_insert_id' [18:24:45] [debug] Run time error 19: "File or function is not found" [18:24:45] [debug] mysql_tquery [18:24:45] [debug] mysql_log [18:24:45] [debug] cache_get_row_count [18:24:45] [debug] cache_get_field_content_int [18:24:45] [debug] cache_get_field_content_float [18:24:45] [debug] cache_insert_id [18:24:45] Script[gamemodes/spr.amx]: Run time error 19: "File or function is not found" [18:24:45] Number of vehicle models: 0
Make sure you have the mysql plugin in your SAMP server plugins folder and you have the plugin in the server.cfg file
|
SA-MP Dedicated Server ---------------------- v0.3z, ©2005-2014 SA-MP Team [22:56:40] filterscripts = "" (string) [22:56:40] [22:56:40] Server Plugins [22:56:40] -------------- [22:56:40] Loading plugin: mysql.so [22:56:41] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference) [22:56:41] Loading plugin: sscanf.so [22:56:41] [22:56:41] =============================== [22:56:41] sscanf plugin loaded. [22:56:41] Version: 2.8.1 [22:56:41] © 2012 Alex "******" Cole [22:56:41] =============================== [22:56:41] Loaded. [22:56:41] Loading plugin: streamer.so [22:56:42] *** Streamer Plugin v2.6.1 by Incognito loaded *** [22:56:42] Loaded. [22:56:42] Loading plugin: nativechecker.so [22:56:42] Loaded. [22:56:42] Loading plugin: FileFunctions.so [22:56:42] Loaded. [22:56:42] Loading plugin: CTime.so [22:56:42] � CTime Library Plugin For Pawn v0.1.0 - Copyright � 2011 RyDeR` [22:56:42] Loaded. [22:56:42] Loading plugin: crashdetect.so [22:56:42] crashdetect v4.8.5 is OK. [22:56:42] Loaded. [22:56:42] Loaded 6 plugins. [22:56:45] [22:56:45] Ban list [22:56:45] -------- [22:56:45] Loaded: samp.ban [22:56:45] [22:56:48] [22:56:48] Filterscripts [22:56:48] --------------- [22:56:48] Loaded 0 filterscripts. [22:58:25] Error: Function not registered: 'mysql_format' [22:58:25] Error: Function not registered: 'mysql_tquery' [22:58:26] Error: Function not registered: 'mysql_log' [22:58:26] Error: Function not registered: 'mysql_connect' [22:58:26] Error: Function not registered: 'mysql_close' [22:58:26] Error: Function not registered: 'cache_get_row_count' [22:58:26] Error: Function not registered: 'cache_get_field_content' [22:58:26] Error: Function not registered: 'cache_get_field_content_int' [22:58:26] Error: Function not registered: 'cache_get_field_content_float' [22:58:26] Error: Function not registered: 'cache_insert_id' [22:58:26] Error: Function not registered: 'cache_get_data' [22:58:26] [debug] Run time error 19: "File or function is not found" [22:58:26] [debug] mysql_format [22:58:26] [debug] mysql_tquery [22:58:26] [debug] mysql_log [22:58:26] [debug] mysql_connect [22:58:26] [debug] mysql_close [22:58:26] [debug] cache_get_row_count [22:58:26] [debug] cache_get_field_content [22:58:26] [debug] cache_get_field_content_int [22:58:26] [debug] cache_get_field_content_float [22:58:26] [debug] cache_insert_id [22:58:26] [debug] cache_get_data [22:58:26] Script[gamemodes/spr.amx]: Run time error 19: "File or function is not found" [22:58:26] Number of vehicle models: 0
Then you have the wrong version, or the wrong plugin - there are multiple versions of MySQL plugins, and multiple plugins from different authors.
|
Q: I get a Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16[...] error, is there any way to fix it?
A: That likely means that you are using a 64bit system and thus a 64bit libmysqlclient library. You'll have to use the static version of the plugin, the mysql_static.so. --- Get R38 plugin (and load the static version) and include: https://github.com/pBlueG/SA-MP-MySQL/releases/tag/R38 Re-compile your scripts and run the server, it should work. |
D:\Documents and Settings\Administrateur\Mes documents\Downloads\Nouveau dossier\spr\gamemodes\spr.pwn(16276) : error 017: undefined symbol "mysql_insert_id" D:\Documents and Settings\Administrateur\Mes documents\Downloads\Nouveau dossier\spr\gamemodes\spr.pwn(16584) : error 017: undefined symbol "mysql_insert_id" D:\Documents and Settings\Administrateur\Mes documents\Downloads\Nouveau dossier\spr\gamemodes\spr.pwn(16612) : error 017: undefined symbol "mysql_insert_id" Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 3 Errors.
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z, ©2005-2014 SA-MP Team [12:29:06] filterscripts = "" (string) [12:29:06] [12:29:06] Server Plugins [12:29:06] -------------- [12:29:06] Loading plugin: mysql.so [12:29:07] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference) [12:29:07] Loading plugin: sscanf.so [12:29:07] [12:29:07] =============================== [12:29:07] sscanf plugin loaded. [12:29:07] Version: 2.8.1 [12:29:07] © 2012 Alex "******" Cole [12:29:07] =============================== [12:29:07] Loaded. [12:29:07] Loading plugin: streamer.so [12:29:08] *** Streamer Plugin v2.6.1 by Incognito loaded *** [12:29:09] Loaded. [12:29:09] Loading plugin: nativechecker.so [12:29:09] Loaded. [12:29:09] Loading plugin: FileFunctions.so [12:29:09] Loaded. [12:29:09] Loading plugin: CTime.so [12:29:09] � CTime Library Plugin For Pawn v0.1.0 - Copyright � 2011 RyDeR` [12:29:09] Loaded. [12:29:09] Loading plugin: crashdetect.so [12:29:09] crashdetect v4.8.5 is OK. [12:29:09] Loaded. [12:29:09] Loading plugin: mysql_static.so [12:29:11] >> plugin.mysql: R34 successfully loaded. [12:29:11] Loaded. [12:29:11] Loading plugin: mysql_5.5.so [12:29:11] Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory) [12:29:11] Loaded 7 plugins. [12:29:14] [12:29:14] Ban list [12:29:14] -------- [12:29:14] Loaded: samp.ban [12:29:14] [12:29:17] [12:29:17] Filterscripts [12:29:17] --------------- [12:29:17] Loaded 0 filterscripts. [12:31:07] Error: Function not registered: 'mysql_format' [12:31:07] Error: Function not registered: 'mysql_tquery' [12:31:07] Error: Function not registered: 'mysql_log' [12:31:07] Error: Function not registered: 'mysql_connect' [12:31:07] Error: Function not registered: 'mysql_close' [12:31:07] Error: Function not registered: 'cache_get_row_count' [12:31:07] Error: Function not registered: 'cache_get_field_content' [12:31:07] Error: Function not registered: 'cache_get_field_content_int' [12:31:07] Error: Function not registered: 'cache_get_field_content_float' [12:31:07] Error: Function not registered: 'cache_insert_id' [12:31:07] Error: Function not registered: 'cache_get_data' [12:31:08] [12:31:08] [12:31:08] [12:31:08] ======================================= [12:31:08] | | [12:31:08] | YSI version 3.09.0684 | [12:31:08] | By Alex "******" Cole | [12:31:08] | | [12:31:08] ======================================= [12:31:08] [12:31:08] [12:31:34] [12:32:08] Au fost incarcate toate datele din baza de date. [12:32:08] Textdraw-urile au fost create cu succes. [12:32:08] Obiectele au fost create cu succes. [12:32:08] Meniurile au fost create cu succes. [12:32:08] {BABABA}Race 0 not found, failed to load this race. [12:32:08] |---------------------------------| [12:32:08] | | [12:32:08] | SN RPG v1.4 | [12:32:08] |_________________________________| [12:32:08] | By: YooBogdan | [12:32:08] | | [12:32:08] |---------------------------------| [12:32:08] Number of vehicle models: 0 [12:32:08] [12:32:08] ========================================== [12:32:08] | | [12:32:08] | A new version (v<html> ) of YSI is | [12:32:08] | available from: | [12:32:08] | | [12:32:08] | www.y-less.com/YSI/YSI_1.0.zip | [12:32:08] | | [12:32:08] ========================================== [12:32:08] [12:32:09] [ERROR] Au fost incarcate 0 masini din tabelul FlashRacingCars [12:32:45] [SUCCES] Au fost incarcate 2000 masini din tabelul MasiniPersonale [12:32:49] [SUCCES] Au fost incarcate 86 modele din tabelul DealerCars [12:32:49] [SUCCES] Au fost incarcate 20 locatii din tabelul GPS Locations [12:32:49] [SUCCES] Au fost incarcate 9 locatii din tabelul GPS Locations [12:32:49] [SUCCES] Au fost incarcate 10 locatii din tabelul GPS Jobs [12:32:50] [SUCCES] Au fost incarcate 24 bussiness-uri din tabelul Bussiness [12:32:50] [SUCCES] Au fost incarcate 64 case din tabelul Houses [12:32:51] [SUCCES] Au fost incarcate 11 factiuni din tabelul Factions [12:32:51] [SUCCES] Au fost incarcate 46 teritorii din tabelul Turfs [12:32:52] [SUCCES] Au fost incarcate 67 pickup-uri din tabelul Pickups [12:32:52] [ INFO ] Au fost incarcate 8 clanuri din tabelul Clans.