Problem mit MySQL R39-3

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • 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


    Jeffry:

  • Warum sagt die mysql_log, dass ich 3x eine Verbindung zur DB aufbaue?


    Möglicherweise steht das mysql_connect in einer Schleife? Oder ist in mehreren Filterscripts geladen?


    Wie kann ich herausfinden, welche Querys leer (empty) sind?


    Irgendwo nach

    SQL
    "CREATE TABLE IF NOT EXISTS `Frak` (`ID` int(11) NOT NULL UNIQUE...


    werden die sein. dort musst du nachschauen.


  • Möglicherweise steht das mysql_connect in einer Schleife? Oder ist in mehreren Filterscripts geladen?



    Irgendwo nach

    SQL
    "CREATE TABLE IF NOT EXISTS `Frak` (`ID` int(11) NOT NULL UNIQUE...


    werden die sein. dort musst du nachschauen.


    Mein mysql_connect:
    public OnGameModeInit()
    {
    Connect_To_Database();
    //... Das andere OnGameModeInit Zeug
    return 1;
    }


    stock Connect_To_Database()
    {
    dbHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_errno() == 0) {
    print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
    mysql_log(LOG_ALL);
    return 1;
    } else {
    print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
    print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
    dbHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_errno() == 0) {
    print("<-| [MYSQL] Beim 2. Versuch konnte eine Verbindung zur Datenbank hergestellt werden!");
    mysql_log(LOG_ALL);
    return 1;
    } else {
    print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
    print("<-| [MYSQL] Der Server wird nun heruntergefahren!");
    SendRconCommand("exit");
    return 0;
    }
    }
    }
    Ich sehe da keine Schleife..



    Hier der Frak-Code:
    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `Frak` (\
    `ID` int(11) NOT NULL UNIQUE,\
    `Kasse` int(11) NOT NULL,\
    `Marihuana` int(11) NOT NULL,\
    `Mats` int(11) NOT NULL,\
    `Gangwaffen` int(11) NOT NULL,\
    `Rank1lohn` int(11) NOT NULL,\
    `Rank2lohn` int(11) NOT NULL,\
    `Rank3lohn` int(11) NOT NULL,\
    `Rank4lohn` int(11) NOT NULL,\
    `Rank5lohn` int(11) NOT NULL,\
    `Rank6lohn` int(11) NOT NULL,\
    `Rank7lohn` int(11) NOT NULL,\
    `Rank8lohn` int(11) NOT NULL,\
    `LagerOpen` int(1) NOT NULL,");
    strcat(query,q);
    format(q,sizeof q,"`Rank1name` varchar(16) NOT NULL,\
    `Rank2name` varchar(16) NOT NULL,\
    `Rank3name` varchar(16) NOT NULL,\
    `Rank4name` varchar(16) NOT NULL,\
    `Rank5name` varchar(16) NOT NULL,\
    `Rank6name` varchar(16) NOT NULL,\
    `Rank7name` varchar(16) NOT NULL,\
    `Rank8name` varchar(16) NOT NULL,\
    `Rank1skin` int(3) NOT NULL,\
    `Rank2skin` int(3) NOT NULL,\
    `Rank3skin` int(3) NOT NULL,\
    `Rank4skin` int(3) NOT NULL,\
    `Rank5skin` int(3) NOT NULL,\
    `Rank6skin` int(3) NOT NULL,");
    strcat(query,q);
    format(q,sizeof q,"`Rank7skin` int(3) NOT NULL,\
    `Rank8skin` int(3) NOT NULL,\
    `WLX` float NOT NULL,\
    `WLY` float NOT NULL,\
    `WLZ` float NOT NULL,\
    `PosX` float NOT NULL,\
    `PosY` float NOT NULL,\
    `PosZ` float NOT NULL,\
    `IntX` float NOT NULL,\
    `IntY` float NOT NULL,\
    `IntZ` float NOT NULL,\
    `WLiX` float NOT NULL,\
    `WLiY` float NOT NULL,\
    `WLiZ` float NOT NULL,\
    `Interior` int(11) NOT NULL,\
    `VW` int(11) NOT NULL,");
    strcat(query,q);
    format(q,sizeof q,"`SpawnX` float NOT NULL,\
    `SpawnY` float NOT NULL,\
    `SpawnZ` float NOT NULL,\
    `SpawnA` float NOT NULL,\
    `Kokain` int(11) NOT NULL,\
    `Carslots` int(11) NOT NULL);");
    strcat(query,q);
    mysql_pquery(dbHandle,query);
    Das steht halt alles in einem Stock, damit alle Tabellen erstellt werden.


    /edit: Kann es sein, dass der Server/das Mysql Plugin nicht damit klar kommt, dass die Querys so schnell hintereinander ausgeführt werden?

  • Zwecks den mehreren Verbindungen: Vom Code her siehst das normal aus, daran scheint es nicht zu liegen. Ein direktes Problem ist das aber auch nicht, solange es funktioniert.
    Wenn du dir sicher bist, dass du nirgends die Verbindung nochmal herstellst, dann kannst du das auch so lassen.


    Zu den leeren Queries:
    Nicht der Code, der danach. ;)

  • Nicht der Code, der danach.


    Spoiler anzeigen
    format(q,sizeof q,"");
    format(query,sizeof query,"");

    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `247prices` (\
    `ID` int(11) NOT NULL AUTO_INCREMENT,\
    `Handy` int(11) NOT NULL,\
    `Telefonbuch` int(11) NOT NULL,\
    `Benzinkanister` int(11) NOT NULL,\
    `BizID` int(11) NOT NULL,\
    PRIMARY KEY(`ID`));");
    mysql_pquery(dbHandle,query);
    format(q,sizeof q,"");

    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `BSprices` (\
    `ID` int(11) NOT NULL AUTO_INCREMENT,\
    `KleinBurger` int(11) NOT NULL,\
    `KleinBurgerGetr` int(11) NOT NULL,\
    `GrossBurger` int(11) NOT NULL,\
    `GrossBurgerGetr` int(11) NOT NULL,\
    `KleinGetr` int(11) NOT NULL,\
    `GrossGetr` int(11) NOT NULL,\
    `BizID` int(11) NOT NULL,\
    PRIMARY KEY(`ID`));");
    mysql_pquery(dbHandle,query);
    format(q,sizeof q,"");

    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `CBprices` (\
    `ID` int(11) NOT NULL AUTO_INCREMENT,\
    `KleinChicken` int(11) NOT NULL,\
    `KleinChickenGetr` int(11) NOT NULL,\
    `GrossChicken` int(11) NOT NULL,\
    `GrossChickenGetr` int(11) NOT NULL,\
    `KleinGetr` int(11) NOT NULL,\
    `GrossGetr` int(11) NOT NULL,\
    `BizID` int(11) NOT NULL,\
    PRIMARY KEY(`ID`));");
    mysql_pquery(dbHandle,query);
    format(q,sizeof q,"");

    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `PSprices` (\
    `ID` int(11) NOT NULL AUTO_INCREMENT,\
    `KleinPizza` int(11) NOT NULL,\
    `KleinPizzaGetr` int(11) NOT NULL,\
    `GrossPizza` int(11) NOT NULL,\
    `GrossPizzaGetr` int(11) NOT NULL,\
    `KleinGetr` int(11) NOT NULL,\
    `GrossGetr` int(11) NOT NULL,\
    `Salat` int(11) NOT NULL,\
    `BizID` int(11) NOT NULL,\
    PRIMARY KEY(`ID`));");
    mysql_pquery(dbHandle,query);
    format(q,sizeof q,"");

    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `RBDprices` (\
    `ID` int(11) NOT NULL AUTO_INCREMENT,\
    `KleinDonut` int(11) NOT NULL,\
    `KleinDonutGetr` int(11) NOT NULL,\
    `GrossDonut` int(11) NOT NULL,\
    `GrossDonutGetr` int(11) NOT NULL,\
    `KleinGetr` int(11) NOT NULL,\
    `GrossGetr` int(11) NOT NULL,\
    `BizID` int(11) NOT NULL,\
    PRIMARY KEY(`ID`));");
    mysql_pquery(dbHandle,query);
    format(q,sizeof q,"");

    format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `AMMUprices` (\
    `ID` int(11) NOT NULL AUTO_INCREMENT,\
    `Armor` int(11) NOT NULL,\
    `BrassKn` int(11) NOT NULL,\
    `Knife` int(11) NOT NULL,\
    `Baseball` int(11) NOT NULL,\
    `Colt45` int(11) NOT NULL,\
    `Silenced` int(11) NOT NULL,\
    `Deagle` int(11) NOT NULL,\
    `Shotgun` int(11) NOT NULL,\
    `MP5` int(11) NOT NULL,\
    `AK47` int(11) NOT NULL,\
    `M4A1` int(11) NOT NULL,\
    `Country` int(11) NOT NULL,\
    `Sniper` int(11) NOT NULL,\
    `BizID` int(11) NOT NULL,\
    PRIMARY KEY(`ID`));");
    mysql_pquery(dbHandle,query);
    format(q,sizeof q,"");
    return 1;


    /e: Warte mal wie bekloppt bin ich eigentlich?
    Ich formatiere "q", aber führe "query" aus.....

  • mysql_pquery(dbHandle,query);
    zu:
    mysql_pquery(dbHandle,q);


    Dann dürfte es klappen.


    EDIT: Ich sehe grade, das war in dem Code oben auch schon so, hab ich gar nicht gesehen.


    EDIT2:

    Zitat

    /e: Warte mal wie bekloppt bin ich eigentlich?
    Ich formatiere "q", aber führe "query" aus.....


    Passiert :D