Sign in to follow this  
Followers 0
Dick Kickem

[SOLVED] On Non-saving Database

9 posts in this topic

Posted (edited)

Good day.

I have a Namalsk server running, and everything that I've tested works, the mods, the scripts, and the AI, but the server does not save character data, so when a person rejoins, it kicks them back to the lobby and refuses to create a character.  I've talked with the Server Provider I use and they pointed me here.

Here is the error I'm getting:

Quote

8:37:28 "ExileServer - Database Error: Error Statement Exception"
 8:37:28 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0>
 8:37:28   Error position: <select 0>
 8:37:28   Error Generic error in expression
 8:37:28 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27
 8:37:28 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0>
 8:37:28   Error position: <select 0>
 8:37:28   Error Generic error in expression
 8:37:28 File exile_server\code\ExileServer_system_database_query_selectSingle.sqf, line 27

My ExtDB log (whole thing, with error pointed out):

Spoiler

extDB2: Version: 70
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15


extDB2: Found extdb-conf.ini
extDB2: Detected 24 Cores, Setting up 6 Worker Threads


[08:35:12:940908 --4:00] [Thread 464] extDB2: Database Type: MySQL
[08:35:12:954439 --4:00] [Thread 464] extDB2: Database Session Pool Started
[08:35:12:957254 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\TCAFiles\Users\RyanB1\116\@ExileServer\extDB\sql_custom_v2\exile.ini
[08:35:12:957510 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[08:35:13:135491 --4:00] [Thread 804] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'abandoned' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[08:35:13:135548 --4:00] [Thread 804] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[08:35:13:145226 --4:00] [Thread 804] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: addAbandonedSafes:7
[08:37:28:616422 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.temperature' 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.id, c.name, p.temperature, p.wetness 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 = ?
[08:37:28:616492 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[08:37:28:616515 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561197970411229
[08:38:08:874947 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[08:38:08:875030 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[08:38:08:875053 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:tireless:0:100:100:0:1:0:[]:0:13237.161133:11705.337891:48.347507:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[11:10:29:927781 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:10:29:928058 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:10:29:928086 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:100:100: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]]:42.118217:5306.571289:11244.0878906:1000:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_Parachute:[]:[]:[]::G_Spectacles:["","","",""]::::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_BBQSandwich",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_CanOpener",1]]:[]::[]:[]:[]:37:0:41
[11:10:59:685022 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:10:59:685108 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:10:59:685131 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:100:100: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]]:149.92424:5491.524414:11423.0898438:256.778503:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Tactical_Black:["","","",""]::::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_BBQSandwich",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_CanOpener",1]]:[]::[]:[]:[]:36.895325:0:41
[11:16:01:840381 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:16:01:840544 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:16:01:840573 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:94.0094223:90.813232: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]]:251.773804:4897.638184:10849.0283203:0.00109482:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Tactical_Black:["","","",""]::::[]::["","","",""]::["","","",""]:U_C_Poloshirt_blue:[]:[["Exile_Item_CanOpener",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_BBQSandwich",1],["Exile_Item_MountainDupe",1]]:[]::[]:[]:[]:36.990913:0:41
[11:20:25:687544 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.temperature' 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.id, c.name, p.temperature, p.wetness 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 = ?
[11:20:25:687628 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:20:25:687651 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561197983891785
[11:20:38:169461 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:20:38:169543 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:20:38:169565 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:88.169197:81.90239: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]]:211.583649:4824.834961:10847.258789:0.00140381:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:LMG_Zafir_F:G_Tactical_Black:["","","",""]::::[["LMG_Zafir_F","150Rnd_762x54_Box_Tracer",150,"LMG_Zafir_F"]]:LMG_Zafir_F:["","","",""]::["","","",""]:U_B_CombatUniform_mcam:[]:[["Exile_Item_MountainDupe",1],["Exile_Item_BBQSandwich",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_CanOpener",1]]:[]::[]:[]:[]:36.989624:0:41
[11:21:05:848371 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:21:05:848447 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:21:05:848469 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:bluebart:0:100:100:0:1:0:[]:0:13234.717773:11705.455078:48.818916:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[11:21:53:916243 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.temperature' 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.id, c.name, p.temperature, p.wetness 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 = ?
[11:21:53:916315 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:21:53:916337 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561197983891785
[11:22:33:983717 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:22:33:983797 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:22:33:983823 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:bluebart:0:100:100:0:1:0:[]:0:13223.492188:11705.513672:48.410236:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[11:25:39:695177 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:25:39:695266 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:25:39:695289 --4:00] [Thread 2916] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:82.345772:73.0161057: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]]:28.915585:4851.208496:10886.535156:0.298277:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","NVGoggles"]::[]:[]:[]:LMG_Zafir_F:G_Tactical_Black:["","","",""]::::[["LMG_Zafir_F","150Rnd_762x54_Box_Tracer",150,"LMG_Zafir_F"]]:LMG_Zafir_F:["","","",""]::["","","",""]:U_B_CombatUniform_mcam:[]:[["Exile_Item_MountainDupe",1],["Exile_Item_BBQSandwich",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_CanOpener",1]]:[]:V_PlateCarrierSpec_rgr:[]:[["150Rnd_762x54_Box_Tracer",150]]:[]:36.998684:0:41
[11:25:44:481284 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:25:44:481357 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:25:44:481380 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:82.345772:73.0161057: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]]:28.915585:4851.208496:10886.535156:0.298277:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","NVGoggles"]::[]:[]:[]:LMG_Zafir_F:G_Tactical_Black:["","","",""]::::[["LMG_Zafir_F","150Rnd_762x54_Box_Tracer",150,"LMG_Zafir_F"]]:LMG_Zafir_F:["","","",""]::["","","",""]:U_B_CombatUniform_mcam:[]:[["Exile_Item_MountainDupe",1],["Exile_Item_BBQSandwich",1],["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_CanOpener",1]]:[]:V_PlateCarrierSpec_rgr:[]:[["150Rnd_762x54_Box_Tracer",150]]:[]:36.998684:0:41
[11:30:49:132045 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.temperature' 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.id, c.name, p.temperature, p.wetness 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 = ?
[11:30:49:132115 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:30:49:132136 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561197983891785
[11:31:26:212682 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[11:31:26:212742 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:31:26:212760 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:bluebart:0:100:100:0:0:0:[]:0:13234.717773:11705.455078:47.947155:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[12:19:52:039476 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.temperature' 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.id, c.name, p.temperature, p.wetness 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 = ?
[12:19:52:039617 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:19:52:039641 --4:00] [Thread 464] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561197980076345
[12:20:26:281584 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'temperature' 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 = ?, temperature = ?, wetness = ? WHERE id = ?
[12:20:26:281671 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:20:26:281700 --4:00] [Thread 764] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Extreme:0:100:100:0:1:0:[]:0:13237.161133:11705.398438:48.301895:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Tactical_Black:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[12:35:28:620756 --4:00] [Thread 464] extDB2: Stopping ...

I'd like some help, and if anymore information is needed, please let me know.

Thanks.

Edited by Dick Kickem

Share this post


Link to post
Share on other sites

Unknown column 'p.temperature' in 'field list'  

 

You didn't run the SQL Statements to update your database when you upgrade ExileServer

Share this post


Link to post
Share on other sites
Advertisement
58 minutes ago, Torndeco said:

Unknown column 'p.temperature' in 'field list'  

 

You didn't run the SQL Statements to update your database when you upgrade ExileServer

Do I need to completely redo my database? How do I run the SQL Statements? I ran the upgradeexile.sqf file in the server's directory a few hours ago, and it had this in it:

Quote

ALTER TABLE container ADD `abandoned` DATETIME DEFAULT NULL;
ALTER TABLE vehicle ADD `vehicle_texture` text NOT NULL;
ALTER TABLE `player` ADD `temperature` DOUBLE NOT NULL DEFAULT '37' AFTER `alcohol`, ADD `wetness` DOUBLE UNSIGNED NOT NULL DEFAULT '0' AFTER `temperature`;

UPDATE player SET temperature = 37;
UPDATE player SET wetness = 0;
 

Could this fix it?

Share this post


Link to post
Share on other sites

that's one part of the update yes. but also make sure you have the newest exile.ini and if you override the cfgnetworkmessages, you need to update that

Share this post


Link to post
Share on other sites
23 minutes ago, DirtySanchez said:

that's one part of the update yes. but also make sure you have the newest exile.ini and if you override the cfgnetworkmessages, you need to update that

Thanks! I got it working now. :D

Share this post


Link to post
Share on other sites
On 18.03.2016 at 10:40 AM, DirtySanchez said:

np bud, glad to help

Hi! I have the same problem. How can I override cfgnetworkmessages?

Share this post


Link to post
Share on other sites
5 hours ago, SAYREXX said:

Hi! I have the same problem. How can I override cfgnetworkmessages?

cfgnetworkmessages just add it to the config.cpp in the mission file

class cfgNetworkMessages  {

};

1 person likes this

Share this post


Link to post
Share on other sites
1 hour ago, DirtySanchez said:

cfgnetworkmessages просто добавить его к config.cpp в файле миссии

класса cfgNetworkMessages {

};

Thank you!

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.