[SOLVED] [New update 0.9.6] Server cannot load player - Black screen then kick (sigh)

[FragZ 32]

I can create new players just fine or create a player if I delete their entry in the database, but upon relogging or death the said player gets black screened.

I have updated my exile.ini file, I also updated Exile_server.pbo


Anybody able to help me out? I am not home but will be in less than an hour...

 

 

UPDATE: Fixed my issue by double checking all files from Exile_client.pbo, Exile_server.pbo that were modified on our server and re made everything

Edited March 8, 2016 by FragZ

[FragZ 32]

Bump

[[VNM] cobra4v320 25]

I am having this exact same issue, here is what the db log is showing for me.
 

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 8 Cores, Setting up 6 Worker Threads


[15:44:28:953547 --7:00] [Thread 3944] extDB2: Database Type: MySQL
[15:44:28:954547 --7:00] [Thread 3944] extDB2: Database Session Pool Started
[15:44:28:956547 --7:00] [Thread 3944] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\bluefang\servers\server12760\@exileserver\extDB\sql_custom_v2\exile.ini
[15:44:28:956547 --7:00] [Thread 3944] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[15:44:35:324911 --7:00] [Thread 22368] 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
[15:44:35:324911 --7:00] [Thread 22368] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:44:35:325911 --7:00] [Thread 22368] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: addAbandonedSafes:7
[15:44:48:172646 --7:00] [Thread 26396] 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 = ?
[15:44:48:172646 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:44:48:172646 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320: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]]:251.198761:6001.46875:5404.802246:1500:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_Parachute:[]:[]:[]:::["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:64
[15:49:56:552285 --7:00] [Thread 26396] 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 = ?
[15:49:56:552285 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:49:56:552285 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320:0:94.255669:91.233452: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]]:213.65979:7052.0683594:5816.654297:0.0014267:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[]:[]::[]:[]:[]:36.942825:0.105765:64
[15:54:57:171479 --7:00] [Thread 26396] 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 = ?
[15:54:57:171479 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:54:57:171479 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320:0.015748:88.482002:82.430733:0:1:0:[["face_hub",0.015748],["neck",0.015748],["head",0.015748],["pelvis",0.015748],["spine1",0.015748],["spine2",0.015748],["spine3",0.015748],["body",0.015748],["arms",0.015748],["hands",0.015748],["legs",0.015748]]:231.989975:7006.736816:5764.663574:0.00143814:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[]:[]::[]:[]:[]:36.89378:0.749902:64
[15:59:57:676667 --7:00] [Thread 26396] 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 = ?
[15:59:57:676667 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:59:57:676667 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320:0.015748:82.841454:73.891548:0:1:0:[["face_hub",0.015748],["neck",0.015748],["head",0.015748],["pelvis",0.015748],["spine1",0.015748],["spine2",0.015748],["spine3",0.015748],["body",0.015748],["arms",0.015748],["hands",0.015748],["legs",0.015748]]:3.597337:7041.45752:5804.373535:14.0270462:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_OutdoorPack_blu:[]:[]:[]::G_Bandanna_beast:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[]:[]::[]:[]:[]:36.628223:0.965213:64
[16:04:09:392064 --7:00] [Thread 26060] 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 = ?
[16:04:09:392064 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:04:09:392064 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320: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]]:14.85333:4500.0742188:10056.541992:1500:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_Parachute:[]:[]:[]::G_Spectacles:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:65
[16:05:03:331149 --7:00] [Thread 26060] 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 = ?
[16:05:03:331149 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:05:03:331149 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320:0:99.554932:99.329361: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]]:158.840714:4518.5625:9915.936523:1003.933167:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:65
[16:06:57:654688 --7:00] [Thread 13780] 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 = ?
[16:06:57:654688 --7:00] [Thread 13780] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:06:57:654688 --7:00] [Thread 13780] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320: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]]:3.679905:5138.825684:9960.412109:1500:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_Parachute:[]:[]:[]:::["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:66
[16:09:38:949914 --7:00] [Thread 26060] 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 = ?
[16:09:38:949914 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:09:38:949914 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320:1:97.162399:95.742363:0:1:176.0600128:[["face_hub",1],["neck",1],["head",1],["pelvis",1],["spine1",1],["spine2",1],["spine3",1],["body",1],["arms",1],["hands",1],["legs",1]]:104.436096:4651.674805:8143.80127:-0.00892639:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:66
[16:09:46:218330 --7:00] [Thread 26060] 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 = ?
[16:09:46:218330 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:09:46:218330 --7:00] [Thread 26060] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320: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]]:168.648895:4811.188965:9891.46875:1500:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_Parachute:[]:[]:[]::G_Sport_Blackred:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:67
[16:10:49:529951 --7:00] [Thread 26396] 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 = ?
[16:10:49:529951 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:10:49:530951 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:cobra4v320: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]]:161.403061:4856.55957:9238.333984:0.00173187:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::H_Watchcap_blk::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1],["Exile_Item_EMRE",1]]:[]::[]:[]:[]:37:0:67
[16:11:10:291138 --7:00] [Thread 3944] 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 = ?
[16:11:10:291138 --7:00] [Thread 3944] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:11:10:291138 --7:00] [Thread 3944] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561198003525748
[16:11:50:489437 --7:00] [Thread 26396] 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 = ?
[16:11:50:489437 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:11:50:489437 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:50.109642:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[16:13:17:542417 --7:00] [Thread 3944] 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 = ?
[16:13:17:542417 --7:00] [Thread 3944] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:13:17:542417 --7:00] [Thread 3944] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561198003525748
[16:13:57:725715 --7:00] [Thread 26396] 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 = ?
[16:13:57:725715 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:13:57:725715 --7:00] [Thread 26396] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer::0:100:100:0:1:0:[]:0:13235.357422:11703.189453:48.284912:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Bandanna_beast:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[16:17:35:591176 --7:00] [Thread 3944] extDB2: Stopping ...

 

 

[s3mt3x 0]

[mysql_stmt_error]: Unknown column 'abandoned'

problem is that you have not update the mysql db

[[VNM] cobra4v320 25]

11 minutes ago, s3mt3x said:

[mysql_stmt_error]: Unknown column 'abandoned'

problem is that you have not update the mysql db

MySQL is all new to me, can you elaborate further? I am currently accessing the db through navicat, would I update using upgrade-0.9.41-to-0.9.60.sql file?

[wasti 96]

Yes you can copy and paste whats inside of the upgrage.sql file into a new query window. If sql complains about safe mode stuff, simply add

SET SQL_SAFE_UPDATES = 0;

at the start (top) of the query

[FragZ 32]

45 minutes ago, s3mt3x said:

[mysql_stmt_error]: Unknown column 'abandoned'

problem is that you have not update the mysql db

This is however not my problem. I have update the database and my tables are in.

Edited March 8, 2016 by FragZ

[FragZ 32]

Update: Fixed my problem. Seems like I had a file somewhere that was modified.

[[VNM] cobra4v320 25]

1 hour ago, wasti said:

Yes you can copy and paste whats inside of the upgrage.sql file into a new query window. If sql complains about safe mode stuff, simply add

SET SQL_SAFE_UPDATES = 0;

at the start (top) of the query

Thanks, that did the trick.