[vlat]

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.

And the server_log.txt

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.

[vlat]

Anyone... please I really need help

[GWMPT]

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

Kthxbye.

[sarab_singh]

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

[dr1ftp0w3r]

probably a typo.