• 0
Sign in to follow this  
Followers 0
FragZ

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

Question

Posted (edited)

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

Share this post


Link to post
Share on other sites

8 answers to this question

  • 0

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 ...

 

 

Share this post


Link to post
Share on other sites
Advertisement
  • 0
[mysql_stmt_error]: Unknown column 'abandoned'

problem is that you have not update the mysql db

Share this post


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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

Posted (edited)

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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0
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.

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.