15 posts in this topic

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 by TMHackSaW

Share this post


Link to post
Share on other sites
Advertisement

 

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,[]]
 

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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 by bregan5

Share this post


Link to post
Share on other sites

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

 

 

1 person likes this

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.