MySQL Trouble! - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Trouble! (/showthread.php?tid=453894)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Trouble! (/showthread.php?tid=453894)
MySQL Trouble! - vlat - 26.07.2013
Ok I got trouble with MySQL.. I have all updated plugins/includes and compiled good
But when I connect to the server here what it writinn in mysql_log.txt
Quote:
|
[23:58:42] [23:58:42] --------------------------- [23:58:42] MySQL Debugging activated (07/26/13) [23:58:42] --------------------------- [23:58:42] [23:58:42] >> mysql_connect( ) [23:58:42] CMySQLHandler::CMySQLHandler() - constructor called. [23:58:42] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "myrp" | Username: "root" ... [23:58:42] CMySQLHandler::Connect() - Connection was successful. [23:58:42] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [23:58:42] >> mysql_ping( Connection handle: 1 ) [23:58:42] CMySQLHandler::Ping() - Connection is still alive. [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(SELECT Username from accounts WHERE Username = 'Vladimir_Mark') - An error has occured. (Error ID: 1146, Table 'ngrp.accounts' doesn't exist) [00:01:16] >> mysql_store_result( Connection handle: 1 ) [00:01:16] CMySQLHandler::StoreResult() - No data to store. [00:01:16] >> mysql_num_rows( Connection handle: 1 ) [00:01:16] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [00:01:16] >> mysql_free_result( Connection handle: 1 ) [00:01:16] CMySQLHandler::FreeResult() - The result is already empty. [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(SET SQL_SAFE_UPDATES=0  - Successfully executed.[00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] >> mysql_query( Connection handle: 1 ) [00:01:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:16] OnQueryError() - Called. [00:01:16] OnQueryError() - Called. [00:01:16] OnQueryError() - Called. [00:01:16] OnQueryError() - Called. [00:01:20] >> mysql_query( Connection handle: 1 ) [00:01:20] CMySQLHandler::Query(resultID) - Threaded query with id 3 started. (Extra ID: 0) [00:01:20] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:01:20] OnQueryError() - Called. [00:02:25] >> mysql_query( Connection handle: 1 ) [00:02:25] CMySQLHandler::Query(SET SQL_SAFE_UPDATES=0 - Successfully executed.[00:02:25] >> mysql_query( Connection handle: 1 ) [00:02:25] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0) [00:02:25] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError() [00:02:25] OnQueryError() - Called. |
Quote:
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x, ©2005-2013 SA-MP Team [23:58:42] [23:58:42] Server Plugins [23:58:42] -------------- [23:58:42] Loading plugin: sscanf [23:58:42] [23:58:42] =============================== [23:58:42] sscanf plugin loaded. [23:58:42] Version: 2.8.1 [23:58:42] © 2012 Alex "Y_Less" Cole [23:58:42] =============================== [23:58:42] Loaded. [23:58:42] Loading plugin: audio [23:58:42] *** Audio Plugin v0.5 R2 by Incognito loaded *** [23:58:42] Loaded. [23:58:42] Loading plugin: streamer [23:58:42] *** Streamer Plugin v2.6.1 by Incognito loaded *** [23:58:42] Loaded. [23:58:42] Loading plugin: mysql [23:58:42] > MySQL plugin R5 successfully loaded. [23:58:42] Loaded. [23:58:42] Loaded 4 plugins. [23:58:42] [23:58:42] Ban list [23:58:42] -------- [23:58:42] Loaded: samp.ban [23:58:42] [23:58:42] [23:58:42] Filterscripts [23:58:42] --------------- [23:58:42] Loading filterscript 'Buttons.amx'... [23:58:42] Loaded 1 filterscripts. [23:58:42] *** Audio Plugin: Started TCP server on port 7777 [23:58:42] [23:58:42] ======================================= [23:58:42] | | [23:58:42] | YSI version 1.03.0011 | [23:58:42] | By Alex "Y_Less" Cole | [23:58:42] | | [23:58:42] | Checking the latest YSI version.. | [23:58:42] | | [23:58:42] ======================================= [23:58:42] [23:58:42] onfoot_rate = 40 (int, read-only) [23:58:42] incar_rate = 40 (int, read-only) [23:58:42] weapon_rate = 40 (int, read-only) [23:58:42] *** Audio_SetPack: Error opening "audiopacks/default_pack/file.mp3" for CRC check [23:58:42] *** Audio_SetPack: Error opening "audiopacks/default_pack/file.ogg" for CRC check [23:58:42] *** Audio_SetPack: Error opening "audiopacks/default_pack/file.wav" for CRC check [23:58:42] *** Audio_SetPack: Audio pack set to "default_pack" (transferable and automated) [23:58:42] [MySQL] (All Pipelines) Connecting to MySQL Database Server localhost... [23:58:42] [MySQL] (MainPipeline) Connection successful toward MySQL Database Server! [23:58:55] [script] 3DTEXTDRAW LIMIT: 1024 (Static, non-streamed) | 3DTEXTDRAW COUNT: 1611 [23:58:55] [script] PICKUP LIMIT: 4096 (Static, non-streamed) | PICKUP COUNT: 1536 [23:58:55] [script] OBJECT LIMIT: 1000 (Static, non-streamed) | OBJECT COUNT: 6791 [23:58:55] [23:58:55] ------------------------------------------- [23:58:55] Loading... [23:58:55] Welcome to My Roleplay [23:58:55] ------------------------------------------- [23:58:55] [23:58:55] Number of vehicle models: 74 [23:58:55] [23:58:55] ========================================== [23:58:55] | | [23:58:55] | A new version (v3.09.0684) of YSI is | [23:58:55] | available from: | [23:58:55] | | [23:58:55] | www.y-less.com/YSI/YSI_1.0.zip | [23:58:55] | | [23:58:55] | Changelog: | [23:58:55] | | [23:58:55] | 1.04.0000: | [23:58:55] | | [23:58:55] | RC 1 for YSI 3.0. Available from: | [23:58:55] | http://www.y-less.com/YSI/YSI_3.0.rar | [23:58:55] | - includes MANY new libraries and | [23:58:55] | fixes, see | [23:58:55] | http://forum.sa-mp.com/showthread.php? | [23:58:55] | p=1425938 for more information, with | [23:58:55] | more topics and updates due over the | [23:58:55] | next few weeks. In brief: Added | [23:58:55] | "y_inline", "y_text", "y_users", | [23:58:55] | "y_uvar", "y_svar", "y_remote"; | [23:58:55] | updated "y_timers", "y_iter"; MANY | [23:58:55] | MANY fixes and tweaks in almost every | [23:58:55] | other library. | [23:58:55] | | [23:58:55] | 3.00.0000: | [23:58:55] | | [23:58:55] | YSI 3.0 released! Now includes the | [23:58:55] | "y_text" library for better messages, | [23:58:55] | and a reworked "y_classes" library. | [23:58:55] | Largely documented here | [23:58:55] | "http://forum.sa-mp.com/showthread.php | [23:58:55] | ?t=321092". | [23:58:55] | | [23:58:55] | 3.01.0002: | [23:58:55] | | [23:58:55] | Small fixes to "y_text" and | [23:58:55] | "y_classes". | [23:58:55] | | [23:58:55] | 3.09.0684: | [23:58:55] | | [23:58:55] | Reverted to old download location. | [23:58:55] | Improved (and fixed) version checks; | [23:58:55] | added y_bitmap, y_areas, y_races, | [23:58:55] | y_zonenames, better documentation; | [23:58:55] | MANY other bug fixes - see the github | [23:58:55] | repository for more details: | [23:58:55] | | [23:58:55] ========================================== [23:58:55] [00:01:16] Incoming connection: 127.0.0.1:65445 [00:01:16] [join] Vladimir_Mark has joined the server (0:127.0.0.1) [00:01:16] [MySQL] Converting Vladimir_Mark's Profile from File to MySQL Database. [00:01:16] [MySQL] Vladimir_Mark's Profile Conversion has been completed! [00:01:16] [MySQL] Query Error - (Thread: -1) (ExtraID: -1) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:16] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:01:16] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:01:20] [MySQL] Query Error - (Thread: 3) (ExtraID: 0) (ErrorID: 1146) [00:01:20] [MySQL] Check /logs/querydump.log to review the query that threw the error. [00:02:14] [zcmd] [Vladimir Mark]: /login [00:02:25] Unloading Vladimir_Mark's vehicles. [00:02:25] [part] Vladimir_Mark has left the server (0:1) [00:02:25] [MySQL] Query Error - (Thread: 2) (ExtraID: 0) (ErrorID: 1146) [00:02:25] [MySQL] Check /logs/querydump.log to review the query that threw the error. |
Re: MySQL Trouble! - vlat - 27.07.2013
Anyone... please I really need help
Re: MySQL Trouble! - GWMPT - 27.07.2013
Now i am thinking to my self, why the hell don't you read the freaking mysql log?
It have everything WRITTEN THERE.
Code:
[00:01:16] CMySQLHandler::Query(SELECT Username from accounts WHERE Username = 'Vladimir_Mark') - An error has occured. (Error ID: 1146, Table 'ngrp.accounts' doesn't exist
Re: MySQL Trouble! - sarab_singh - 01.08.2013
Check all tables are created and in script you used correct table names
In pawn compilation it will not show mysql errors so be careful to use correct names
Re: MySQL Trouble! - dr1ftp0w3r - 01.08.2013
probably a typo.