13.11.2013, 15:40
hello i got a problem with mysql i think >> here is the log when i try to register new account
Server Log Note : Root isnt my mysql user why its says root@localhost ?
Mysql Log
Here is InGame Freeze Here
Server Log Note : Root isnt my mysql user why its says root@localhost ?
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x-R2, ©2005-2013 SA-MP Team [11:27:14] password = "" (string) [11:27:14] [11:27:14] Server Plugins [11:27:14] -------------- [11:27:14] Loading plugin: crashdetect.so [11:27:14] CrashDetect v4.12 is OK. [11:27:14] Loaded. [11:27:14] Loading plugin: mysql.so [11:27:14] > MySQL plugin R7 successfully loaded. [11:27:14] Loaded. [11:27:14] Loading plugin: streamer.so [11:27:14] *** Streamer Plugin v2.6.1 by Incognito loaded *** [11:27:14] Loaded. [11:27:14] Loading plugin: sscanf.so [11:27:14] [11:27:14] =============================== [11:27:14] sscanf plugin loaded. [11:27:14] Version: 2.8.1 [11:27:14] © 2012 Alex "******" Cole [11:27:14] =============================== [11:27:14] Loaded. [11:27:14] Loading plugin: Whirlpool.so [11:27:14] [11:27:14] ================== [11:27:14] [11:27:14] Whirlpool loaded [11:27:14] [11:27:14] ================== [11:27:14] [11:27:14] Loaded. [11:27:14] Loaded 5 plugins. [11:27:14] [11:27:14] Filterscripts [11:27:14] --------------- [11:27:14] Loading filterscript 'yom_buttons.amx'... [11:27:14] Unable to load filterscript 'yom_buttons.amx'. [11:27:14] Loading filterscript 'gcustom03e.amx'... [11:27:15] Loading filterscript 'vacation.amx'... [11:27:15] Unable to load filterscript 'vacation.amx'. [11:27:15] Loaded 1 filterscripts. [11:27:16] [11:27:16] ======================================= [11:27:16] | | [11:27:16] | YSI version 3.01.0002 | [11:27:16] | By Alex "******" Cole | [11:27:16] | | [11:27:16] ======================================= [11:27:16] [11:27:16] [MySQL] (Main Pipelines) Connecting to localhost... [11:27:16] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server! [11:27:16] [LoadHouses] Loading data from database... [11:27:16] [LoadDynamicDoors] Loading data from database... [11:27:16] [LoadDynamicMapIcons] Loading data from database... [11:27:16] [LoadDynamicTexts] Loading data from database... [11:27:17] [LoadTurfWars] 40 turfs loaded. [11:27:17] [LoadPaintballArenas] 10 paintball arenas loaded. [11:27:17] [LoadEventPoints] 0 event points loaded. [11:27:17] [LoadGates] 4000 gates loaded. [11:27:17] [LoadElevatorStuff] 20 floors loaded. [11:27:17] [LoadFamilies] 16 families loaded. [11:27:17] [LoadPoints] 9 points loaded. [11:27:27] [LoadCDealerships] 15 dealerships loaded. [11:27:27] [MiscLoad] Misc Loaded [11:27:27] [Tax] Government Tax/Vault Loaded. [11:27:56] The server has fully loaded. [11:27:56] Number of vehicle models: 111 [11:27:56] [11:27:56] ========================================== [11:27:56] | | [11:27:56] | A new version (v3.09.0684) of YSI is | [11:27:56] | available from: | [11:27:56] | | [11:27:56] | www.y-less.com/YSI/YSI_1.0.zip | [11:27:56] | | [11:27:56] | Changelog: | [11:27:56] | | [11:27:56] | 3.09.0684: | [11:27:56] | | [11:27:56] | Reverted to old download location. | [11:27:56] | Improved (and fixed) version checks; | [11:27:56] | added y_bitmap, y_areas, y_races, | [11:27:56] | y_zonenames, better documentation; | [11:27:56] | MANY other bug fixes - see the github | [11:27:56] | repository for more details: | [11:27:56] | | [11:27:56] ========================================== [11:27:56] [11:27:56] [MySQL] Query Error - (ErrorID: 1449) (Handle: 1) [11:27:56] [MySQL] Check /logs/querydump.log to review the query that threw the error. [11:27:56] Dumping query from 2013/11/13 (11:27:56) Description: The user specified as a definer ('root'@'localhost') does not exist (index 0). Query: [11:27:56] UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 1 [11:27:56] [LoadHouses] Failed to load any houses. [11:27:57] [LoadDynamicDoors] 2000 doors rehashed/loaded. [11:27:57] [LoadDynamicMapIcons] 400 map icons rehashed/loaded. [11:27:57] [LoadDynamicTexts] 2000 Texts Labels rehashed/loaded. [11:30:25] Incoming connection: ****************** [11:30:25] [join] Some_One has joined the server (0:************) [11:30:36] [MySQL] Query Error - (ErrorID: 1449) (Handle: 1) [11:30:36] [MySQL] Check /logs/querydump.log to review the query that threw the error. [11:30:36] Dumping query from 2013/11/13 (11:30:36) Description: The user specified as a definer ('root'@'localhost') does not exist (index 0). Query: [11:30:36] INSERT INTO `accounts` (`Username`, `Pass`) VALUES ('Some_One','B36734E7BB6DF44D10C8B458B1A58CECED5236B9D2DEFBABA33B8290F28CFD9170A1EAD586AC8FACCFDAFA605AE54507CB42096EA2B8A604FABD892ABF1C1A63') [11:30:48] [part] Some_One has left the server (0:1)
Код:
[11:27:16]
[11:27:16] ** MySQL Debugging enabled (11/13/13)
[11:27:16]
[11:27:16] >> mysql_connect(localhost, DB, DB, ******) on port 5503
[11:27:16] CMySQLHandler::CMySQLHandler() - constructor called.
[11:27:16] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "BD" | Username: "DB"
[11:27:16] CMySQLHandler::Connect() - Connection was successful.
[11:27:16] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[11:27:16] >> mysql_ping( Connection handle: 1 )
[11:27:16] CMySQLHandler::Ping() - Connection is still alive.
[11:27:16] >> mysql_query_callback( Connection handle: 1 )
[11:27:16] >> mysql_query_callback( Connection handle: 1 )
[11:27:16] >> mysql_query_callback( Connection handle: 1 )
[11:27:16] >> mysql_query_callback( Connection handle: 1 )
[11:27:16] >> mysql_query_callback( Connection handle: 1 )
[11:27:16] >> mysql_query_callback( Connection handle: 1 )
[11:27:16] Passing query SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay` FROM `misc` | iii
[11:27:16] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay` FROM `misc`)
[11:27:16] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[11:27:16] CMySQLHandler::StoreResult() - Result was stored.
[11:27:16] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:27:16] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:27:56] OnQueryFinish(iii) - Threaded function called.
[11:27:56] >> cache_get_data( Connection handle: 1 )
[11:27:56] ProcessTick() - The cache has been cleared.
[11:27:56] Passing query UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 1 | i
[11:27:56] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[11:27:56] OnQueryError() - Called.
[11:27:56] Passing query SELECT * FROM `houses` |
[11:27:56] ProcessQueryThread(OnLoadHouses) - Query was successful. (SELECT * FROM `houses`)
[11:27:56] ProcessQueryThread(OnLoadHouses) - Data caching enabled.
[11:27:56] CMySQLHandler::StoreResult() - Result was stored.
[11:27:56] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:27:56] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:27:56] OnLoadHouses() - Threaded function called.
[11:27:56] >> cache_get_data( Connection handle: 1 )
[11:27:56] ProcessTick() - The cache has been cleared.
[11:27:56] Passing query SELECT * FROM `ddoors` |
[11:27:56] ProcessQueryThread(OnLoadDynamicDoors) - Query was successful. (SELECT * FROM `ddoors`)
[11:27:56] ProcessQueryThread(OnLoadDynamicDoors) - Data caching enabled.
[11:27:56] CMySQLHandler::StoreResult() - Result was stored.
[11:27:56] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:27:56] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:27:56] OnLoadDynamicDoors() - Threaded function called.
[11:27:56] >> cache_get_data( Connection handle: 1 )
[11:27:57] ProcessTick() - The cache has been cleared.
[11:27:57] Passing query SELECT * FROM `dmapicons` |
[11:27:57] ProcessQueryThread(OnLoadDynamicMapIcons) - Query was successful. (SELECT * FROM `dmapicons`)
[11:27:57] ProcessQueryThread(OnLoadDynamicMapIcons) - Data caching enabled.
[11:27:57] CMySQLHandler::StoreResult() - Result was stored.
[11:27:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:27:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:27:57] OnLoadDynamicMapIcons() - Threaded function called.
[11:27:57] >> cache_get_data( Connection handle: 1 )
[11:27:57] ProcessTick() - The cache has been cleared.
[11:27:57] Passing query SELECT * FROM `dtexts` |
[11:27:57] ProcessQueryThread(OnLoadDynamicTexts) - Query was successful. (SELECT * FROM `dtexts`)
[11:27:57] ProcessQueryThread(OnLoadDynamicTexts) - Data caching enabled.
[11:27:57] CMySQLHandler::StoreResult() - Result was stored.
[11:27:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:27:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:27:57] OnLoadDynamicTexts() - Threaded function called.
[11:27:57] >> cache_get_data( Connection handle: 1 )
[11:27:57] ProcessTick() - The cache has been cleared.
[11:30:25] >> mysql_query_callback( Connection handle: 1 )
[11:30:25] Passing query SELECT `Username` FROM `accounts` WHERE `Username` = 'Some_One' | iii
[11:30:25] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `Username` FROM `accounts` WHERE `Username` = 'Some_One')
[11:30:25] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[11:30:25] CMySQLHandler::StoreResult() - Result was stored.
[11:30:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:30:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:30:25] OnQueryFinish(iii) - Threaded function called.
[11:30:25] >> cache_get_data( Connection handle: 1 )
[11:30:25] ProcessTick() - The cache has been cleared.
[11:30:36] >> mysql_query_callback( Connection handle: 1 )
[11:30:36] >> mysql_query_callback( Connection handle: 1 )
[11:30:36] Passing query INSERT INTO `accounts` (`Username`, `Pass`) VALUES ('Some_One','B36734E7BB6DF44D10C8B458B1A58CECED5236B9D2DEFBABA33B8290F28CFD9170A1EAD586AC8FACCFDAFA605AE54507CB42096EA2B8A604FABD892ABF1C1A63') | ii
[11:30:36] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[11:30:36] OnQueryError() - Called.
[11:30:36] Passing query SELECT `Username`,`Pass`,`Email` from accounts WHERE Username = 'Some_One' | iii
[11:30:36] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `Username`,`Pass`,`Email` from accounts WHERE Username = 'Some_One')
[11:30:36] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[11:30:36] CMySQLHandler::StoreResult() - Result was stored.
[11:30:36] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:30:36] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:30:36] OnQueryFinish(iii) - Threaded function called.
[11:30:36] >> cache_get_data( Connection handle: 1 )
[11:30:36] >> mysql_query_callback( Connection handle: 1 )
[11:30:36] ProcessTick() - The cache has been cleared.
[11:30:36] Passing query SELECT * FROM `accounts` WHERE `Username` = 'Some_One' | iii
[11:30:36] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM `accounts` WHERE `Username` = 'Some_One')
[11:30:36] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[11:30:36] CMySQLHandler::StoreResult() - Result was stored.
[11:30:36] CMySQLHandler::FreeResult() - Result was successfully free'd.
[11:30:36] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[11:30:36] OnQueryFinish(iii) - Threaded function called.
[11:30:36] >> cache_get_data( Connection handle: 1 )
[11:30:36] ProcessTick() - The cache has been cleared.
