help with mysql stuff - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: help with mysql stuff (/showthread.php?tid=139004)
+- 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: help with mysql stuff (/showthread.php?tid=139004)
help with mysql stuff - WardenCS - 03.04.2010
Hello,i have mysql script,its moderntopia edit,citywide or something,and i have prob with it,im trying to run the script in bought host,but it wont work,it will show unknown gamemode,its linux host,i have the plugins sampmysql written and stuff,anyone know the prob?
Re: help with mysql stuff - bauer123 - 03.04.2010
Do you acctualy have mysql on ur host?
Re: help with mysql stuff - WardenCS - 03.04.2010
Yeah,i have
Re: help with mysql stuff - woot - 03.04.2010
Check your server_log.txt if the plugins load.
Re: help with mysql stuff - WardenCS - 03.04.2010
with windows mysql plugin:
Код:
###################[ Beginning first 1000 lines from log ]############## [Sun Apr 4 00:51:06 2010] Launching server with the following commandline: # /home/gta090/.gameservers/samp_0/samp03svr +exec server.cfg ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3a R3, ©2005-2009 SA-MP Team [00:51:06] gamemode1 = "" (string) [00:51:06] gamemode2 = "" (string) [00:51:06] gamemode3 = "" (string) [00:51:06] filterscripts = "" (string) [00:51:06] [00:51:06] Server Plugins [00:51:06] -------------- [00:51:06] Loading plugin: sampmysql [00:51:06] Failed (plugins/sampmysql: cannot open shared object file: No such file or directory) [00:51:06] Loaded 0 plugins. [00:51:06] [00:51:06] Filter Scripts [00:51:06] --------------- [00:51:06] Loaded 0 filter scripts. [00:51:06] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found" [00:51:06] Number of vehicle models: 0 ###################[ End of log ]#########################
Код:
###################[ Beginning first 1000 lines from log ]############## [Sun Apr 4 00:52:04 2010] Launching server with the following commandline: # /home/gta090/.gameservers/samp_0/samp03svr +exec server.cfg ---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3a R3, ©2005-2009 SA-MP Team [00:52:04] gamemode1 = "" (string) [00:52:04] gamemode2 = "" (string) [00:52:04] gamemode3 = "" (string) [00:52:04] filterscripts = "" (string) [00:52:04] [00:52:04] Server Plugins [00:52:04] -------------- [00:52:04] Loading plugin: sampmysql.so [00:52:04] /*************************************************/ /* SAMP-MySQL v0.15 Plugin loaded successfully ! */ /*************************************************/ [00:52:04] Loaded. [00:52:04] Loaded 1 plugins. [00:52:04] [00:52:04] Filter Scripts [00:52:04] --------------- [00:52:04] Loaded 0 filter scripts. [00:52:04] MYSQL: Attempting to connect to server... [00:52:04] Connection to MySQL database: Failed ! [00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [00:52:04] Error in mysql_select_db: MySQL server has gone away [00:52:04] MYSQL: Connection error, retrying... [00:52:04] Connection to MySQL database: Failed ! [00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [00:52:04] Error in mysql_select_db: MySQL server has gone away [00:52:04] MYSQL: Could not reconnect to server, terminating server... [00:52:04] MYSQL: Connection seems dead, retrying... [00:52:04] MYSQL: Attempting to connect to server... [00:52:04] Connection to MySQL database: Failed ! [00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [00:52:04] Error in mysql_select_db: MySQL server has gone away [00:52:04] MYSQL: Connection error, retrying... [00:52:04] Connection to MySQL database: Failed ! [00:52:04] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [00:52:04] Error in mysql_select_db: MySQL server has gone away [00:52:04] MYSQL: Could not reconnect to server, terminating server... [00:52:04] MYSQL: Could not reconnect to server, terminating server... [00:52:04] Error in mysql_query: MySQL server has gone away [00:52:04] Error in mysql_store_result: MySQL server has gone away ###################[ End of log ]#########################
Re: help with mysql stuff - WardenCS - 04.04.2010
BUMP!
Re: help with mysql stuff - woot - 04.04.2010
You didn't even configure the script or setup the MySQL database, therefore you are unable to connect to it.
Re: help with mysql stuff - WardenCS - 04.04.2010
i did setup the mysql database,i added tables,and i changed the mysql host,db,pw etc in script,what more?
Re: help with mysql stuff - WardenCS - 05.04.2010
BUMP!
Re: help with mysql stuff - WardenCS - 05.04.2010
BUMP~!!!