• Datenbank Fehler

      Hey Leute,

      in den Logs von extb 3 kommt folgender Fehler:

      Code
      [23:52:14:976491 +01:00] [Thread 1156] extDB3: SQL: Error MariaDBQueryException: 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 ''"[`U_Rangemaster`,`S_VHO_OV_COP_6`,`B_Carryall_oli`,`G_Aviator`,`H_Cap_headphon' at line 1
[23:52:14:976580 +01:00] [Thread 1156] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE players SET cop_gear='"[`U_Rangemaster`,`S_VHO_OV_COP_6`,`B_Carryall_oli`,`G_Aviator`,`H_Cap_headphones`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_rf7800str_21`],``,``,[`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`],[`hlc_30rnd_556x45_S`],[`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`,`ACE_packingBandage`],[`hlc_30rnd_556x45_S`],[`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,

      Kann mir einer sagen wie man den Fehler beheben kann?

      Wenn der Fehler kommt dann funktioniert nix mehr.

      Ist ganz Einfach in der Life_Server werden die DB Statements mit format  zusammengesetzt ^^ und es sieht ganz danach aus das du da die Zeichen Begrenzung Erreicht hast

      Im Wiki steht

      Killzone_Kid: In Arma 3 the max length of String returned by format command seems to be 8191 characters. formatText doesn't seem to have this limitation.

      Killzone Kid: In addition to the note above, you may consider using joinString instead of format or formatText workaround. joinString is a fraction faster than format and it has no limit on the length of the string (apart from global String limit obviously)

      Kurz und Knapp alles was mit DB zu tun hat und format nutzt ändern zu joinString

      Der Fehler tritt grade dan auf wenn man ACE Nutz da man Meist viele BAndagen wie bei dir im INV hat ^^

      ReallifeRPG Admin, Scripter, Technischer Helfer, und Manchmal auch Spieler

      realliferpg128x128.png?resize=128%2C128&ssl=1

      Also so als Beispiel ?:

      Code
      //fn_updateRequest.sqf
switch (_side) do {
    case west: {_query = joinString ["UPDATE players SET name='%1', cash='%2', bankacc='%3', cop_gear='%4', cop_licenses='%5', cop_stats='%6', playtime='%7' WHERE pid='%8'",_name,_cash,_bank,_gear,_licenses,_stats,_playtime_update,_uid];};
    case civilian: {_query = joinString ["UPDATE players SET name='%1', cash='%2', bankacc='%3', civ_licenses='%4', civ_gear='%5', arrested='%6', civ_stats='%7', civ_alive='%8', civ_position='%9', playtime='%10' WHERE pid='%11'",_name,_cash,_bank,_licenses,_gear,[_this select 8] call DB_fnc_bool,_stats,[_alive] call DB_fnc_bool,_position,_playtime_update,_uid];};
    case independent: {_query = joinString ["UPDATE players SET name='%1', cash='%2', bankacc='%3', med_licenses='%4', med_gear='%5', med_stats='%6', playtime='%7' WHERE pid='%8'",_name,_cash,_bank,_licenses,_gear,_stats,_playtime_update,_uid];};
};