[KingPersona]

Hello

i have Problem when i start server , is say me Unknown Mod , and I put all in PhpMyadmin.

+rep for any helped me

Server_Log

Код:

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

[KingPersona]

Bump

[Chenko]

Make sure you have the mysql plugin in your SAMP server plugins folder and you have the plugin in the server.cfg file

[Konstantinos]

Load the R38 version of the MySQL plugin, not R7.

[KingPersona]

Quote:

Originally Posted by Chenko Make sure you have the mysql plugin in your SAMP server plugins folder and you have the plugin in the server.cfg file

Dude , i have already Plugin Mysql , you not see server_Log , is Loading Mysql.so...

[KingPersona]

Quote:

Originally Posted by Konstantinos Load the R38 version of the MySQL plugin, not R7.

i did it bro see result :/

Server_Log

Код:

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

[KingPersona]

Quote:

Originally Posted by ****** Then you have the wrong version, or the wrong plugin - there are multiple versions of MySQL plugins, and multiple plugins from different authors.

i see, i have in Includes a_mysql.inc v R35

[Konstantinos]

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.

[KingPersona]

Quote:

Originally Posted by Konstantinos 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.

Thanks for answer
, see when i compile Mysql r38 [errors]

Код:

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.

and When i did Version Mysql R34 is compilte normal , and in Server_Log
and is not say me Unknown mod , mm cant connect in server

Код:

----------
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.

[Konstantinos]

Change "mysql_insert_id" to "cache_insert_id".