Probleme nach dem Update

Snake586

Hallo freunde und einen schönen guten Abend,

Nach dem Server-Update auf die 1.64 habe ich ein Problem das er die Eiträge in die Datenbank komplet versaut er setzt vieles in Doppelte Anführungsstriche

Spoiler anzeigen

19:43:14 Error in expression <[[''license_civ_einwohner'',0],[''license_ci>
19:43:14 Error position: <license_civ_einwohner'',0],[''license_ci>
19:43:14 Error Missing ]
19:43:14 Error in expression <[[''license_civ_einwohner'',0],[''license_ci>
19:43:14 Error position: <license_civ_einwohner'',0],[''license_ci>
19:43:14 Error Missing ]
19:43:14 Error in expression <y = call compile format ["%1", _array];
_array;>
19:43:14 Error position: <_array;>
19:43:14 Error Undefined variable in expression: _array
19:43:14 File life_server\Functions\MySQL\fn_mresToArray.sqf, line 26
19:43:14 Error in expression <select 6)] call DB_fnc_mresToArray;
if (_new isEqualType "") then {_new = call c>
19:43:14 Error position: <_new isEqualType "") then {_new = call c>
19:43:14 Error Undefined variable in expression: _new
19:43:14 File life_server\Functions\MySQL\fn_queryRequest.sqf, line 58

exclusiv

Deinen life_sevrer -> fn_mres_Array Inhalt mit diesem austauschen

Code

/*
    File: fn_mresArray.sqf
    Author: Bryan "Tonic" Boardwine";
    Description:
    Acts as a mres (MySQL Real Escape) for arrays so they
    can be properly inserted into the database without causing
    any problems. The return method is 'hacky' but it's effective.
*/
private ["_array"];
_array = [_this,0,[],[[]]] call BIS_fnc_param;
_array = str _array;
_array = toArray(_array);




for "_i" from 0 to (count _array)-1 do
{
    _sel = _array select _i;
    if ((_i != 0 && _i != ((count _array)-1))) then
    {
        if (_sel isEqualTo 34) then
        {
            _array set[_i,96];
        };
    };
};




str(toString(_array));

Alles anzeigen

nox

Schau mal in die Shoutbox.

nox

Oh, da ist ja schon der Inhalt der Shoutbox, danke @exclusiv

r8n8gad8

Ich habe den gleichen Inhalt aber ebenfalls mit den gleichen Fehlermeldungen zu tun.

4.4R3

blackfisch

Zitat von Snake586

19:43:14 File life_server\Functions\MySQL\fn_queryRequest.sqf, line 58

Mal schicken bitte Dankeschön

cat24max

Geht leider auch mit der neuen mres Array nicht. Macht sogar noch mehr kaputt.

r8n8gad8

Das hier ist die Fehlermeldung wenn ich als Cop spawne....ich bin nackt ohne Ausrüstung und Lizenzen:

Code

Error in expression <[[''license_cop_cAir'',1],[''license_cop_cg'>
  Error position: <license_cop_cAir'',1],[''license_cop_cg'>
  Error Missing ]
Error in expression <[[''license_cop_cAir'',1],[''license_cop_cg'>
  Error position: <license_cop_cAir'',1],[''license_cop_cg'>
  Error Missing ]
Error in expression <ay = call compile format["%1", _array];
_array;>
  Error position: <_array;>
  Error Undefined variable in expression: _array
File life_server\Functions\MySQL\fn_mresToArray.sqf, line 26
Error in expression <select 6)] call DB_fnc_mresToArray;
if (_new isEqualType "") then {_new = call c>
  Error position: <_new isEqualType "") then {_new = call c>
  Error Undefined variable in expression: _new
File life_server\Functions\MySQL\fn_queryRequest.sqf, line 58
Error in expression <[''U_B_GEN_Commander_F'',''V_PlateCarrier2_>
  Error position: <U_B_GEN_Commander_F'',''V_PlateCarrier2_>
  Error Missing ]
Error in expression <[''U_B_GEN_Commander_F'',''V_PlateCarrier2_>
  Error position: <U_B_GEN_Commander_F'',''V_PlateCarrier2_>
  Error Missing ]
Error in expression <ay = call compile format["%1", _array];
_array;>
  Error position: <_array;>
  Error Undefined variable in expression: _array
File life_server\Functions\MySQL\fn_mresToArray.sqf, line 26
Error in expression <select 8)] call DB_fnc_mresToArray;
if (_new isEqualType "") then {_new = call c>
  Error position: <_new isEqualType "") then {_new = call c>
  Error Undefined variable in expression: _new
File life_server\Functions\MySQL\fn_queryRequest.sqf, line 71

Alles anzeigen

Das hier ist fn_mresToArray

Code: fn_mresToArray.sqf

/*
    File: fn_mresToArray.sqf
    Author: Bryan "Tonic" Boardwine";




    Description:
    Acts as a mres (MySQL Real Escape) for arrays so they
    can be properly inserted into the database without causing
    any problems. The return method is 'hacky' but it's effective.
*/
private["_array"];
_array = [_this,0,"",[""]] call BIS_fnc_param;
if (_array isEqualTo "") exitWith {[]};
_array = toArray(_array);




for "_i" from 0 to (count _array)-1 do
{
    _sel = _array select _i;
    if (_sel == 96) then
    {
        _array set[_i,39];
    };
};




_array = toString(_array);
_array = call compile format["%1", _array];
_array;

Alles anzeigen

Das hier ist die fn_queryRequest.sqf

Code: fn_queryRequest.sqf

#include "\life_server\script_macros.hpp"
/*
    File: fn_queryRequest.sqf
    Author: Bryan "Tonic" Boardwine




    Description:
    Handles the incoming request and sends an asynchronous query
    request to the database.




    Return:
    ARRAY - If array has 0 elements it should be handled as an error in client-side files.
    STRING - The request had invalid handles or an unknown error and is logged to the RPT.
*/
private["_uid","_side","_query","_queryResult","_tickTime","_tmp"];
_uid = [_this,0,"",[""]] call BIS_fnc_param;
_side = [_this,1,sideUnknown,[civilian]] call BIS_fnc_param;
_ownerID = [_this,2,ObjNull,[ObjNull]] call BIS_fnc_param;




if (isNull _ownerID) exitWith {};
_ownerID = owner _ownerID;




_query = switch (_side) do {
    // West - 11 entries returned
    case west: {format["SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, cop_licenses, coplevel, cop_gear, blacklist, cop_stats, playtime FROM players WHERE playerid='%1'",_uid];};
    // Civilian - 12 entries returned
    case civilian: {format["SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='%1'",_uid];};
    // Independent - 10 entries returned
    case independent: {format["SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, med_licenses, mediclevel, med_gear, med_stats, playtime FROM players WHERE playerid='%1'",_uid];};
};




_tickTime = diag_tickTime;
_queryResult = [_query,2] call DB_fnc_asyncCall;




if (EXTDB_SETTING(getNumber,"DebugMode") isEqualTo 1) then {
    diag_log "------------- Client Query Request -------------";
    diag_log format["QUERY: %1",_query];
    diag_log format["Time to complete: %1 (in seconds)",(diag_tickTime - _tickTime)];
    diag_log format["Result: %1",_queryResult];
    diag_log "------------------------------------------------";
};




if (_queryResult isEqualType "") exitWith {
    [] remoteExecCall ["SOCK_fnc_insertPlayerInfo",_ownerID];
};




if (count _queryResult isEqualTo 0) exitWith {
    [] remoteExecCall ["SOCK_fnc_insertPlayerInfo",_ownerID];
};




//Blah conversion thing from a2net->extdb
_tmp = _queryResult select 2;
_queryResult set[2,[_tmp] call DB_fnc_numberSafe];
_tmp = _queryResult select 3;
_queryResult set[3,[_tmp] call DB_fnc_numberSafe];




//Parse licenses (Always index 6)
_new = [(_queryResult select 6)] call DB_fnc_mresToArray;
if (_new isEqualType "") then {_new = call compile format["%1", _new];};
_queryResult set[6,_new];




//Convert tinyint to boolean
_old = _queryResult select 6;
for "_i" from 0 to (count _old)-1 do {
    _data = _old select _i;
    _old set[_i,[_data select 0, ([_data select 1,1] call DB_fnc_bool)]];
};




_queryResult set[6,_old];




_new = [(_queryResult select 8)] call DB_fnc_mresToArray;
if (_new isEqualType "") then {_new = call compile format["%1", _new];};
_queryResult set[8,_new];
//Parse data for specific side.
switch (_side) do {
    case west: {
        _queryResult set[9,([_queryResult select 9,1] call DB_fnc_bool)];




        //Parse Stats
        _new = [(_queryResult select 10)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _queryResult set[10,_new];




        //Playtime
        _new = [(_queryResult select 11)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _index = TON_fnc_playtime_values_request find [_uid, _new];
        if (_index != -1) then {
            TON_fnc_playtime_values_request set[_index,-1];
            TON_fnc_playtime_values_request = TON_fnc_playtime_values_request - [-1];
            TON_fnc_playtime_values_request pushBack [_uid, _new];
        } else {
            TON_fnc_playtime_values_request pushBack [_uid, _new];
        };
        [_uid,_new select 0] call TON_fnc_setPlayTime;
    };




    case civilian: {
        _queryResult set[7,([_queryResult select 7,1] call DB_fnc_bool)];




        //Parse Stats
        _new = [(_queryResult select 9)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _queryResult set[9,_new];




        //Position
        _queryResult set[10,([_queryResult select 10,1] call DB_fnc_bool)];
        _new = [(_queryResult select 11)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _queryResult set[11,_new];




        //Playtime
        _new = [(_queryResult select 12)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _index = TON_fnc_playtime_values_request find [_uid, _new];
        if (_index != -1) then {
            TON_fnc_playtime_values_request set[_index,-1];
            TON_fnc_playtime_values_request = TON_fnc_playtime_values_request - [-1];
            TON_fnc_playtime_values_request pushBack [_uid, _new];
        } else {
            TON_fnc_playtime_values_request pushBack [_uid, _new];
        };
        [_uid,_new select 2] call TON_fnc_setPlayTime;




        _houseData = _uid spawn TON_fnc_fetchPlayerHouses;
        waitUntil {scriptDone _houseData};
        _queryResult pushBack (missionNamespace getVariable[format["houses_%1",_uid],[]]);
        _gangData = _uid spawn TON_fnc_queryPlayerGang;
        waitUntil{scriptDone _gangData};
        _queryResult pushBack (missionNamespace getVariable[format["gang_%1",_uid],[]]);
    };




    case independent: {
        //Parse Stats
        _new = [(_queryResult select 9)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _queryResult set[9,_new];




        //Playtime
        _new = [(_queryResult select 10)] call DB_fnc_mresToArray;
        if (_new isEqualType "") then {_new = call compile format["%1", _new];};
        _index = TON_fnc_playtime_values_request find [_uid, _new];
        if (_index != -1) then {
            TON_fnc_playtime_values_request set[_index,-1];
            TON_fnc_playtime_values_request = TON_fnc_playtime_values_request - [-1];
            TON_fnc_playtime_values_request pushBack [_uid, _new];
        } else {
            TON_fnc_playtime_values_request pushBack [_uid, _new];
        };
        [_uid,_new select 1] call TON_fnc_setPlayTime;
    };
};




publicVariable "TON_fnc_playtime_values_request";




_keyArr = missionNamespace getVariable [format["%1_KEYS_%2",_uid,_side],[]];
_queryResult set[15,_keyArr];




_queryResult remoteExec ["SOCK_fnc_requestReceived",_ownerID];

Alles anzeigen

Lucian

Naja die Datensätze sind nach dem Update im Arsch, außer man hat meine mresArry eingefügt bevor man das Update installiert.
Also entweder manuell alle Datensätze fixen oder BackUp.

cat24max

Backups sind immer hilfreich...

Mensch Bohemia ist ganz schön inkompetent.

r8n8gad8

Also ist die Lösung ist die life_server\Functions\MySQL\fn_mresArray hiermit

Code

/*
 File: fn_mresArray.sqf
 Author: Bryan "Tonic" Boardwine";
 Description:
 Acts as a mres (MySQL Real Escape) for arrays so they
 can be properly inserted into the database without causing
 any problems. The return method is 'hacky' but it's effective.
*/
private ["_array"];
_array = [_this,0,[],[[]]] call BIS_fnc_param;
_array = str _array;
_array = toArray(_array);
for "_i" from 0 to (count _array)-1 do
{
 _sel = _array select _i;
 if ((_i != 0 && _i != ((count _array)-1))) then
 {
 if (_sel isEqualTo 34) then
 {
 _array set[_i,96];
 };
 };
};
str(toString(_array));

Alles anzeigen

zu ersetzen und ein Backup einzuspielen?

EDIT:
Das ist die Lösung!

Atranox

hat sich erledigt

KlitschKO

Wovon ein Backup? vom Script oder nur der live_server

? Gruß

blackfisch

Zitat von KlitschKO

Wovon ein Backup? vom Script oder nur der live_server

Zitat von Lucian

Naja die Datensätze sind nach dem Update im Arsch, außer man hat meine mresArry eingefügt bevor man das Update installiert.
Also entweder manuell alle Datensätze fixen oder BackUp.

Von der Datenbank vorher ein Backup anlegen *zum Glück steht bei mir selbst noch nicht viel drin ^^*

KlitschKO

Okay, das habe ich jetzt verstanden, die Frage wäre nur, was hat er in der Datenbank geändert? weist du das? weil dan Fixe ich das.. Bei mir wären 370 Spieler weg!

Gruß

blackfisch

Nunja.... fn_mresArray,sqf - wie der Dateiname schon sagt - Arrays. in der 4.4r3 kann das sein Lizenzen, Loadouts, Stats.. Alles wo Eckige Klammern um die Werte sind

ZorG

Die Datenbank zu fixen ist einfach.

Diesen SQL Befehl in der DB ausführen.

SQL

UPDATE `players` 
 SET `cop_licenses` = replace(cop_licenses, '``', '`'),
 `civ_licenses` = replace(civ_licenses, '``', '`'),
 `med_licenses` = replace(med_licenses, '``', '`'),
 `cop_gear` = replace(cop_gear, '``', '`'),
 `civ_gear` = replace(civ_gear, '``', '`'),
 `med_gear` = replace(med_gear, '``', '`'),
 `aliases` = replace(aliases, '``', '`')
    WHERE `playerid` > 0

ZorG

Code

/*
     File: fn_mresArray.sqf
     Author: Bryan "Tonic" Boardwine";
     Description:
     Acts as a mres (MySQL Real Escape) for arrays so they
     can be properly inserted into the database without causing
     any problems. The return method is 'hacky' but it's effective.
    */
    private ["_array"];
    _array = [_this,0,[],[[]]] call BIS_fnc_param;
    //_array = str(str _array); // ab 1.64 kann das arma offenbar selber!
    _array = toArray(_array);
    for "_i" from 0 to (count _array)-1 do
    {
     _sel = _array select _i;
     if ((_i != 0 && _i != ((count _array)-1))) then
     {
     if (_sel isEqualTo 34) then
     {
     _array set[_i,96];
     };
     };
    };
    str(toString(_array));

Alles anzeigen

~~Ich hatte das umwandeln in STRING einfach rausgenommen, dann ging es auch.~~

EDIT: Falsch, ging nur scheinbar.

Der Changelog zum Patch ist ellen lang, aber dass das toARRAY verändert wurde, davon schreiben die Bohemiabanditen nichts.

ZorG

Noch einen Hinweis, falls Häuser oder Fahrzeug Inventar in der DB gespeichert werden, diese sind dann auch Fehlerhaft, wenn Spieler vor dem mresarry Fix drauf waren!

Lukas710

hab mall eine frage immer wenn ich versuche auf meins test Server zu Join werde ich nach der map rausgeworfen Grund (BattlEye : AddWeaponCargo Restriction # 1)

Probleme nach dem Update

Ähnliche Themen

Task Force Radio | Linux Server

hey kennt jemand einen restar manger

ArmA 3 Server geht nach Update nicht

Arma Server startet nach Update nun nicht mehr Fehler: 0xc000007b Davor lief er ohne Probleme.

nach dem letzten Arma3 Update Kaputte Datenbank?

Tags