• 0
taikonaut

DB issues

Question

I got an Exile server running on my local machine, was quite happy with it and moved it to my remote server... here´s what I get in the ExtDB log. Any ideas?

[17:41:26:273134 +02:00] [Thread 62120] extDB2: Input from Server: 9:VERSION
[17:41:26:273134 +02:00] [Thread 62120] extDB2: Output to Server: 65
[17:41:26:273134 +02:00] [Thread 62120] extDB2: Input from Server: 9:ADD_DATABASE:exile
[17:41:26:273134 +02:00] [Thread 62120] extDB2: Database Type: MySQL
[17:41:26:273134 +02:00] [Thread 62120] extDB2: Database Session Pool Started
[17:41:26:273134 +02:00] [Thread 62120] extDB2: Output to Server: [1]
[17:41:26:273134 +02:00] [Thread 62120] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:437703:exile
[17:41:26:285135 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\exile\@exile_server_altis\extDB\sql_custom_v2\exile.ini
[17:41:26:285135 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[17:41:26:285135 +02:00] [Thread 62120] extDB2: Output to Server: [1]
[17:41:26:285135 +02:00] [Thread 62120] extDB2: Input from Server: 9:TIME
[17:41:26:285135 +02:00] [Thread 62120] extDB2: Output to Server: [1,[2015, 11, 15, 16, 41]]
[17:41:26:285135 +02:00] [Thread 62120] extDB2: Input from Server: 9:LOCK
[17:41:26:285135 +02:00] [Thread 62120] extDB2: Output to Server: [1]
[17:41:33:014808 +02:00] [Thread 62120] extDB2: Input from Server: 0:437703:loadTerriotryIdPage:0:100
[17:41:33:014808 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadTerriotryIdPage:0:100
[17:41:33:014808 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile_altis.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: SELECT id FROM territory LIMIT ?,?
[17:41:33:014808 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:41:33:014808 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerriotryIdPage:0:100
[17:41:33:014808 +02:00] [Thread 62120] extDB2: Output to Server: [0,"Error Statement Exception"]
[17:42:31:153621 +02:00] [Thread 62120] extDB2: Input from Server: 0:437703:isKnownAccount:76561198005478133
[17:42:31:153621 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: isKnownAccount:76561198005478133
[17:42:31:153621 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile_altis.account' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END
[17:42:31:153621 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:42:31:153621 +02:00] [Thread 62120] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: isKnownAccount:76561198005478133
[17:42:31:153621 +02:00] [Thread 62120] extDB2: Output to Server: [0,"Error Statement Exception"]
[17:43:46:666172 +02:00] [Thread 62120] extDB2: Input from Server: 1:437703:endAccountSession:76561198005478133
[17:43:46:666172 +02:00] [Thread 62120] extDB2: Output to Server: 
[17:43:46:666172 +02:00] [Thread 24720] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: endAccountSession:76561198005478133
[17:43:46:666172 +02:00] [Thread 24720] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile_altis.account' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE account SET last_disconnect_at = NOW() WHERE uid = ?
[17:43:46:666172 +02:00] [Thread 62120] extDB2: Input from Server: 1:437703:updatePlayer:Alex:1:0:0:100:100:0:1:0:0:0:0:0:0:13237.161133:11705.337891:-0.000514984:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[17:43:46:666172 +02:00] [Thread 24720] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:43:46:666172 +02:00] [Thread 62120] extDB2: Output to Server: 
[17:43:46:666172 +02:00] [Thread 24720] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: endAccountSession:76561198005478133
[17:43:46:666172 +02:00] [Thread 15876] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: updatePlayer:Alex:1:0:0:100:100:0:1:0:0:0:0:0:0:13237.161133:11705.337891:-0.000514984:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[17:43:46:666172 +02:00] [Thread 15876] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile_altis.player' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE player SET name = ?, is_alive = ?, damage  = ?, fatigue = ?, hunger = ?, thirst = ?, alcohol = ?, oxygen_remaining  = ?, bleeding_remaining = ?, hitpoint_head = ?, hitpoint_body = ?, hitpoint_hands = ?, hitpoint_legs = ?, 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 = ?
[17:43:46:666172 +02:00] [Thread 15876] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:43:46:666172 +02:00] [Thread 15876] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:Alex:1:0:0:100:100:0:1:0:0:0:0:0:0:13237.161133:11705.337891:-0.000514984:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[17:43:57:451250 +02:00] [Thread 62120] extDB2: Stopping ...
 

Share this post


Link to post
Share on other sites

0 answers to this question

There have been no answers to this question yet

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.