• Datenbank Fehler & Kein Z Menü

      Guten Tag meine Damen und Herren,

      ERSTES PROBLEM:


      Ich habe momentan einen Arma 3 Altis Life Server Version 4.0, ich habe es geschafft das ich den Server zum laufen gebracht habe ich wollte gerade connecton. Ich war drin und wollte als Civ reingehen, alles fertig geladen,dann Stand da "Setting up Client, please wait" ,ich habe herausgefunden das wenn ich "Respawn" drücke und respawne kann ich da spawnen wo ich spawnen soll, ich möchte nicht das da "Setting Up Client, please wait " ich habe herausgefunden das es was mit der Datenbank zu tun hat.


      ZWEITES PROBLEM:

      Das ist kein Problem mit der Datenbank aber ich weiß nicht wo es hin soll, auf dem Altis Server haben wir kein Z Menü ich glaube jeder weiß wovon ich rede!


      Vielen Dank jetzt schon für die Antwort.

      Auch bei G-Portal gibt es Logs, die müssten dort im config-Ordner liegen meine ich

      Zitat von br1zey

      hier

      http://native-network.net/thread/3849…-client-server-[lexicon]extdb[/lexicon]-log/

      brauchen logs

      Ohne Logs nix los (siehe auch gerne meine Signatur)

      Guten Tag meine Damen und Herren,

      @blackfisch
      @br1zey

      Es erstellt nun Logs jedoch gibt es jetzt ein neues PRoblem nämlich folgendes:

      extDB2: Version: 71extDB2: https://github.com/Torndeco/extDB2extDB2: Windows VersionMessage: All development for extDB2 is done on a Linux Dedicated ServerMessage: If you would like to Donate to extDB2 DevelopmentMessage: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2Message: Also leave a message if there is any particular feature you would like to see added.Message: Thanks for all the people that have donated.Message: Torndeco: 20/02/15extDB2: Found [lexicon]extdb[/lexicon]-conf.iniextDB2: Detected 12 Cores, Setting up 6 Worker Threads[11:25:56:336016 +02:00] [Thread 6116] extDB2: Database Type: MySQL[11:25:56:346815 +02:00] [Thread 6116] extDB2: Database Session Pool Started[11:25:56:347021 +02:00] [Thread 6116] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True[11:27:44:809785 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'civ_stats' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:44:809816 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:45:422658 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'civ_stats' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:45:422680 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:45:686450 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'civ_stats' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:45:686475 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:45:926295 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'civ_stats' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:45:926325 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:46:223410 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'civ_stats' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:46:223436 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:46:522664 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'civ_stats' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'[11:27:46:522697 +02:00] [Thread 15948] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear, civ_stats FROM players WHERE playerid='76561198140510246'

      Bitte Logs als .txt speichern und anhängen oder [lexicon]extDB[/lexicon] Logs wenigstens in ein Code-Tag setzen.

      Zitat von Nexus

      Unknown column 'civ_stats' in 'field list'

      In deiner DB fehlt die Spalte civ_stats - sicher, dass du die richtige SQL ausgeführt hast? da haut was voll und ganz nicht hin. Führ mal den Code hier aus:


      SQL
      ALTER TABLE `players`
ADD COLUMN `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"' AFTER `med_gear`,
ADD COLUMN `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"' AFTER `cop_stats`, 
ADD COLUMN `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"' AFTER `cop_stats`;

      (einfach als .sql Datei speichern und in Navicat ausführen)

      Ich habe auch leider ein so ähniches problem hab hier mal die log Datein
      extDB2

      Spoiler anzeigen


      extDB2: Version: 71
      extDB2: https://github.com/Torndeco/extDB2
      extDB2: Windows Version
      Message: All development for extDB2 is done on a Linux Dedicated Server
      Message: If you would like to Donate to extDB2 Development
      Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
      Message: Also leave a message if there is any particular feature you would like to see added.
      Message: Thanks for all the people that have donated.
      Message: Torndeco: 20/02/15


      extDB2: Found [lexicon]extdb[/lexicon]-conf.ini
      extDB2: Detected 16 Cores, Setting up 6 Worker Threads


      [01:25:08:275272 +02:00] [Thread 756] extDB2: Database Type: MySQL
      [01:25:08:361278 +02:00] [Thread 756] extDB2: Database Session Pool Started
      [01:25:08:391523 +02:00] [Thread 756] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
      [01:25:37:284801 +02:00] [Thread 4648] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'playtime='"[0,0,0]"' WHERE playerid='76561198040552523'' at line 1 [mysql_stmt_errno]: 1064 [mysql_stmt_sqlstate]: 42000 [statemnt]: UPDATE players SET name='Avalon915', cash='0', bankacc='6500', adac_licenses='"[[`license_adac_adacAir`,0],[`license_adac_adacCar`,0]]"', adac_gear='"[`U_O_CombatUniform_ocamo`,`V_TacVest_khk`,`B_FieldPack_ocamo_Medic`,``,`H_HelmetO_ocamo`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemRadio`,`NVGoggles_OPFOR`],[],[],[`FirstAidKit`],[`30Rnd_65x39_caseless_green`,`30Rnd_65x39_caseless_green`,`Chemlight_red`],[`Medikit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`],[],[],[`30Rnd_65x39_caseless_green`,`30Rnd_65x39_caseless_green`,`30Rnd_65x39_caseless_green`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`SmokeShell`,`SmokeShellRed`,`SmokeShellOrange`,`SmokeShellYellow`,`Chemlight_red`,`30Rnd_65x39_caseless_green`,`16Rnd_9x21_Mag`],[``,`acc_pointer_IR`,``,``],[``,``,``,``],[]]"', adac_stats='"[100,100,0]"' playtime='"[0,0,0]"' WHERE playerid='76561198040552523'
      [01:25:37:285547 +02:00] [Thread 4648] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET name='Avalon915', cash='0', bankacc='6500', adac_licenses='"[[`license_adac_adacAir`,0],[`license_adac_adacCar`,0]]"', adac_gear='"[`U_O_CombatUniform_ocamo`,`V_TacVest_khk`,`B_FieldPack_ocamo_Medic`,``,`H_HelmetO_ocamo`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemRadio`,`NVGoggles_OPFOR`],[],[],[`FirstAidKit`],[`30Rnd_65x39_caseless_green`,`30Rnd_65x39_caseless_green`,`Chemlight_red`],[`Medikit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`],[],[],[`30Rnd_65x39_caseless_green`,`30Rnd_65x39_caseless_green`,`30Rnd_65x39_caseless_green`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`SmokeShell`,`SmokeShellRed`,`SmokeShellOrange`,`SmokeShellYellow`,`Chemlight_red`,`30Rnd_65x39_caseless_green`,`16Rnd_9x21_Mag`],[``,`acc_pointer_IR`,``,``],[``,``,``,``],[]]"', adac_stats='"[100,100,0]"' playtime='"[0,0,0]"' WHERE playerid='76561198040552523'
      [01:28:01:099753 +02:00] [Thread 4648] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'playtime='"[0,0,0]"' WHERE playerid='76561198040552523'' at line 1 [mysql_stmt_errno]: 1064 [mysql_stmt_sqlstate]: 42000 [statemnt]: UPDATE players SET name='Avalon915', cash='0', bankacc='6500', adac_licenses='"[[`license_adac_adacAir`,0],[`license_adac_adacCar`,0]]"', adac_gear='"[`U_B_HeliPilotCoveralls`,``,`B_Kitbag_cbr`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[],[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', adac_stats='"[100,100,0]"' playtime='"[0,0,0]"' WHERE playerid='76561198040552523'
      [01:28:01:100383 +02:00] [Thread 4648] extDB2: SQL_RAW_V2: Error StatementException: SQL: UPDATE players SET name='Avalon915', cash='0', bankacc='6500', adac_licenses='"[[`license_adac_adacAir`,0],[`license_adac_adacCar`,0]]"', adac_gear='"[`U_B_HeliPilotCoveralls`,``,`B_Kitbag_cbr`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[],[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', adac_stats='"[100,100,0]"' playtime='"[0,0,0]"' WHERE playerid='76561198040552523'
      [01:29:49:049280 +02:00] [Thread 2652] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Table 'ni336449_1_DB.messages' doesn't exist [mysql_stmt_errno]: 1146 [mysql_stmt_sqlstate]: 42S02 [statemnt]: SELECT fromID, toID, message, fromName, toName FROM messages WHERE toID='76561198040552523' ORDER BY time DESC
      [01:29:49:050055 +02:00] [Thread 2652] extDB2: SQL_RAW_V2: Error StatementException: SQL: SELECT fromID, toID, message, fromName, toName FROM messages WHERE toID='76561198040552523' ORDER BY time DESC

      Hab mich seit stunden damit auseinander gesetzt aber kann den fehler einfach nicht beheben.
      soweit ich das herauslesen kann ist in der DB die playtime schuld, in der init die _handle bei case east

      hoffe ihr könnt mir damit weiterhelfen