[SOLVED] On Non-saving Database

[Dick Kickem 2]

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 March 21, 2016 by Dick Kickem

[Torndeco 233]

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

 

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

[Dick Kickem 2]

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?

[Dick Kickem 2]

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.

[SAYREXX 3]

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?

[SAYREXX 3]

1 hour ago, DirtySanchez said:

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

класса cfgNetworkMessages {

};

Thank you!