fn_asynccall Fehler

    Wir haben aktuell das Problem auf unserem Server, dass folgende Fehlermeldung erscheint und wir den Fehler nicht wirklich finden.

    Spoiler anzeigen


    _return = (_queryResult select 1) select 0;
    if(_multiarr) then {
    _return =>
    21:14:04 Error position: <select 0;
    if(_multiarr) then {
    _return =>
    21:14:04 Error Generic error in expression
    21:14:04 File life_server\Functions\MySQL\fn_asyncCall.sqf, line 49

    Spoiler anzeigen

    /*
    File: fn_asyncCall.sqf
    Author: Bryan "Tonic" Boardwine

    Description:
    Commits an asynchronous call to [lexicon]ExtDB[/lexicon]

    Parameters:
    0: STRING (Query to be ran).
    1: INTEGER (1 = ASYNC + not return for update/insert, 2 = ASYNC + return for query's).
    3: BOOL (True to return a single array, false to return multiple entries mainly for garage).
    */
    waitUntil {!DB_Async_Active};
    private["_queryStmt","_queryResult","_key","_mode","_return"];
    _queryStmt = [_this,0,"",[""]] call BIS_fnc_param;
    _mode = [_this,1,1,[0]] call BIS_fnc_param;
    _multiarr = [_this,2,false,[false]] call BIS_fnc_param;

    if(_queryStmt == "") exitWith {"_INVALID_SQL_STMT"};
    _return = false;
    DB_Async_Active = true;

    _queryResult = "";
    _key = "[lexicon]extDB[/lexicon]" callExtension format["%1:%2:%3",_mode,(call life_sql_id),_queryStmt];
    if(_mode == 1) exitWith {DB_Async_Active = false; true};
    _key = call compile format["%1",_key]; _key = _key select 1;

    waitUntil{sleep (random .03); !DB_Async_ExtraLock};
    DB_Async_ExtraLock = true;
    while{true} do {
    _pipe = "[lexicon]extDB[/lexicon]" callExtension format["5:%1",_key];
    if(_pipe == "") exitWith {};
    if(_pipe != "[3]") then {
    _queryResult = _queryResult + _pipe;
    } else {
    sleep 0.35;
    };
    };

    DB_Async_ExtraLock = false;
    DB_Async_Active = false;
    //Get the Array of information blah blah
    _queryResult = call compile _queryResult;

    //Make everything possible for DB_RAW_V2
    _queryResult = (_queryResult select 1);

    if(count (_queryResult select 1) == 0) exitWith {[]};
    _return = (_queryResult select 1) select 0;
    if(_multiarr) then {
    _return = (_queryResult select 1);
    };

    _return;

    Die RPT Logs hängen. Wenn ihr braucht sagt Bescheid

    Spoiler anzeigen

    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Version: 35
    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Windows Version
    [18:33:47 +02:00] [Thread 1894880547] Message: Arma Linux Servers are using Older Physic Library (than Windows Servers), due to Debian 7 using old version of Glibc
    [18:33:47 +02:00] [Thread 1894880547] Message: If you like [lexicon]extDB[/lexicon] consider donating or bug BIS to drop support for Debian 7 thanks, so Linux Servers get same Physic Library Version as Windows
    [18:33:47 +02:00] [Thread 1894880547] Message: Note currently most/all development for [lexicon]extDB[/lexicon] is done on a Linux Server
    [18:33:47 +02:00] [Thread 1894880547] Message: Torndeco: 24/01/15
    [18:33:47 +02:00] [Thread 1894880547]
    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Found [lexicon]extdb[/lexicon]-conf.ini
    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Detected 12 Cores, Setting up 6 Worker Threads
    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Database Type: MySQL
    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Database Session Pool Started
    [18:33:47 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: DB_RAW_V3: Initialized: ADD_QUOTES True
    [18:37:57 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198010967360' AND owned='1'
    [18:37:57 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198010967360' AND owned='1'
    [18:39:43 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198010967360' AND owned='1'
    [18:39:43 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198010967360' AND owned='1'
    [21:12:59 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198077544258' AND owned='1'
    [21:12:59 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198077544258' AND owned='1'
    [21:13:18 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198077544258' AND owned='1'
    [21:13:18 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198077544258' AND owned='1'
    [21:14:04 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'inventory' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198077544258' AND owned='1'
    [21:14:04 +02:00] [Thread 2006722191] [lexicon]extDB[/lexicon]: DB_RAW_V3: Error StatementException: SQL: SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198077544258' AND owned='1'
    [22:49:51 +02:00] [Thread 1894880547] [lexicon]extDB[/lexicon]: Stopping ...

    Ich kann mich natürlich Irren, aber meine jahrelangen Erfahrungen mit SQL sagen mir das diese Abfrage nicht funktionieren kann.

    Der Grund:

    //Grundkurs SQL Start

    SELECT pid, pos, inventory, containers FROM houses WHERE pid='76561198010967360' AND owned='1'

    SELECT ..... definiert die Spalten, welche ausgelesen werden sollen aus der Tabelle. Bei dir sind das pid, pos, inventory, containers

    FROM ..... definiert die Tabelle/Abfrage, in welcher die Spalten ausgelesen werden sollen. | houses

    WHERE ... definiert die Bedingungen/Filter. Sprich die enthaltenen Zahlen oder Wörter | pid und owned


    //Grundkurs SQL Ende


    Der Grund warum der Fehler kommt ist owned='1'

    Es liegt daran, das du einen Wert aus der Spalte owned abfragst, Sie aber nicht in der SELECT Anweisung mit eingebunden hast.


    //Folgendes sollte Funktionieren

    SELECT pid, pos, inventory, containers, owned FROM houses WHERE pid='76561198010967360' AND owned='1'


    habe also , owned mit ausgewählt(Select) und kann somit auch Daten filtern(where) pid='76561198010967360' AND owned='1'

    EDIT: offensichtlich habe ich mich geirrt und MYSQL ignoriert die Standards von SELECT (getestet mit: SELECT id from houses where owned='1' //listet trotzdem die entsprechenden Datensätze auf #verwirrt

    ausprobieren, lernen, weiterentwickeln, verbessern :gamer:

    kein Support per PM | schnelle Fehleranalyse >> RPT log Filter

    eine Liste der Dateien die du geändert hast mit Inhalt wären mehr als hilfreich.

    Dann wäre natürlich interessant was du gemacht hast oder machen willst ^^

    ausprobieren, lernen, weiterentwickeln, verbessern :gamer:

    kein Support per PM | schnelle Fehleranalyse >> RPT log Filter

    fn_addHouse.sqf

    Spoiler anzeigen

    /*
    Author: Bryan "Tonic" Boardwine
    Description:
    Blah
    */
    private["_house","_uid","_housePos","_query"];
    _uid = [_this,0,"",[""]] call BIS_fnc_param;
    _house = [_this,1,ObjNull,[ObjNull]] call BIS_fnc_param;
    if(isNull _house OR _uid == "") exitWith {};

    _housePos = getPosATL _house;

    _query = format["INSERT INTO houses (pid, pos, inventory, containers, owned) VALUES('%1', '%2', '""[[],0]""', '""[]""', '1')",_uid,_housePos];
    diag_log format["Query: %1",_query];
    waitUntil{!DB_Async_Active};
    [_query,1] call DB_fnc_asyncCall;

    sleep 0.3;
    waitUntil{!DB_Async_Active};
    _query = format["SELECT id FROM houses WHERE pos='%1' AND pid='%2' AND owned='1'",_housePos,_uid];
    _queryResult = [_query,2] call DB_fnc_asyncCall;
    //systemChat format["House ID assigned: %1",_queryResult select 0];
    _house setVariable["house_id",(_queryResult select 0),true];

    fn_fetchPlayerHouses.sqf

    Spoiler anzeigen

    /*
    Author: Bryan "Tonic" Boardwine
    Description:
    Fetches all the players houses and sets them up.
    */
    private["_query","_houses"];
    if(_this == "") exitWith {};

    _query = format["SELECT pid, pos, inventory, containers, owned FROM houses WHERE pid='%1' AND owned='1'",_this];
    waitUntil{!DB_Async_Active};
    _houses = [_query,2,true] call DB_fnc_asyncCall;

    _return = [];
    {
    _pos = call compile format["%1",_x select 1];
    _house = nearestBuilding _pos;
    _house allowDamage false;
    _containers = [];
    _house setVariable["slots",[],true];
    if(!isNil {(_house getVariable "containers")}) then {
    {if(!isNull _x) then {deleteVehicle _x;};} foreach (_house getVariable "containers");
    };
    _trunk = [_x select 2] call DB_fnc_mresToArray;
    if(typeName _trunk == "STRING") then {_trunk = call compile format["%1", _trunk];};
    _containerData = [_x select 3] call DB_fnc_mresToArray;
    if(typeName _containerData == "STRING") then {_containerData = call compile format["%1", _containerData];};
    _house setVariable["Trunk",_trunk,true];
    {
    if(count _x == 0) exitWith {}; //No containers / items.
    _className = _x select 0;
    _weapons = (_x select 1) select 0;
    _magazines = (_x select 1) select 1;
    _items = (_x select 1) select 2;
    _backpacks = (_x select 1) select 3;

    //Setup the variables
    _positions = [_house] call life_fnc_getBuildingPositions;
    _pos = [0,0,0];

    {
    _slots = _house getVariable ["slots",[]];
    if(!(_forEachIndex in _slots)) exitWith {
    _slots pushBack _forEachIndex;
    _house setVariable["slots",_slots,true];
    _pos = _x;
    };
    } foreach _positions;

    if(_pos isEqualTo [0,0,0]) exitWith {};

    _container = createVehicle[_className,_pos,[],0,"NONE"];
    waitUntil{!isNil "_container"};
    _container setPosATL _pos;
    //_container enableSimulation false;

    _containers pushBack _container;
    clearWeaponCargoGlobal _container;
    clearItemCargoGlobal _container;
    clearMagazineCargoGlobal _container;
    clearBackpackCargoGlobal _container;
    //Add weapons to the crate.
    {
    _weaponCount = (_weapons select 1) select _forEachIndex;
    _container addWeaponCargoGlobal [_x,_weaponCount];
    } foreach (_weapons select 0);

    //Add magazines
    {
    _magazineCount = (_magazines select 1) select _forEachIndex;
    _container addMagazineCargoGlobal [_x,_magazineCount];
    } foreach (_magazines select 0);

    //Add items
    {
    _itemCount = (_items select 1) select _forEachIndex;
    _container addItemCargoGlobal [_x,_itemCount];
    } foreach (_items select 0);

    //Add backpacks
    {
    _backpackCount = (_backpacks select 1) select _forEachIndex;
    _container addBackpackCargoGlobal [_x,_backpackCount];
    } foreach (_backpacks select 0);

    } foreach _containerData;
    _house setVariable["containers",_containers,true];
    _return pushBack [_x select 1,_containers];
    } foreach _houses;

    missionNamespace setVariable[format["houses_%1",_this],_return];

    Zitat von SBuserhy

    Ich kann mich natürlich Irren, aber meine jahrelangen Erfahrungen mit SQL sagen mir das diese Abfrage nicht funktionieren kann.


    Der Grund warum der Fehler kommt ist owned='1'

    Es liegt daran, das du einen Wert aus der Spalte owned abfragst, Sie aber nicht in der SELECT Anweisung mit eingebunden hast.

    Komm ma wieder runter, jahrelange SQL Erfahrung hin oder her, aber das ist völliger Blödsinn den du da schreibst. Wenn du nur Häuser auslesen lassen willst die owned=1 sind dann machst du das auch so und musst diese Bedingung nicht mit Selecten.

    dann behebe mal folgende Fehler

    Spoiler anzeigen

    18:33:29 Error in expression <ch (_filter) do
    {

    case 0:
    {
    if(__GETC__(life_adaclevel) > 1) then
    {
    _ret pushBa>
    18:33:29 Error position: <(life_adaclevel) > 1) then
    {
    _ret pushBa>
    18:33:29 Error Missing )
    18:33:29 File mpmissions\Server.Bornholm\core\config\fn_clothing_adac.sqf, line 22
    18:33:29 Error in expression <ch (_filter) do
    {

    case 0:
    {
    if(__GETC__(life_adaclevel) > 1) then
    {
    _ret pushBa>
    18:33:29 Error position: <(life_adaclevel) > 1) then
    {
    _ret pushBa>
    18:33:29 Error Missing )
    18:33:29 File mpmissions\Server.Bornholm\core\config\fn_clothing_adac.sqf, line 22
    18:33:29 Error in expression <vest","Beamten Uniform",25];
    if(__GETC__(life_medlevel) > 0) then
    {
    _ret pushBac>
    18:33:29 Error position: <(life_medlevel) > 0) then
    {
    _ret pushBac>
    18:33:29 Error Missing )
    18:33:29 File mpmissions\Server.Bornholm\core\config\fn_clothing_med.sqf, line 23
    18:33:29 Error in expression <vest","Beamten Uniform",25];
    if(__GETC__(life_medlevel) > 0) then
    {
    _ret pushBac>
    18:33:29 Error position: <(life_medlevel) > 0) then
    {
    _ret pushBac>
    18:33:29 Error Missing )
    18:33:29 File mpmissions\Server.Bornholm\core\config\fn_clothing_med.sqf, line 23

    dann noch den Fehler im Tanksystem beheben

    Spoiler anzeigen

    18:33:46 Error in expression <{ _x setFuelCargo 0; } forEach (nearestObjects [Tankstelle, ["Land_fs_fe>
    18:33:46 Error position: <nearestObjects [Tankstelle, ["Land_fs_fe>
    18:33:46 Error 0 elements provided, 3 expected

    Die Goldbarren in der Bank

    Spoiler anzeigen

    19:03:48 Error in expression <e {true} do
    {
    sleep (30 * 60);
    _funds = fed_bank getVariable["safe",0];
    fed_bank>
    19:03:48 Error position: <fed_bank getVariable["safe",0];
    fed_bank>
    19:03:48 Error Undefined variable in expression: fed_bank
    19:03:48 File life_server\Functions\Systems\fn_federalUpdate.sqf, line 12


    wenn du die Fehler behoben hast, sieht das schon ganz anders aus
    der Fehler muss nicht zwingend in der fn_asyncall.sqf sein

    ausprobieren, lernen, weiterentwickeln, verbessern :gamer:

    kein Support per PM | schnelle Fehleranalyse >> RPT log Filter

    Mein Auszug aus der Konversation:


    Er hat die houses Tabbelle so erstellt
    (hat er mir gesendet)

    Code
    CREATE TABLE IF NOT EXISTS `houses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` varchar(32) NOT NULL,
`pos` varchar(64) DEFAULT NULL,
`owned` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

    Abgefragt werden:


    SELECT pid, pos,inventory, containers FROM houses WHERE pid='%1' AND owned='1'

    Er benutzt nach Version hier im Thread die 3.1.4.8

    Die lautet aber so:

    Code
    CREATE TABLE IF NOT EXISTS `houses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` varchar(32) NOT NULL,
`pos` varchar(64) DEFAULT NULL,
`inventory` text,
`containers` text,
`owned` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;