SA-MP Forums Archive
MySQL Insanity! - 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 Insanity! (/showthread.php?tid=505649)


MySQL Insanity! - Eshaan - 09.04.2014

I am getting this error while starting my server! Using BlueG plugin R5

Quote:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[10:50:49]
[10:50:49] Server Plugins
[10:50:49] --------------
[10:50:49] Loading plugin: crashdetect.so
[10:50:49] CrashDetect v4.13.1 is OK.
[10:50:49] Loaded.
[10:50:49] Loading plugin: sscanf.so
[10:50:49]

[10:50:49] ===============================

[10:50:49] sscanf plugin loaded.

[10:50:49] © 2009 Alex "******" Cole

[10:50:49] 0.3d-R2 500 Players "dnee"

[10:50:49] ===============================

[10:50:49] Loaded.
[10:50:49] Loading plugin: streamer.so
[10:50:49]

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

[10:50:49] Loaded.
[10:50:49] Loading plugin: mysql.so
[10:50:49] Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
[10:50:49] Loaded 3 plugins.

[10:50:49]
[10:50:49] Filterscripts
[10:50:49] ---------------
[10:50:49] Loading filterscript 'anims.amx'...
[10:50:49] Unable to load filterscript 'anims.amx'.
[10:50:49] Loaded 0 filterscripts.

[10:50:49] [debug] Run time error 19: "File or function is not found"
[10:50:49] [debug] mysql_connect
[10:50:49] [debug] mysql_debug
[10:50:49] [debug] mysql_query
[10:50:49] [debug] mysql_close
[10:50:49] [debug] mysql_real_escape_string
[10:50:49] [debug] mysql_store_result
[10:50:49] [debug] mysql_num_rows
[10:50:49] [debug] mysql_free_result
[10:50:49] [debug] mysql_fetch_row_format
[10:50:49] [debug] mysql_fetch_field_row
[10:50:49] [debug] mysql_retrieve_row
[10:50:49] [debug] Run time error 19: "File or function is not found"
[10:50:49] [debug] mysql_connect
[10:50:49] [debug] mysql_debug
[10:50:49] [debug] mysql_query
[10:50:49] [debug] mysql_close
[10:50:49] [debug] mysql_real_escape_string
[10:50:49] [debug] mysql_store_result
[10:50:49] [debug] mysql_num_rows
[10:50:49] [debug] mysql_free_result
[10:50:49] [debug] mysql_fetch_row_format
[10:50:49] [debug] mysql_fetch_field_row
[10:50:49] [debug] mysql_retrieve_row
[10:50:49] Script[gamemodes/COD.amx]: Run time error 19: "File or function is not found"
[10:50:49] Number of vehicle models: 0
Everything works fine on my windows host but the host won't start!

Already referred this this http://forum.sa-mp.com/showpost.php?...&postcount=553

Putting this file in main server folder as well as in plugins! But the host won't start!

Re: MySQL Insanity! - iBanner - 09.04.2014

1. This error
Quote:

Failed (libmysqlclient_r.so.15: cannot open shared object file: No such file or directory)
download it here http://forum.sa-mp.com/showpost.php?...&postcount=553

and paste it in the main directory of your server files.

2. Another one
Quote:

Run time error 19: "File or function is not found"
Make sure you have the mysql.so or mysql.dll including the file a_mysql.inc put the mysql.so/mysql.dll in the plugins folder and the a_mysql.inc inside the pawno/includes folder

3.
Quote:

[10:50:49]
[10:50:49] Filterscripts
[10:50:49] ---------------
[10:50:49] Loading filterscript 'anims.amx'...
[10:50:49] Unable to load filterscript 'anims.amx'.
[10:50:49] Loaded 0 filterscripts
Above is the 3rd problem, not highly risk but you must fix this. recompile and post the warnings/errors that will show.


Don't forget to recompile your script to take effect of the changes you've added.

EDIT:
lol how come you didn't know this when you got 11 reps?

Re: MySQL Insanity! - Konstantinos - 09.04.2014

And except the mysql error, I'd highily recommend you to update sscanf to 2.8.1, mysql to R33+ (R38 is the latest) and atleast use threaded queries.

Re: MySQL Insanity! - Eshaan - 10.04.2014

First of all. Read the topic properly! I alreay mentioned and tried what you said!

Second is that, that file or function error is comming due to the library itself. So firstly leaen yourself how thing works!

Third, the script won't even compile if a_mysql.inc wud not be in pawno include folder.

Fourth, that anims.amx won't cause that error coz it's a default fs in samp server which I forgot to remove.


See how I got that rep?

Also, you might not be knowing script is compiled later and includes compile first.

I updated the plugins thanks for the reminder Konstan!