Hi,
ich habe meinen Gamemode von der MySQL R5 auf die R39-3 umgeschrieben.
Nun wenn ich den Server starte, und in die server_log.txt & die mysql_log.txt schaue sehe ich erschreckendes....
Hier mal die Logdateien:
Code
----------Loaded log file: "server_log.txt".----------SA-MP Dedicated Server----------------------v0.3.7, (C)2005-2015 SA-MP Team[15:47:07] filterscripts = "" (string)[15:47:07] [15:47:07] Server Plugins[15:47:07] --------------[15:47:07] Loading plugin: mysql.so[15:47:07] >> plugin.mysql: R39-3 successfully loaded.[15:47:07] Loaded.[15:47:07] Loading plugin: sscanf.so[15:47:07] [15:47:07] ===============================[15:47:07] sscanf plugin loaded. [15:47:07] Version: 2.8.1 [15:47:07] (c) 2012 Alex "Y_Less" Cole [15:47:07] ===============================[15:47:07] Loaded.[15:47:07] Loading plugin: audio.so[15:47:07] *** Audio Plugin v0.5 R2 by Incognito loaded ***[15:47:07] Loaded.[15:47:07] Loading plugin: streamer.so[15:47:07] *** Streamer Plugin v2.7.7 by Incognito loaded ***[15:47:07] Loaded.[15:47:07] Loading plugin: crashdetect.so[15:47:07] Loaded.[15:47:07] Loading plugin: nativechecker.so[15:47:07] Loaded.[15:47:07] Loaded 6 plugins.[15:47:07] [15:47:07] Filterscripts[15:47:07] ---------------[15:47:07] Loaded 0 filterscripts.[15:47:07] [crashdetect]: gamemodes/script.amx does not contain debug information[15:47:07] *** Audio Plugin: Started TCP server on port 22804[15:47:07] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt![15:47:07] Setting server password to: "shanfjdshfjsdhfjkdshfsd"[15:47:07] [crashdetect]: filterscripts/Maps.amx does not contain debug information[15:47:07] [15:47:07] Alle Maps wurden erfolgreich geladen![15:47:07] [15:47:07] Filterscript 'Maps.amx' loaded.[15:47:07] Filterscript 'AudioHide.amx' load failed.[15:47:07] [15:47:07] SCRIPT - (c) by Zinne[15:47:07] [15:47:07] Number of vehicle models: 0[15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:17] Server password has been removed.
Code
[15:47:07] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:47:07] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:47:07] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:47:07] [DEBUG] CMySQLConnection::Connect - connection was successful[15:47:07] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:47:07] [DEBUG] CMySQLConnection::Connect - connection was successful[15:47:07] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:47:07] [DEBUG] CMySQLConnection::Connect - connection was successful[15:47:07] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `haeuser`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `biz`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Frak`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Misc`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `jobinfo`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Jobcars`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Drugplants` WHERE `Harvested` = '0'", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `jobinfo` SET `EisenerzKG` = '0',`EisenerzSW` = '0', `Sta", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Cardealers`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Dealercars`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `accounts` (`ID` int(11) NOT NULL AUT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Logins` (`Name` varchar(24) NOT NULL", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Logouts` (`Name` varchar(24) NOT NUL", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Punishments` (`Name` varchar(24) NOT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Tickets` (`ID` int(11) NOT NULL AUTO", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `jobinfo` (`EisenerzKG` int(11) NOT N", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Jobcars` (`ID` int(11) NOT NULL AUTO", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Drugplants` (`ID` int(11) NOT NULL U", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `haeuser` (`ID` int(11) NOT NULL UNIQ", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Cardealers` (`ID` int(11) NOT NULL A", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Dealercars` (`ID` int(11) NOT NULL A", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Ordereddealercars` (`ID` int(11) NOT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Dealerparks` (`ID` int(11) NOT NULL ", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Playercars` (`ID` int(11) NOT NULL A", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Frakcars` (`ID` int(11) NOT NULL AUT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `biz` (`ID` int(11) NOT NULL,`PosX` f", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Misc` (`Spielerrekord` int(11) NOT N", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Frak` (`ID` int(11) NOT NULL UNIQUE,", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.381 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.192 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.743 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.71 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.72 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.735 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.720 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.749 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.743 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.652 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.653 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.670 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.442 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.923 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.600 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.707 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.689 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.724 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.584 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.516 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.561 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.624 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.587 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.607 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.593 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.712 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.753 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.479 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..
Nun lauten meine Hauptfragen:
Warum sagt die mysql_log, dass ich 3x eine Verbindung zur DB aufbaue?
Wie kann ich herausfinden, welche Querys leer (empty) sind?
lg
Deagle