Help Please

[TMHackSaW 63]

Players and myself log in ok in my server but after when they try to relog they got stucked on downloading character ... 

i have this error :

 4:10:17 "ExileServer - Starting session for 'HackSaW' with ID 'GLtccfvo'..."
 4:10:18 "ExileServer - Database Error: Error Statement Exception"
 4:10:18 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0>
 4:10:18   Error position: <select 0>
 4:10:18   Error Generic error in expression
 4:10:18 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27
 4:10:18 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0>
 4:10:18   Error position: <select 0>
 4:10:18   Error Generic error in expression
 4:10:18 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27
 

anyone can help please?

 

Edited December 11, 2015 by TMHackSaW

[TMHackSaW 63]

Bump!

[Noks 0]

have the same issue did u solve it ? 

[Sebas 4]

Me to same problem. Fix?

[Boxman80 352]

Same problem here , any news on a  fix?

[Eichi 4505]

Can you post the extDB2 logs?

[Boxman80 352]

 

On 12/13/2015 at 11:31 PM, Eichi said:

Can you post the extDB2 logs?

[23:39:24:776394 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: updatePlayer:[BSB] Box:0:96.975388:95.362648:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:209.0955353:20814.462891:6807.855469:0.00116348:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:Exile_Melee_Axe:G_Aviator:["","","",""]::H_Beret_blk_POLICE::[["Exile_Melee_Axe","Exile_Magazine_Swing",999,"Exile_Melee_Axe"]]::["","","",""]:Exile_Melee_Axe:["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1]]:[]:V_TacVest_blk_POLICE:[["optic_MRCO",1]]:[["Exile_Item_Moobar",1]]:[]:1
[23:39:24:776394 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'hitpoints' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE player SET name = ?, damage  = ?, hunger = ?, thirst = ?, alcohol = ?, oxygen_remaining  = ?, bleeding_remaining = ?, hitpoints = ?, direction = ?, position_x = ?, position_y = ?, position_z = ?, assigned_items = ?, backpack = ?, backpack_items = ?, backpack_magazines = ?, backpack_weapons = ?, current_weapon = ?, goggles = ?, handgun_items = ?, handgun_weapon = ?, headgear = ?, binocular = ?, loaded_magazines = ?, primary_weapon = ?, primary_weapon_items = ?, secondary_weapon = ?, secondary_weapon_items = ?, uniform = ?, uniform_items = ?, uniform_magazines = ?, uniform_weapons = ?, vest = ?, vest_items = ?, vest_magazines = ?, vest_weapons = ? WHERE id = ?
[23:39:24:776394 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:39:24:776394 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:[BSB] Box:0:96.975388:95.362648:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:209.0955353:20814.462891:6807.855469:0.00116348:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:Exile_Melee_Axe:G_Aviator:["","","",""]::H_Beret_blk_POLICE::[["Exile_Melee_Axe","Exile_Magazine_Swing",999,"Exile_Melee_Axe"]]::["","","",""]:Exile_Melee_Axe:["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1]]:[]:V_TacVest_blk_POLICE:[["optic_MRCO",1]]:[["Exile_Item_Moobar",1]]:[]:1
[23:40:11:761082 +01:00] [Thread 20048] extDB2: Input from Server: 1:647635:endAccountSession:76561197971675758
[23:40:11:761082 +01:00] [Thread 20048] extDB2: Output to Server: 
[23:40:11:761082 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: endAccountSession:76561197971675758
[23:40:11:762082 +01:00] [Thread 20048] extDB2: Input from Server: 1:647635:updatePlayer:[BSB] Box:0:96.975388:95.362648:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:319.382874:20771.660156:6769.338379:0.452705:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:Exile_Melee_Axe:G_Aviator:["","","",""]::H_Beret_blk_POLICE::[["Exile_Melee_Axe","Exile_Magazine_Swing",999,"Exile_Melee_Axe"]]::["","","",""]:Exile_Melee_Axe:["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1]]:[]:V_TacVest_blk_POLICE:[["optic_MRCO",1]]:[["Exile_Item_Moobar",1],["Exile_Item_EnergyDrink",1]]:[]:1
[23:40:11:762082 +01:00] [Thread 20048] extDB2: Output to Server: 
[23:40:11:762082 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: updatePlayer:[BSB] Box:0:96.975388:95.362648:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:319.382874:20771.660156:6769.338379:0.452705:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:Exile_Melee_Axe:G_Aviator:["","","",""]::H_Beret_blk_POLICE::[["Exile_Melee_Axe","Exile_Magazine_Swing",999,"Exile_Melee_Axe"]]::["","","",""]:Exile_Melee_Axe:["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1]]:[]:V_TacVest_blk_POLICE:[["optic_MRCO",1]]:[["Exile_Item_Moobar",1],["Exile_Item_EnergyDrink",1]]:[]:1
[23:40:11:763082 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'hitpoints' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE player SET name = ?, damage  = ?, hunger = ?, thirst = ?, alcohol = ?, oxygen_remaining  = ?, bleeding_remaining = ?, hitpoints = ?, direction = ?, position_x = ?, position_y = ?, position_z = ?, assigned_items = ?, backpack = ?, backpack_items = ?, backpack_magazines = ?, backpack_weapons = ?, current_weapon = ?, goggles = ?, handgun_items = ?, handgun_weapon = ?, headgear = ?, binocular = ?, loaded_magazines = ?, primary_weapon = ?, primary_weapon_items = ?, secondary_weapon = ?, secondary_weapon_items = ?, uniform = ?, uniform_items = ?, uniform_magazines = ?, uniform_weapons = ?, vest = ?, vest_items = ?, vest_magazines = ?, vest_weapons = ? WHERE id = ?
[23:40:11:763082 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:40:11:763082 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:[BSB] Box:0:96.975388:95.362648:0:1:0:[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]]:319.382874:20771.660156:6769.338379:0.452705:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:Exile_Melee_Axe:G_Aviator:["","","",""]::H_Beret_blk_POLICE::[["Exile_Melee_Axe","Exile_Magazine_Swing",999,"Exile_Melee_Axe"]]::["","","",""]:Exile_Melee_Axe:["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1]]:[]:V_TacVest_blk_POLICE:[["optic_MRCO",1]]:[["Exile_Item_Moobar",1],["Exile_Item_EnergyDrink",1]]:[]:1
[23:40:11:771082 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:40:19:475523 +01:00] [Thread 20048] extDB2: Input from Server: 0:647635:isKnownAccount:76561197971675758
[23:40:19:475523 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: isKnownAccount:76561197971675758
[23:40:19:476523 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[true]]]
[23:40:19:476523 +01:00] [Thread 20048] extDB2: Output to Server: [1,[[true]]]
[23:40:19:476523 +01:00] [Thread 20048] extDB2: Input from Server: 1:647635:startAccountSession:76561197971675758:[BSB] Box
[23:40:19:476523 +01:00] [Thread 20048] extDB2: Output to Server: 
[23:40:19:476523 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: startAccountSession:76561197971675758:[BSB] Box
[23:40:19:489524 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:40:23:321743 +01:00] [Thread 20048] extDB2: Input from Server: 0:647635:hasAlivePlayer:76561197971675758
[23:40:23:321743 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: hasAlivePlayer:76561197971675758
[23:40:23:322743 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Warning: Number of Output Options: 1, Number of SQL Columns: 0, this warning only exists in Debug Version. Its just to let you know of a possible mistake
[23:40:23:322743 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[true]]]
[23:40:23:322743 +01:00] [Thread 20048] extDB2: Output to Server: [1,[[true]]]
[23:40:23:461751 +01:00] [Thread 20048] extDB2: Input from Server: 0:647635:loadPlayer:76561197971675758
[23:40:23:461751 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadPlayer:76561197971675758
[23:40:23:462751 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.hitpoints' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: SELECT p.id, p.name, p.account_uid, p.damage, p.hunger, p.thirst, p.alcohol, p.oxygen_remaining, p.bleeding_remaining, p.hitpoints, p.direction, p.position_x, p.position_y, p.position_z, p.assigned_items, p.backpack, p.backpack_items, p.backpack_magazines, p.backpack_weapons, p.current_weapon, p.goggles, p.handgun_items, p.handgun_weapon, p.headgear, p.binocular, p.loaded_magazines, p.primary_weapon, p.primary_weapon_items, p.secondary_weapon, p.secondary_weapon_items, p.uniform, p.uniform_items, p.uniform_magazines, p.uniform_weapons, p.vest, p.vest_items, p.vest_magazines, p.vest_weapons, a.money, a.score, a.kills, a.deaths, c.name FROM player p INNER JOIN account a ON a.uid = p.account_uid LEFT JOIN clan c ON c.id = a.clan_id WHERE p.account_uid = ?
[23:40:23:462751 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:40:23:462751 +01:00] [Thread 20048] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561197971675758
[23:40:23:462751 +01:00] [Thread 20048] extDB2: Output to Server: [0,"Error Statement Exception"]
[23:41:03:651050 +01:00] [Thread 20048] extDB2: Input from Server: 1:647635:endAccountSession:76561197971675758
[23:41:03:651050 +01:00] [Thread 20048] extDB2: Output to Server: 
[23:41:03:651050 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: endAccountSession:76561197971675758
[23:41:03:652050 +01:00] [Thread 20048] extDB2: Input from Server: 1:647635:updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:0.001297:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Aviator:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[23:41:03:652050 +01:00] [Thread 20048] extDB2: Output to Server: 
[23:41:03:652050 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:0.001297:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Aviator:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[23:41:03:652050 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'hitpoints' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE player SET name = ?, damage  = ?, hunger = ?, thirst = ?, alcohol = ?, oxygen_remaining  = ?, bleeding_remaining = ?, hitpoints = ?, direction = ?, position_x = ?, position_y = ?, position_z = ?, assigned_items = ?, backpack = ?, backpack_items = ?, backpack_magazines = ?, backpack_weapons = ?, current_weapon = ?, goggles = ?, handgun_items = ?, handgun_weapon = ?, headgear = ?, binocular = ?, loaded_magazines = ?, primary_weapon = ?, primary_weapon_items = ?, secondary_weapon = ?, secondary_weapon_items = ?, uniform = ?, uniform_items = ?, uniform_magazines = ?, uniform_weapons = ?, vest = ?, vest_items = ?, vest_magazines = ?, vest_weapons = ? WHERE id = ?
[23:41:03:652050 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[23:41:03:652050 +01:00] [Thread 8168] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:0.001297:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Aviator:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[23:41:03:667050 +01:00] [Thread 6032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
 

[Eichi 4505]

On 15.12.2015 at 1:00 AM, Boxman80 said:

Unknown column 'hitpoints' in 'field list' 

It looks like your database does not contain this field in the player table. Are you sure you have used our new MySQL script? Or did you use one of the community upgrade tools?

[bregan5 36]

4 hours ago, Eichi said:

It looks like your database does not contain this field in the player table. Are you sure you have used our new MySQL script? Or did you use one of the community upgrade tools?

I have the issue with getting stuck at the black screen, spawning in as a rabbit, or spawning in invisible in debug land occur on a more than uncommon basis, but not with the said error. The error I have is

0:10:02 Error in expression <3,10453.310547,2192.393555,0.00141907,["ItemMap","ItemCompass","Exile_Item_XM8",>
 0:10:02   Error position: <ItemMap","ItemCompass","Exile_Item_XM8",>
 0:10:02   Error Missing ]
 0:10:02 Error in expression <3,10453.310547,2192.393555,0.00141907,["ItemMap","ItemCompass","Exile_Item_XM8",>
 0:10:02   Error position: <ItemMap","ItemCompass","Exile_Item_XM8",>
 0:10:02   Error Missing ]
 0:10:02 Error in expression <eateGroup independent;
_player = _group createUnit ["Exile_Unit_Player", _positi>
 0:10:02   Error position: <createUnit ["Exile_Unit_Player", _positi>
 0:10:02   Error Type Any, expected Number
 0:10:02 File exile_server\code\ExileServer_object_player_database_load.sqf, line 21

and

0:11:28 "ExileServer - Starting session for 'sLIM sOLABIM' with ID 'mvpTqfMw'..."
 0:11:33 "ExileServer - Database Error: Error Incorrect Number of Inputs"
 0:11:33 Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
 0:11:33   Error position: <select 0) select 0>
 0:11:33   Error Generic error in expression
 0:11:33 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
 0:11:33 Error in expression <se_handleBig;
};
};
((_result select 1) select 0) select 0>
 0:11:33   Error position: <select 0) select 0>
 0:11:33   Error Generic error in expression
 0:11:33 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27

There have been at times since the Exile update I have had 60 people on the server, all having no issues. This just randomly occurs and the solution is deleting the record from the player table. I have attempted to remove entries/add in columns for the specific record but it doesn't help. Between these issues and the access_violations crashes which Bohemia views as "lawl its just Exile"...I just don't know...pretty disappointed.

 

 

Initially when the update came out I did not have so many issues with this. However, as I am attempting to use Bohemia's server performance binaries to resolve the crashing issues, it seems that these issues have increased in frequency. I understand that these are database and exile interactions, but that is all that has changed.

Edited December 18, 2015 by bregan5

[FatSquirrel 13]

Update your MySql version (>5.6) and create the database newly from scratch! You cannot use the old database.