MySQL 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 Problem (/showthread.php?tid=393088)
+- 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 Problem (/showthread.php?tid=393088)
MySQL Problem - sleejay - 17.11.2012
Код:
[04:26:10] [04:26:10] Filterscripts [04:26:10] --------------- [04:26:10] Loading filterscript 'gate.amx'... [04:26:10] Unable to load filterscript 'gate.amx'. [04:26:10] Loaded 0 filterscripts. [04:26:10] Error: Function not registered: 'samp_mysql_connect' [04:26:10] Error: Function not registered: 'samp_mysql_select_db' [04:26:10] Error: Function not registered: 'samp_mysql_ping' [04:26:10] Error: Function not registered: 'samp_mysql_close' [04:26:10] Error: Function not registered: 'samp_mysql_query' [04:26:10] Error: Function not registered: 'samp_mysql_store_result' [04:26:10] Error: Function not registered: 'samp_mysql_fetch_row' [04:26:10] Error: Function not registered: 'samp_mysql_free_result' [04:26:10] Error: Function not registered: 'samp_mysql_real_escape_string' [04:26:10] Error: Function not registered: 'samp_mysql_num_rows' [04:26:10] Script[gamemodes/berzerk.amx]: Run time error 19: "File or function is not found" [04:26:10] Number of vehicle models: 0
https://sampforum.blast.hk/showthread.php?tid=336776
I understand that I might have to update my MySQL files or something, and if that's the case - can someone send the files I need to change in the script? I'm having a lot of trouble here, been trying to get this to work for two whole days now. Please help me if you know what the problem is.
Re: MySQL Problem - sleejay - 17.11.2012
Anyone? I'm running a Linux server, via Color Host.
Re: MySQL Problem - sleejay - 17.11.2012
This is all I need to get my server up and running - doesn't anyone know how to fix this? I've tried everything, literally. I got Skype, and Teamviewer - if you need that to help me!
Re: MySQL Problem - InfiniTy. - 17.11.2012
Do you got the right version of MySQL ? Because there are 2-3 ( i think ) different plugins..
https://sampforum.blast.hk/showthread.php?tid=7106
Try that plugin
Re: MySQL Problem - sleejay - 17.11.2012
Okay, I am using my web host to have the database uploaded. I've put everything on there, including the MySQL user and pass, plus database name via Pawno.
Now, I get this error:
[20:04:28] MYSQL: Attempting to connect to server...
[20:04:28]
Connection to MySQL database: Failed !
[20:04:28] Access denied for user 'dj'@'184.171.165.221' (using password: YES)
[20:04:28] Error in mysql_select_db: MySQL server has gone away
[20:04:28] MYSQL: Connection error, retrying...
[20:04:28]
Connection to MySQL database: Failed !
[20:04:28] Access denied for user 'dj'@'184.171.165.221' (using password: YES)
[20:04:28] Error in mysql_select_db: MySQL server has gone away
[20:04:28] MYSQL: Could not reconnect to server, terminating server...
[20:04:28] Error in mysql_query: MySQL server has gone away
[20:04:28] Error in mysql_store_result: MySQL server has gone away[/code]
And yes Adytza, that plugin did move me up a step from my last problem. Thanks!
Re: MySQL Problem - InfiniTy. - 17.11.2012
Well seems like the password isn't correct..
(Did you allow your server ip to access the DB ? in your webhost cpanel ? )
Re: MySQL Problem - sleejay - 17.11.2012
Hmm, no I didn't. Could you tell me how I go about doing that?
Re: MySQL Problem - InfiniTy. - 17.11.2012
Do you have skype ? if yes then leave your username here
Re: MySQL Problem - sleejay - 17.11.2012
david.stricka
Re: MySQL Problem - sleejay - 17.11.2012
Adytza helped me get past all that, but now I am faced with this problem:
Код:
SA-MP Dedicated Server ---------------------- v0.3e, ©2005-2012 SA-MP Team [21:23:20] password = "" (string) [21:23:20] maxnpc = 0 (int) [21:23:20] [21:23:20] Server Plugins [21:23:20] -------------- [21:23:20] Loading plugin: streamer.so [21:23:20] *** Streamer Plugin v2.6 by Incognito loaded *** [21:23:20] Loaded. [21:23:20] Loading plugin: sampmysql.so [21:23:20] /*************************************************/ /* SAMP-MySQL v0.15 Plugin loaded successfully ! */ /*************************************************/ [21:23:20] Loaded. [21:23:20] Loading plugin: nativechecker.so [21:23:20] Loaded. [21:23:20] Loading plugin: mysql.so [21:23:20] Failed (plugins/mysql.so: invalid ELF header) [21:23:20] Loaded 3 plugins. [21:23:20] [21:23:20] Filterscripts [21:23:20] --------------- [21:23:20] Loading filterscript 'gate.amx'... [21:23:20] Unable to load filterscript 'gate.amx'. [21:23:20] Loaded 0 filterscripts. [21:23:20] MYSQL: Attempting to connect to server... [21:23:20] Connection to MySQL database: Successfull ! [21:23:20] Error in mysql_select_db: Access denied for user 'berzerkr_dj'@'184.171.165.221' to database 'berzerkr_berzerkroleplay' [21:23:20] MYSQL: Database connection established. [21:23:20] Error in mysql_query: No database selected [21:23:20] Error in mysql_store_result: No database selected
#define MYSQL_HOST "184.171.165.222"
#define MYSQL_USER "berzerkr_dj"
#define MYSQL_PASS "HIDDEN"
#define MYSQL_DB "berzerkr_berzerkroleplay"
That's exactly how it is supposed to be set up, as well. Now, what am I doing wrong?