• 0
Sign in to follow this  
Followers 0
Fendo

Database Error: Territories

Question

Have this problem. Try to replace the exile.ini but dont work for me. Its an new server so no problems at update.

Spoiler

 

21:24:59 "ExileServer - Initializing game world..."
21:24:59 "ExileServer - Loading territories from database..."
21:24:59 "ExileServer - Database Error: Error Statement Exception"
21:24:59 Error in expression <OfTerritories - 1 do
{
((_territoryIDs select _i)select 0) call ExileServer_sys>
21:24:59   Error position: <select _i)select 0) call ExileServer_sys>
21:24:59   Error Generic error in expression
21:24:59 File exile_server\code\ExileServer_world_loadAllTerritories.sqf, line 26


 

The extDB2 log
 

Spoiler

 

extDB2: Version: 69
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux 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


[21:24:59 +01:00] [Thread 32150] extDB2: Database Type: MySQL
[21:24:59 +01:00] [Thread 32150] extDB2: Database Session Pool Started
[21:24:59 +01:00] [Thread 32150] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/steam/arma3/@ExileServer/extDB/sql_custom_v2/exile.ini
[21:24:59 +01:00] [Thread 32150] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[21:24:59 +01:00] [Thread 32176] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM territory WHERE last_paid_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY))
[21:24:59 +01:00] [Thread 32176] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:24:59 +01:00] [Thread 32180] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM container WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) AND territory_id = NULL
[21:24:59 +01:00] [Thread 32180] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:24:59 +01:00] [Thread 32176] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:7
[21:24:59 +01:00] [Thread 32180] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:7
[21:24:59 +01:00] [Thread 32150] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: SELECT id FROM territory LIMIT ?,?
[21:24:59 +01:00] [Thread 32150] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:24:59 +01:00] [Thread 32150] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerriotryIdPage:0:100
[21:24:59 +01:00] [Thread 32178] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile.construction' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM construction WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) AND territory_id = NULL
[21:24:59 +01:00] [Thread 32178] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:24:59 +01:00] [Thread 32178] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:2
[21:24:59 +01:00] [Thread 32179] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'exile.vehicle' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM vehicle WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY))
[21:24:59 +01:00] [Thread 32179] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[21:24:59 +01:00] [Thread 32179] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3


 

Can someone help me?

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.