• 0
On4fox

Error position: <createUnit [Exile_Unit_Player

Question

I got a player spawning not correctly and i got this in the rtp.

17:46:55 "ExileServer - Starting session for '-=Maschiene=-09' with ID 'WSExeQbO'..."
17:46:55 Error in expression <em_Wrench",1]],[],51475,2281,10,10,""]]]>
17:46:55   Error position: <>
17:46:55   Error Missing ]
17:46:55 Error in expression <em_Wrench",1]],[],51475,2281,10,10,""]]]>
17:46:55   Error position: <>
17:46:55   Error Missing ]
17:46:55 Error in expression <eateGroup independent;
_player = _group createUnit ["Exile_Unit_Player", _positi>
17:46:55   Error position: <createUnit ["Exile_Unit_Player", _positi>
17:46:55   Error Type Any, expected Number
17:46:55 File exile_server\code\ExileServer_object_player_database_load.sqf, line 21

 

I deleted his entry in the player table and now its working. But it sound like there is some code broken.

Cheers,

 

Ps.: one more....

 

 

 0:03:34 Error in expression <_02_F","6Rnd_45ACP_Cylinder",6,"hgun_P,"arifle_Katiba_GL_F",["","acc_pointer_IR">
 0:03:34   Error position: <arifle_Katiba_GL_F",["","acc_pointer_IR">
 0:03:34   Error Missing ]
 0:03:34 Error in expression <_02_F","6Rnd_45ACP_Cylinder",6,"hgun_P,"arifle_Katiba_GL_F",["","acc_pointer_IR">
 0:03:34   Error position: <arifle_Katiba_GL_F",["","acc_pointer_IR">
 0:03:34   Error Missing ]
 0:03:34 Error in expression <eateGroup independent;
_player = _group createUnit ["Exile_Unit_Player", _positi>
 0:03:34   Error position: <createUnit ["Exile_Unit_Player", _positi>
 0:03:34   Error Type Any, expected Number
 0:03:34 File exile_server\code\ExileServer_object_player_database_load.sqf, line 21

 

Edited by On4fox

Share this post


Link to post
Share on other sites

2 answers to this question

  • 1

Thankfully i got the right answer....

someone desided it would be a great idea to limit the chars in "some" rows to  255 .... for example loaded_magazines in the player table.
I don't know why.

So if you pick up the wrong items your player is broken and you spawn as a animal...

This is one broken player...
 


INSERT INTO `player` (`id`, `name`, `account_uid`, `damage`, `hunger`, `thirst`, `alcohol`, `oxygen_remaining`, `bleeding_remaining`, `hitpoints`, `direction`, `position_x`, `position_y`, `position_z`, `spawned_at`, `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`, `last_updated_at`) VALUES
(2056, 'name_xxx', 'xxx', 0.149606, 82.612259, 73.554733, 0, 1, 0, '[["face_hub",0.149606],["neck",0.149606],["head",0.149606],["pelvis",0.149606],["spine1",0.149606],["spine2",0.149606],["spine3",0.149606],["body",0.149606],["arms",0.149606],["hands",0.149606],["legs",0.149606]]', 142.565842, 12740.933594, 9597.521484, 5.353245, '2015-12-19 23:40:01', '["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]', 'B_Bergen_rgr', '[]', '[["UGL_FlareWhite_F",1],["Exile_Item_PlasticBottleFreshWater",1],["30Rnd_65x39_caseless_green",19]]', '[["hgun_Pistol_heavy_01_F",1],["SMG_02_F",1],["arifle_SDAR_F",1]]', 'arifle_Katiba_GL_F', 'G_B_Diving', '["","","",""]', 'hgun_Pistol_heavy_02_F', 'H_Cap_tan_specops_US', '', '[["arifle_Katiba_GL_F","30Rnd_65x39_caseless_green",30,"arifle_Katiba_GL_F"],["arifle_Katiba_GL_F","1Rnd_HE_Grenade_shell",1,"EGLM"],["Exile_Melee_Axe","Exile_Magazine_Swing",999,"Exile_Melee_Axe"],["hgun_Pistol_heavy_02_F","6Rnd_45ACP_Cylinder",6,"hgun_P', 'arifle_Katiba_GL_F', '["","acc_pointer_IR","optic_MRCO",""]', 'Exile_Melee_Axe', '["","","",""]', 'U_C_Poloshirt_blue', '[]', '[["Exile_Item_ToiletPaper",1],["Exile_Item_PlasticBottleFreshWater",1],["SmokeShell",1],["Exile_Item_ThermalScannerPro",5]]', '[]', 'V_Chestrig_blk', '[]', '[["1Rnd_SmokeOrange_Grenade_shell",1],["Exile_Item_PlasticBottleEmpty",1],["30Rnd_556x45_Stanag_Tracer_Red",30],["30Rnd_556x45_Stanag_Tracer_Red",30],["Exile_Item_CamoTentKit",1],["Exile_Item_ToiletPaper",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_ChristmasTinner",1],["Exile_Item_PlasticBottleEmpty",1],["Exile_Item_InstantCoffee",1],["Exile_Item_LightBulb",1],["9Rnd_45ACP_Mag",9],["Exile_Item_InstantCoffee",1]]', '[]', '2015-12-19 23:59:28');


The solution would be to fix the mysql schema.

To see errors in your player data (This will list all the players that are buggy)
 

SELECT * FROM `player` WHERE RIGHT(loaded_magazines,1) != ']' OR RIGHT(backpack_magazines,1) != ']' OR RIGHT(handgun_items,1) != ']' OR RIGHT(primary_weapon_items,1) != ']' OR RIGHT(secondary_weapon_items,1) != ']' OR RIGHT(secondary_weapon_items,1) != ']' 

 

This will fix it for the future...
But the buggy players need to be deleted or handelt manually.

ALTER TABLE `player` CHANGE `loaded_magazines` `loaded_magazines` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `player` CHANGE `handgun_items` `handgun_items` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `player` CHANGE `primary_weapon_items` `primary_weapon_items` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `player` CHANGE `secondary_weapon_items` `secondary_weapon_items` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;


The biggest problem is the loaded_magazines column.

At least i can give my self the best answer^^

Edited by On4fox
2 people like this

Share this post


Link to post
Share on other sites
  • 0
On 20.12.2015 at 1:20 AM, On4fox said:

someone desided it would be a great idea to limit the chars in "some" rows to  255

That was me. It was obviously not enough. Good find! I will include it in the hotfix today.

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.