SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 26/12/2016, 09:06 AM   #1
Ahmed21
Big Clucker
 
Join Date: Jul 2016
Posts: 158
Reputation: 3
Default Running Server MySQL Error

Hello, I've decided to re-run my server on localhost again after 4 months of scripting it. I did run the samp-server file, and it said: Run Time Error: Function not found etc.., then I added crashdetect, and it said:

HTML Code:
[11:26:08] [debug] Run time error 19: "File or function is not found"
[11:26:08] [debug]  mysql_store_result
[11:26:08] [debug]  mysql_num_rows
[11:26:08] [debug]  mysql_free_result
[11:26:08] [debug]  mysql_fetch_row
[11:26:08] [debug]  mysql_real_escape_string
[11:26:08] [debug]  mysql_init
[11:26:08] [debug] Run time error 19: "File or function is not found"
[11:26:08] [debug]  mysql_store_result
[11:26:08] [debug]  mysql_num_rows
[11:26:08] [debug]  mysql_free_result
[11:26:08] [debug]  mysql_fetch_row
[11:26:08] [debug]  mysql_real_escape_string
[11:26:08] [debug]  mysql_init
[11:26:08] Script[gamemodes/CnR.amx]: Run time error 19: "File or function is not found"
[11:26:08] Number of vehicle models: 0
I'm sure I used to run it on my localhost before and it worked very well, but I don't know what is wrong with it now, I've downloaded the newest MySQL version which is v41, and still same shit. Important note, it is that the gamemode has #include <mysql> and not #include <a_mysql>, I tried to change it to a_mysql but it at the compiling it given me many errors (undefined ..). So please anyone help?
Ahmed21 is offline   Reply With Quote
Old 26/12/2016, 09:21 AM   #2
Younes44
Gangsta
 
Younes44's Avatar
 
Join Date: Oct 2013
Posts: 763
Reputation: 80
Default Re: Running Server MySQL Error

try to use mysql_static.so
__________________
Left SA:MP, and not avalaible anymore!!
Thanks samp for awesome moments, i enjoy!! Goodbye!
ModernFreeroam: www.mf-samp.com , IP:94.23.255.30:7777
CounterTerroristUnit: www.ctu.w4f.eu , IP:87.98.243.201:6969
xSF: www.xsfserver.com , IP: 87.98.243.201:6969
Exm: www.exmserv.me , IP: exmserv.me:7777
Underground Stunting: www.ustunting.com , IP:145.239.3.225:7777

Thanks everyone,for the awesome moments,
Regards, COD Ghosts owner.
Younes44 ,YOuNeS_Dz ,WarZ ,Bryan_ , Kaneki
Younes44 is offline   Reply With Quote
Old 26/12/2016, 09:37 AM   #3
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,827
Reputation: 1401
Default Re: Running Server MySQL Error

Wrong mysql plugin. The script was using: http://forum.sa-mp.com/showthread.php?t=122983

But yeah.. switching to BlueG's mysql plugin (latest version) is always recommended as there's no support for that old outdated plugin (StrickenKid's). Of course it's not just plug and play, you'll need to update the script (change the code).
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos is offline   Reply With Quote
Old 26/12/2016, 09:50 AM   #4
Ahmed21
Big Clucker
 
Join Date: Jul 2016
Posts: 158
Reputation: 3
Default Re: Running Server MySQL Error

Quote:
Originally Posted by Konstantinos View Post
Wrong mysql plugin. The script was using: http://forum.sa-mp.com/showthread.php?t=122983

But yeah.. switching to BlueG's mysql plugin (latest version) is always recommended as there's no support for that old outdated plugin (StrickenKid's). Of course it's not just plug and play, you'll need to update the script (change the code).
I've gone to StrickenKid's website (the link you provided), and it says the domain maybe for sale, and I can't download anything. Can you please send me a download link for it?
Ahmed21 is offline   Reply With Quote
Old 26/12/2016, 09:53 AM   #5
Konstantinos
Spam Machine
 
Konstantinos's Avatar
 
Join Date: Dec 2011
Posts: 11,827
Reputation: 1401
Default Re: Running Server MySQL Error

Quote:
Originally Posted by Ahmed21 View Post
I've gone to StrickenKid's website (the link you provided), and it says the domain maybe for sale, and I can't download anything. Can you please send me a download link for it?
It happens. Always read the last comments because most likely someone has provided links there: http://forum.sa-mp.com/showpost.php?...postcount=1005
__________________
Life is like riding a bicycle. To keep your balance, you must keep moving.

[Tutorial] How to use SQLite
[FilterScript] Tune System
Konstantinos is offline   Reply With Quote
Old 26/12/2016, 09:56 AM   #6
Ahmed21
Big Clucker
 
Join Date: Jul 2016
Posts: 158
Reputation: 3
Default Re: Running Server MySQL Error

Quote:
Originally Posted by Konstantinos View Post
It happens. Always read the last comments because most likely someone has provided links there: http://forum.sa-mp.com/showpost.php?...postcount=1005
Okay, thank you so much my friend! +REP'd
Ahmed21 is offline   Reply With Quote
Old 26/12/2016, 10:22 AM   #7
Ahmed21
Big Clucker
 
Join Date: Jul 2016
Posts: 158
Reputation: 3
Default Re: Running Server MySQL Error

Hello, after solving that problem above, I got a new kind problem e.e, it says on the server-samp file:

NOTE: I'm still running it on the localhost as well.

Code:
[MySQL] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
Here's the thing that I have on OnGameModeInit:
PHP Code:
connection mysql_init(LOG_ONLY_ERRORS1);
    
mysql_connect("localhost""root"" ""ccnr"connection1); 
What is wrong with it?!
Ahmed21 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help to running MySQL SA-MP server (LINUX)! VenomMancer Server Support 7 12/02/2015 09:49 AM
Mysql functions error on running server EgyptForLife Scripting Help 2 10/10/2014 10:06 PM
MySQL Error When Running server Jigsaw123 Scripting Help 4 04/06/2014 05:17 PM
Running a mysql server Stanford Scripting Help 4 29/03/2013 02:25 PM
Running a MySql Server 2hmed Scripting Help 0 02/09/2012 01:30 PM


All times are GMT. The time now is 05:34 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.