• mysql_stmt_error in EXtDB 2

      Moin Moin Liebe NN Gemeinde.
      Nachdem Ich Die Opfor fraktion Eingefügt habe bekommen ich den mysql_stmt_error in meinen MYSQL Logs.

      Ich bin nach diesem TUT gegangen

      Zudem wird mir der Personalausweis zugespammt mit folgendem Inhalt

      Spoiler anzeigen

      INSERT INTO `perso` VALUES ('319', '76561198022154558', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '2017-01-31 13:15:20', '2017-01-31 13:15:20');

      Nach Langem Hin und her habe ich mich nun entschieden hier mal zu Fragen.

      Hier meine [lexicon]extdb[/lexicon] Logs

      Spoiler anzeigen

      [13:13:07:753107 +02:00] [Thread 348] extDB2: Database Type: MySQL
      [13:13:07:755127 +02:00] [Thread 348] extDB2: Database Session Pool Started
      [13:13:07:755303 +02:00] [Thread 348] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
      [13:15:20:589684 +02:00] [Thread 8168] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'playerid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
      [13:15:20:589733 +02:00] [Thread 8168] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
      [13:15:20:830285 +02:00] [Thread 11412] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'playerid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
      [13:15:20:830316 +02:00] [Thread 11412] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
      [13:15:21:357313 +02:00] [Thread 8168] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'playerid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
      [13:15:21:357355 +02:00] [Thread 8168] extDB2: SQL_RAW_V2: Error StatementException: SQL: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')
      [13:15:21:884280 +02:00] [Thread 11412] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'playerid' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('76561198022154558', 'Fidel Castro', '0', '3000', '"[`Fidel Castro`]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"','"[]"')

      In den ganz normaln RPTs steht nix drinne.

      na bevor Fragen aufkommen hier mal die Antwort :thumbup:


      /Functions/MYSQL/fn_insertRequest.sqf im life_server

      Code
      //Prepare the query statement..
_query = format["INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses) VALUES('%1', '%2', '%3', '%4', '%5','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""')",

      /Functions/MYSQL/fn_queryRequest.sqf auch life_server

      C
      // East - 10 entries returned
 case east: {format["SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, adac_licenses, adaclevel, adac_gear, adac_stats, playtime FROM players WHERE pid='%1'",_uid];};


      Eventuell musste auch noch in den anderen Dateien prüfen ob sich dort auch noch was mit playerid versteckt. Achja auch wenn es sich um TuT handelt sollte man trotzdem schauen was man per Copy & Paste in die Dateien reinhaut und ob das zum Rest passt
      dash