Small Problem <----Please Read - 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: Small Problem <----Please Read (
/showthread.php?tid=475506)
Small Problem <----Please Read -
Joe_Goro - 13.11.2013
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 ?
Код:
----------
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)
Mysql Log
Код:
[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.
Here is InGame Freeze Here
Re: Small Problem <----Please Read -
Konstantinos - 13.11.2013
Change the details about the mysql connect inside the script to the one (host?) uses.
Re: Small Problem <----Please Read -
Joe_Goro - 13.11.2013
script gets his mysql info from mysql.ini
you can see its says succsful to connect .. but down says root@local host ??! why??!
also why its says erorr down
logs/dumpmysql.log
and i cant find that file?
Re: Small Problem <----Please Read -
Joe_Goro - 13.11.2013
in mysql ini
i give it right info .. so its says succesful
iwanna know why is that erorr down..icant register/login
Re: Small Problem <----Please Read -
Joe_Goro - 13.11.2013
any help guys?