Mysql Log - 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 Log (/showthread.php?tid=493653)
+- 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 Log (/showthread.php?tid=493653)
Mysql Log - gotwarzone - 09.02.2014
Can you please tell me how to fix this? I'm using the latest mysql R36.
My server is running centOS x32 bit.
Код:
[15:31:42] Error: Function not registered: 'mysql_function_query' [15:31:42] Error: Function not registered: 'mysql_debug' [15:31:42] Error: Function not registered: 'mysql_ping' [15:31:42] Error: Function not registered: 'mysql_real_escape_string' [15:31:42] Error: Function not registered: 'mysql_affected_rows' [15:31:42] Script[gamemodes/MCRP.amx]: Run time error 19: "File or function is not found" [15:31:42] Number of vehicle models: 0
Re: Mysql Log - Konstantinos - 09.02.2014
No, you're not. The plugin version is for R36 but the a_mysql.inc you've compiled MCRP is for R7. Update the include too, change the script since some function (those listed above) renamed/removed.
Re: Mysql Log - gotwarzone - 09.02.2014
When we Upload r36
Line
Re: Mysql Log - Konstantinos - 09.02.2014
Everything you're asking for is really easy to be found by searching. mysql_ping has been removed and it was (sort of) replaced by mysql_errno: http://forum.sa-mp.com/showpost.php?...postcount=4610
Re: Mysql Log - gotwarzone - 09.02.2014
Quote:
|
Originally Posted by Konstantinos
 Everything you're asking for is really easy to be found by searching. mysql_ping has been removed and it was (sort of) replaced by mysql_errno: http://forum.sa-mp.com/showpost.php?...postcount=4610
|
Quote:
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x, ©2005-2013 SA-MP Team [20:06:26] password = "" (string) [20:06:26] [20:06:26] Server Plugins [20:06:26] -------------- [20:06:26] Loading plugin: mysql.so [20:06:26] >> plugin.mysql: R36-2 successfully loaded. [20:06:26] Loaded. [20:06:26] Loading plugin: streamer.so [20:06:26] *** Streamer Plugin v2.6.1 by Incognito loaded *** [20:06:26] Loaded. [20:06:26] Loading plugin: sscanf.so [20:06:26] [20:06:26] =============================== [20:06:26] sscanf plugin loaded. [20:06:26] Version: 2.8.1 [20:06:26] © 2012 Alex "******" Cole [20:06:26] =============================== [20:06:26] Loaded. [20:06:26] Loading plugin: Whirlpool.so [20:06:26] [20:06:26] ================== [20:06:26] [20:06:26] Whirlpool loaded [20:06:26] [20:06:26] ================== [20:06:26] [20:06:26] Loaded. [20:06:26] Loading plugin: nativechecker.so [20:06:26] Loaded. [20:06:26] Loaded 5 plugins. [20:06:26] [20:06:26] Filterscripts [20:06:26] --------------- [20:06:26] Loading filterscript 'buttons.amx'... [20:06:26] Loading filterscript 'gcustom03e.amx'... [20:06:26] Loading filterscript 'vactions.amx'... [20:06:26] Loaded 3 filterscripts. [20:06:26] [20:06:26] ======================================= [20:06:26] | | [20:06:26] | YSI version 3.01.0002 | [20:06:26] | By Alex "******" Cole | [20:06:26] | | [20:06:26] ======================================= [20:06:26] [20:06:26] [MySQL] (Main Pipelines) Connecting to localhost... [20:06:26] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server! [20:06:26] [LoadHouses] Loading data from database... [20:06:26] [LoadDynamicDoors] Loading data from database... [20:06:26] [LoadDynamicMapIcons] Loading data from database... [20:06:26] [LoadDynamicTexts] Loading data from database... [20:06:26] [LoadTurfWars] 0 turfs loaded. [20:06:26] [LoadPaintballArenas] 10 paintball arenas loaded. [20:06:26] [LoadEventPoints] 0 event points loaded. [20:06:26] [LoadGates] 4000 gates loaded. [20:06:26] [LoadElevatorStuff] 20 floors loaded. [20:06:26] [LoadFamilies] 16 families loaded. [20:06:26] [LoadPoints] 9 points loaded. [20:06:28] [LoadCDealerships] 15 dealerships loaded. [20:06:28] [MiscLoad] Misc Loaded [20:06:28] [Tax] Government Tax/Vault Loaded. |
MYSQL_LOG
Quote:
|
[20:14:50] [DEBUG] mysql_connect - host: "(null)", user: "kevinbalordb", database: "kevinbalordb", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [20:14:50] [ERROR] mysql_connect - empty connection data specified [20:14:50] [DEBUG] mysql_errno - connection: 0 [20:14:50] [ERROR] "mysql_errno" - invalid connection handle (id: 0) [20:14:50] [DEBUG] mysql_tquery - connection: 0, query: "SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechP ay` FRO", callback: "OnQueryFinish", format: "iii" [20:14:50] [ERROR] "mysql_tquery" - invalid connection handle (id: 0) [20:14:50] [DEBUG] mysql_tquery - connection: 0, query: "UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 1", callback: "OnQueryFinish", format: "i" [20:14:50] [ERROR] "mysql_tquery" - invalid connection handle (id: 0) [20:14:50] [DEBUG] mysql_tquery - connection: 0, query: "SELECT * FROM `houses`", callback: "OnLoadHouses", format: "(null)" [20:14:50] [ERROR] "mysql_tquery" - invalid connection handle (id: 0) [20:14:50] [DEBUG] mysql_tquery - connection: 0, query: "SELECT * FROM `ddoors`", callback: "OnLoadDynamicDoors", format: "(null)" [20:14:50] [ERROR] "mysql_tquery" - invalid connection handle (id: 0) [20:14:50] [DEBUG] mysql_tquery - connection: 0, query: "SELECT * FROM `dmapicons`", callback: "OnLoadDynamicMapIcons", format: "(null)" [20:14:50] [ERROR] "mysql_tquery" - invalid connection handle (id: 0) [20:14:50] [DEBUG] mysql_tquery - connection: 0, query: "SELECT * FROM `dtexts`", callback: "OnLoadDynamicTexts", format: "(null)" [20:14:50] [ERROR] "mysql_tquery" - invalid connection handle (id: 0) |
Re: Mysql Log - Konstantinos - 09.02.2014
Why does your host parameter in mysql_connect was null? Replace with 127.0.0.1 for localhost or the IP of your server.
Re: Mysql Log - gotwarzone - 09.02.2014
Quote:
|
Originally Posted by Konstantinos
Why does your host parameter in mysql_connect was null? Replace with 127.0.0.1 for localhost or the IP of your server.
|
Now what I did is I revert it to R7 and now there is no log from mysql but in server log it show again this but more errors
Quote:
|
[20:36:31] Error: Function not registered: 'cache_get_data' [20:36:31] Error: Function not registered: 'cache_get_field_content' [20:36:31] Error: Function not registered: 'mysql_function_query' [20:36:31] Error: Function not registered: 'mysql_debug' [20:36:31] Error: Function not registered: 'mysql_connect' [20:36:31] Error: Function not registered: 'mysql_ping' [20:36:31] Error: Function not registered: 'mysql_close' [20:36:31] Error: Function not registered: 'mysql_real_escape_string' [20:36:31] Error: Function not registered: 'cache_get_row' [20:36:31] Error: Function not registered: 'mysql_affected_rows' [20:36:31] Script[gamemodes/MCRP.amx]: Run time error 19: "File or function is not found" [20:36:31] Number of vehicle models: 0 |
Also please your inbox kons.
Re: Mysql Log - gotwarzone - 09.02.2014
Can someone please tell me what is the problem below? Server log shows no problem. And this one is the mysql_log.
And server still apear to be offline. So I guess there is something wrong with this.
Quote:
|
[23:08:27] ** MySQL Debugging enabled (02/09/14) [23:08:27] [23:08:27] >> mysql_connect(127.0.0.1, sample1, sample2, ******) on port 3306 [23:08:27] CMySQLHandler::CMySQLHandler() - constructor called. [23:08:27] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "sample1db" | Username: "sample2db" [23:08:27] CMySQLHandler::Connect() - Connection was successful. [23:08:27] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [23:08:27] >> mysql_ping( Connection handle: 1 ) [23:08:27] CMySQLHandler::Ping() - Connection is still alive. [23:08:27] >> mysql_query_callback( Connection handle: 1 ) [23:08:27] >> mysql_query_callback( Connection handle: 1 ) [23:08:27] >> mysql_query_callback( Connection handle: 1 ) [23:08:27] >> mysql_query_callback( Connection handle: 1 ) [23:08:27] >> mysql_query_callback( Connection handle: 1 ) [23:08:27] >> mysql_query_callback( Connection handle: 1 ) [23:08:27] Passing query SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechP ay` FROM `misc` | iii [23:08:27] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechP ay` FROM `misc`) [23:08:27] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [23:08:27] CMySQLHandler::StoreResult() - Result was stored. [23:08:27] CMySQLHandler::FreeResult() - Result was successfully free'd. [23:08:27] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() |
Re: Mysql Log - gotwarzone - 10.02.2014
What could be the problem here? In windows it works perfectly but here in linux it does not.