[gotwarzone]

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

[Konstantinos]

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.

[gotwarzone]

When we Upload r36
Line

[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

[gotwarzone]

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

Kons, everything seems fine now in server_log. But the mysql_log there is something wrong. please check the quote below the serve_log

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)

[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.

[gotwarzone]

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.

I tried changing locahost to = 127.0.0.1 and my server ip as well but still it shows null

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

I've already changed the a_mysql.inc to R7 and still show the above errors.
Also please your inbox kons.

[gotwarzone]

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()

[gotwarzone]

What could be the problem here? In windows it works perfectly but here in linux it does not.