SA-MP Forums Archive
MySQL plugin problem - 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 plugin problem (/showthread.php?tid=496363)



MySQL plugin problem - SpiritM - 21.02.2014

Hello, I am getting these errors:

Код:
[23:57:53] *** Streamer Plugin: Include file version (0x26104) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[23:57:53]    Error: Function not registered: 'mysql_function_query'
[23:57:53]    Error: Function not registered: 'cache_get_data'
[23:57:53]    Error: Function not registered: 'cache_get_row'
[23:57:53]    Error: Function not registered: 'WP_Hash'
[23:57:53]    Error: Function not registered: 'cache_get_field'
[23:57:53]    Error: Function not registered: 'mysql_debug'
[23:57:53]    Error: Function not registered: 'enable_mutex'
[23:57:53] Script[gamemodes/NWRP.amx]: Run time error 19: "File or function is not found"
[23:57:53] Number of vehicle models: 0
Please help me.


Re: MySQL plugin problem - venomlivno8 - 21.02.2014

Did you put "plugin mysql" into server.cfg?


Re: MySQL plugin problem - SpiritM - 21.02.2014

Quote:
Originally Posted by venomlivno8
Посмотреть сообщение
Did you put "plugin mysql" into server.cfg?
Yeah, it is in there


Re: MySQL plugin problem - Smally - 21.02.2014

Show us the whole server log, the lines above are the most important.


Re: MySQL plugin problem - SpiritM - 22.02.2014

Quote:
Originally Posted by Smally
Посмотреть сообщение
Show us the whole server log, the lines above are the most important.
Here is my server_log

Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[15:22:57] 
[15:22:57] Server Plugins
[15:22:57] --------------
[15:22:57]  Loading plugin: crashdetect.so
[15:22:57]   Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by plugins/crashdetect.so))
[15:22:57]  Loading plugin: sscanf.so
[15:22:57] 

[15:22:57]  ===============================

[15:22:57]       sscanf plugin loaded.     

[15:22:57]          Version:  2.8.1        

[15:22:57]    © 2012 Alex "******" Cole  

[15:22:57]  ===============================

[15:22:57]   Loaded.
[15:22:57]  Loading plugin: mysql.so
[15:22:57]  SA:MP MySQL Plugin v2.1.1 Loaded.
[15:22:57]   Loaded.
[15:22:57]  Loading plugin: streamer.so
[15:22:57] 

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

[15:22:57]   Loaded.
[15:22:57]  Loading plugin: dns.so
[15:22:57] 

*** DNS Plugin v2.4 by Incognito loaded ***

[15:22:57]   Loaded.
[15:22:57]  Loading plugin: Whirlpool.so
[15:22:57] [MySQL] Thread running. Threadsafe: Yes.
[15:22:57]   Failed (plugins/Whirlpool.so: wrong ELF class: ELFCLASS64)
[15:22:57]  Loading plugin: audio.so
[15:22:57] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[15:22:57]   Loaded.
[15:22:57]  Loading plugin: nativechecker.so
[15:22:57]   Loaded.
[15:22:57]  Loaded 6 plugins.

[15:22:57] 
[15:22:57] Ban list
[15:22:57] --------
[15:22:57]  Loaded: samp.ban
[15:22:57] 
[15:22:57] 
[15:22:57] Filterscripts
[15:22:57] ---------------
[15:22:57]   Loading filterscript 'Walkingstyle.amx'...
[15:22:57] 
Walking Styles by Zack_Larson Loaded.

[15:22:57]   Loaded 1 filterscripts.

[15:22:57] *** Streamer Plugin: Include file version (0x26104) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[15:22:57]    Error: Function not registered: 'mysql_function_query'
[15:22:57]    Error: Function not registered: 'cache_get_data'
[15:22:57]    Error: Function not registered: 'cache_get_row'
[15:22:57]    Error: Function not registered: 'WP_Hash'
[15:22:57]    Error: Function not registered: 'cache_get_field'
[15:22:57]    Error: Function not registered: 'mysql_debug'
[15:22:57]    Error: Function not registered: 'enable_mutex'
[15:22:57] Script[gamemodes/NWRP.amx]: Run time error 19: "File or function is not found"
[15:22:57] Number of vehicle models: 0



Re: MySQL plugin problem - Konstantinos - 22.02.2014

Wrong MySQL plugin. You need R7 by BlueG.

About Whirlpool: https://sampforum.blast.hk/showthread.php?tid=415002

And re-compile your scripts with the version 2.6.1 of streamer.inc


Re: MySQL plugin problem - Luca12 - 22.02.2014

you use wrong version of the mysql plugin you need mysql plugin R7 or R8

here:

pawn Код:
http://forum.sa-mp.com/showthread.php?t=56564



Re: MySQL plugin problem - SpiritM - 22.02.2014

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
Wrong MySQL plugin. You need R7 by BlueG.

About Whirlpool: https://sampforum.blast.hk/showthread.php?tid=415002

And re-compile your scripts with the version 2.6.1 of streamer.inc
I put on the R7 mysql from BlueG and I also put on that Whirlpool from the link that you sent me, also, my streamer is already updated to that version with the .inc of that version too, and this is what I get now

Код:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3x, ©2005-2013 SA-MP Team

[15:44:05] 
[15:44:05] Server Plugins
[15:44:05] --------------
[15:44:05]  Loading plugin: crashdetect.so
[15:44:05]   Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.11' not found (required by plugins/crashdetect.so))
[15:44:05]  Loading plugin: sscanf.so
[15:44:05] 

[15:44:05]  ===============================

[15:44:05]       sscanf plugin loaded.     

[15:44:05]          Version:  2.8.1        

[15:44:05]    © 2012 Alex "******" Cole  

[15:44:05]  ===============================

[15:44:05]   Loaded.
[15:44:05]  Loading plugin: mysql.so
[15:44:05]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[15:44:05]  Loading plugin: streamer.so
[15:44:05] 

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

[15:44:05]   Loaded.
[15:44:05]  Loading plugin: dns.so
[15:44:05] 

*** DNS Plugin v2.4 by Incognito loaded ***

[15:44:05]   Loaded.
[15:44:05]  Loading plugin: Whirlpool.so
[15:44:05]   Failed (plugins/Whirlpool.so: wrong ELF class: ELFCLASS64)
[15:44:05]  Loading plugin: audio.so
[15:44:05] 

*** Audio Plugin v0.5 R2 by Incognito loaded ***

[15:44:05]   Loaded.
[15:44:05]  Loading plugin: nativechecker.so
[15:44:05]   Loaded.
[15:44:05]  Loaded 5 plugins.

[15:44:05] 
[15:44:05] Ban list
[15:44:05] --------
[15:44:05]  Loaded: samp.ban
[15:44:05] 
[15:44:05] 
[15:44:05] Filterscripts
[15:44:05] ---------------
[15:44:05]   Loading filterscript 'Walkingstyle.amx'...
[15:44:05] 
Walking Styles by Zack_Larson Loaded.

[15:44:05]   Loaded 1 filterscripts.

[15:44:05] *** Streamer Plugin: Include file version (0x26104) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
[15:44:05]    Error: Function not registered: 'mysql_function_query'
[15:44:05]    Error: Function not registered: 'mysql_real_escape_string'
[15:44:05]    Error: Function not registered: 'mysql_affected_rows'
[15:44:05]    Error: Function not registered: 'cache_get_data'
[15:44:05]    Error: Function not registered: 'cache_get_row'
[15:44:05]    Error: Function not registered: 'mysql_insert_id'
[15:44:05]    Error: Function not registered: 'WP_Hash'
[15:44:05]    Error: Function not registered: 'cache_get_field'
[15:44:05]    Error: Function not registered: 'mysql_debug'
[15:44:05]    Error: Function not registered: 'enable_mutex'
[15:44:05]    Error: Function not registered: 'mysql_connect'
[15:44:05]    Error: Function not registered: 'mysql_close'
[15:44:05]    Error: Function not registered: 'mysql_ping'
[15:44:05] Script[gamemodes/NWRP.amx]: Run time error 19: "File or function is not found"
[15:44:05] Number of vehicle models: 0



Re: MySQL plugin problem - Smally - 22.02.2014

What Linux distribution are you using?


Re: MySQL plugin problem - SpiritM - 22.02.2014

Quote:
Originally Posted by Smally
Посмотреть сообщение
What Linux distribution are you using?
I am using CentOS 64bit