[LollyLosT]

Hello everyone.

So recently I found an improved version of the gamemode I was going to use for my server. The first one had a "Linux" version, and all went good after I installed it.

But this 'improved' one gave me hell for 2 hours already. I CANT FIGURE IT OUT !!

- Re-downloaded all the plugins.
- YES, in server.cfg I have them like "name.so" .
- Got a lot of MySQL versions tested. None of them worked (5.5 , R33, R35, R39-4) . The 'not improved' version was working very fine on 5.5 I think.
So basically, I GOT every plugin covered. I don't think it's their fault. But maybe I'm wrong..?

Here you have the server log, along with native checker. I just gave up, it's 2:00 PM in my country and if I think one more time about this thing , I think I`ll break my computer.

Code:

SA-MP Dedicated Server
----------------------
v0.3.7, ©2005-2015 SA-MP Team

[01:56:43] filterscripts = ""  (string)
[01:56:43] 
[01:56:43] Server Plugins
[01:56:43] --------------
[01:56:43]  Loading plugin: mysq.so
[01:56:43]   Failed (plugins/mysq.so: cannot open shared object file: No such file or directory)
[01:56:43]  Loading plugin: sscanf.so
[01:56:43] 

[01:56:43]  ===============================

[01:56:43]       sscanf plugin loaded.     

[01:56:43]          Version:  2.8.1        

[01:56:43]    © 2012 Alex "Y_Less" Cole  

[01:56:43]  ===============================

[01:56:43]   Loaded.
[01:56:43]  Loading plugin: streamer.so
[01:56:43]   Loaded.
[01:56:43]  Loading plugin: Whirlpool.so
[01:56:43]  
[01:56:43]  ==================
[01:56:43]  
[01:56:43]   Whirlpool loaded
[01:56:43]  
[01:56:43]  ==================
[01:56:43]  
[01:56:43]   Loaded.
[01:56:43]  Loading plugin: nativechecker.so
[01:56:43]   Loaded.
[01:56:43]  Loading plugin: crashdetect.so
[01:56:43]   CrashDetect v4.12 is OK.
[01:56:43]   Loaded.
[01:56:43]  Loading plugin: mysql_static.so
[01:56:43]  >> plugin.mysql: R39-4 successfully loaded.
[01:56:43]   Loaded.
[01:56:43]  Loaded 6 plugins.

[01:56:43] 
[01:56:43] Filterscripts
[01:56:43] ---------------
[01:56:43]   Loaded 0 filterscripts.

[01:56:43]    Error: Function not registered: 'mysql_connect'
[01:56:43]    Error: Function not registered: 'mysql_ping'
[01:56:43]    Error: Function not registered: 'mysql_function_query'
[01:56:43]    Error: Function not registered: 'cache_get_field_content'
[01:56:43]    Error: Function not registered: 'mysql_real_escape_string'
[01:56:43]    Error: Function not registered: 'cache_get_data'
[01:56:43]    Error: Function not registered: 'mysql_affected_rows'
[01:56:43]    Error: Function not registered: 'mysql_insert_id'
[01:56:43]    Error: Function not registered: 'cache_get_row'
[01:56:43] [debug] Run time error 19: "File or function is not found"
[01:56:43] [debug]  mysql_ping
[01:56:43] [debug]  mysql_function_query
[01:56:43] [debug]  mysql_real_escape_string
[01:56:43] [debug]  mysql_affected_rows
[01:56:43] [debug]  mysql_insert_id
[01:56:43] [debug] Run time error 19: "File or function is not found"
[01:56:43] [debug]  mysql_ping
[01:56:43] [debug]  mysql_function_query
[01:56:43] [debug]  mysql_real_escape_string
[01:56:43] [debug]  mysql_affected_rows
[01:56:43] [debug]  mysql_insert_id
[01:56:43] Script[gamemodes/roleplay.amx]: Run time error 19: "File or function is not found"
[01:56:43] Number of vehicle models: 0
[01:56:43] New version of CrashDetect is available for download (4.13)

If someone can help me.. thanks!

[Sew_Sumi]

You don't need crash detect when you can see "[01:56:43] [debug] Run time error 19: "File or function is not found"" in your log...

That'll be your problem. Don't rely on CrashDetect when it's actually not needed.


You've got "mysq" (Spelt wrong) listed as a plugin, that fails, then you also have mysql_static which then loads. And yet still, you have a fail in the mysql side of things.

If you've simply put the updated version of the MySQL plugin, and haven't updated your code, then this will be affecting it.


From version 5.5, to R32+, there are major differences. You'll need to update the gamemode if you want it to work with the newer version, or to have any support regarding it.

[LollyLosT]

Well the server had an updated mysql . Server n1 had mysql 5.5 , this one R33 I THINK.
So the new server came all with the plugins I needed. But it still doesnt work..
Anyway, fixed the name. Now I get :

Code:

Loading plugin: mysql.so
 Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

[Sew_Sumi]

You'll need someone with more Linux experience.


Did you remove the second MySQL plugin in the plugins line in server.cfg?

[LollyLosT]

OK, solved it by myself, FINNALY.

Downloaded mysql R34, compiled it with it, uploaded the .so to the host and it worked. !!
Realised that was the problem when I got R39 and it didnt compile, giving me 99999 errors because the plugin was made with an older mysql version, so I tested EVERY ONE of them until it worked

[Sew_Sumi]

R34 will be where I said about the change in methods was done.