• 0
Guest Sphincter

mysql error need help plz

Question

OK so here's where i am in this mess i've made. finally got the server to run without crashing so thats a plus haha. then i was having issues getting access to a Bambi character but i fixed that as well. now the real problem seems to happen when i log out after getting a Bambi on the ground and try to log back in. It seems to time out while requesting the character that i just made. so from what i gather, the client pings my server to get the character that is owned by that account, server says no.... any help would be fantastic. here is my DB log file

 

Quote

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


[10:54:22:870790 +00:-1] [Thread 820] extDB2: Database Type: MySQL
[10:54:22:872682 +00:-1] [Thread 820] extDB2: Database Session Pool Started
[10:54:22:874651 +00:-1] [Thread 820] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Program Files (x86)\Steam\steamapps\common\Arma 3 Server\@ExileServer\extDB\sql_custom_v2\exile.ini
[10:54:22:874801 +00:-1] [Thread 820] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[10:54:23:154031 +00:-1] [Thread 2152] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_updated_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM container WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id = NULL
[10:54:23:154110 +00:-1] [Thread 2152] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:54:23:154142 +00:-1] [Thread 2152] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:7
[10:54:23:154538 +00:-1] [Thread 9796] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_paid_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[10:54:23:154574 +00:-1] [Thread 9796] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:54:23:154603 +00:-1] [Thread 9796] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:7
[10:54:23:155095 +00:-1] [Thread 9392] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_updated_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM vehicle WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[10:54:23:155151 +00:-1] [Thread 9392] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:54:23:155187 +00:-1] [Thread 9392] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3
[10:54:23:155482 +00:-1] [Thread 6212] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_updated_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM construction WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id = NULL
[10:54:23:155512 +00:-1] [Thread 6212] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:54:23:155539 +00:-1] [Thread 6212] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:2
[10:57:26:144226 +00:-1] [Thread 820] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.hitpoints' 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.name 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 = ?
[10:57:26:144357 +00:-1] [Thread 820] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:57:26:144390 +00:-1] [Thread 820] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561198075534429
[10:58:06:233020 +00:-1] [Thread 9392] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'hitpoints' 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 = ? WHERE id = ?
[10:58:06:233081 +00:-1] [Thread 9392] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[10:58:06:233104 +00:-1] [Thread 9392] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:0.001297:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
 

 

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

You are running an old version of exile.ini or your exile DB is not updated.

Share this post


Link to post
Share on other sites
  • 0
On 1/12/2016 at 0:36 PM, GR8 said:

You are running an old version of exile.ini or your exile DB is not updated.

well i have updated to the latest release and still cant seem to download my character. here is my log report.

 

Quote

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


[16:28:09:747567 +00:-1] [Thread 3204] extDB2: Database Type: MySQL
[16:28:09:749542 +00:-1] [Thread 3204] extDB2: Database Session Pool Started
[16:28:09:751576 +00:-1] [Thread 3204] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Program Files (x86)\Steam\steamapps\common\Arma 3 Server\@ExileServer\extDB\sql_custom_v2\exile.ini
[16:28:09:751745 +00:-1] [Thread 3204] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[16:28:09:901773 +00:-1] [Thread 3484] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_paid_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[16:28:09:901818 +00:-1] [Thread 3484] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:28:09:902298 +00:-1] [Thread 3484] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:7
[16:28:09:902619 +00:-1] [Thread 7468] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_updated_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM container WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id = NULL
[16:28:09:902658 +00:-1] [Thread 7468] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:28:09:902705 +00:-1] [Thread 7232] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_updated_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM construction WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id = NULL
[16:28:09:902745 +00:-1] [Thread 7232] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:28:09:914140 +00:-1] [Thread 7468] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:7
[16:28:09:914149 +00:-1] [Thread 7232] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:2
[16:28:09:914362 +00:-1] [Thread 7000] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'last_updated_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM vehicle WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[16:28:09:914398 +00:-1] [Thread 7000] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:28:09:914419 +00:-1] [Thread 7000] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3
[16:29:04:494542 +00:-1] [Thread 7000] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'hitpoints' 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 = ? WHERE id = ?
[16:29:04:494687 +00:-1] [Thread 7000] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:29:04:494720 +00:-1] [Thread 7000] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Dirty_Taint: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]]:287.700195:9003.655273:18026.386719:999.999939:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]:B_Parachute:[]:[]:[]::G_Combat:["","","",""]::Exile_Headgear_SantaHat::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1]]:[]::[]:[]:[]:4
[16:29:55:347410 +00:-1] [Thread 7232] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'hitpoints' 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 = ? WHERE id = ?
[16:29:55:347466 +00:-1] [Thread 7232] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:29:55:347488 +00:-1] [Thread 7232] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Dirty_Taint: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]]:276.301788:8735.558594:18155.0859375:0.00151062:["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio"]::[]:[]:[]:::["","","",""]::Exile_Headgear_SantaHat::[]::["","","",""]::["","","",""]:Exile_Uniform_BambiOverall:[]:[["Exile_Item_PlasticBottleFreshWater",1]]:[]::[]:[]:[]:4
[16:30:11:912486 +00:-1] [Thread 3204] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'p.hitpoints' 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.name 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:30:11:912546 +00:-1] [Thread 3204] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[16:30:11:912568 +00:-1] [Thread 3204] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadPlayer:76561198075534429
[16:30:52:906662 +00:-1] [Thread 3204] extDB2: Stopping ...
 

 

Share this post


Link to post
Share on other sites
  • 0
 Unknown column 'p.hitpoints' in 'field list'    

This means your DB is outdated.

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.