• 0
Sign in to follow this  
Followers 0
Rebellion

Error in Database

Question

Since the last Arma 3 update (Update to Game Version:1.76.142872), I've been getting the following error on my server:

12:03:27 "ExileServer - Database Error: Error Statement Exception"
12:03:27 Error in expression <umberOfVehicles - 1 do
{
((_vehicleIDs select _i)select 0) call ExileServer_obj>
12:03:27   Error position: <select _i)select 0) call ExileServer_obj>
12:03:27   Error Generic error in expression
12:03:27 File exile_server\code\ExileServer_world_loadAllDatabaseVehicles.sqf, line 25

Would anyone know the reason for this, or maybe able to point me to the solution. This error was not occuring before this latest update.

Cheers.

 

*EDIT* Noticed the 1.0.3e update to include support for malden. Hopefully that will sort out the territory_id error I'm getting in my db.

Edited by Rebellion

Share this post


Link to post
Share on other sites

1 answer to this question

  • 0

Noticed this in my extDb logs:

[12:21:51:920039 +01:00] [Thread 4516] extDB2: Database Type: MySQL
[12:21:51:921538 +01:00] [Thread 4516] extDB2: Database Session Pool Started
[12:21:51:923996 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\Servers\ArmaExile2\@exileserver\extDB\sql_custom_v2\exile.ini
[12:21:51:924179 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[12:21:52:011797 +01:00] [Thread 496] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'territory_id' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[12:21:52:011841 +01:00] [Thread 496] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:21:52:011855 +01:00] [Thread 496] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldVehicles:3
[12:21:52:017689 +01:00] [Thread 7896] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'territory_id' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM vehicle WHERE territory_id IS NULL AND deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[12:21:52:017725 +01:00] [Thread 7896] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:21:52:017739 +01:00] [Thread 7896] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3
[12:21:52:433635 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'territory_id' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,?
[12:21:52:433672 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:21:52:433687 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadVehicleIdPage:0:100

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.