Sign in to follow this  
Followers 0
Mraweshumsauce

Database Issue breaking at territory

1 post in this topic

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


[19:29:21:927811 --6:00] [Thread 17672] extDB2: Database Type: MySQL
[19:29:21:931352 --6:00] [Thread 17672] extDB2: Database Session Pool Started
[19:29:21:933762 --6:00] [Thread 17672] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Users\SMSowner1\Desktop\arma3\Server\@exileserver\extDB\sql_custom_v2\exile.ini
[19:29:21:934027 --6:00] [Thread 17672] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[19:29:22:774978 --6:00] [Thread 13276] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'container.territory_id' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE (SELECT flag_stolen_at from territory WHERE territory.id=container.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY));
[19:29:22:775037 --6:00] [Thread 13276] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:785739 --6:00] [Thread 13276] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: setAbandonedUnlocked:2
[19:29:22:786086 --6:00] [Thread 9872] 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]: UPDATE construction SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL
[19:29:22:786137 --6:00] [Thread 9872] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:786194 --6:00] [Thread 12184] 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]: UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
[19:29:22:786245 --6:00] [Thread 12184] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:787253 --6:00] [Thread 9872] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldConstructions:2
[19:29:22:787278 --6:00] [Thread 12184] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteUnpaidTerritories:7
[19:29:22:787670 --6:00] [Thread 14548] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[19:29:22:787675 --6:00] [Thread 19848] 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]: UPDATE container SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL
[19:29:22:787723 --6:00] [Thread 14548] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:787725 --6:00] [Thread 3148] 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]: UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
[19:29:22:787761 --6:00] [Thread 19848] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:787897 --6:00] [Thread 3148] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:798344 --6:00] [Thread 14548] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:3
[19:29:22:798361 --6:00] [Thread 19848] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldContainers:10
[19:29:22:798373 --6:00] [Thread 3148] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldVehicles:3
[19:29:22:798582 --6:00] [Thread 9872] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[19:29:22:798652 --6:00] [Thread 9872] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:798667 --6:00] [Thread 13276] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[19:29:22:798725 --6:00] [Thread 13276] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:810432 --6:00] [Thread 12184] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[19:29:22:810489 --6:00] [Thread 12184] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:821829 --6:00] [Thread 13276] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:3
[19:29:22:821901 --6:00] [Thread 9872] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:3
[19:29:22:821917 --6:00] [Thread 12184] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3
[19:29:22:822111 --6:00] [Thread 19848] 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]: UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND class = "Exile_Container_Safe" AND territory_id IS NULL
[19:29:22:822157 --6:00] [Thread 19848] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:822177 --6:00] [Thread 19848] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: addAbandonedSafes:7
[19:29:22:858007 --6:00] [Thread 17672] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'where clause'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,?
[19:29:22:858055 --6:00] [Thread 17672] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[19:29:22:858076 --6:00] [Thread 17672] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerriotryIdPage:0:100
[19:30:19:542122 --6:00] [Thread 17672] extDB2: Stopping ...
 

Server works fine, except this.

Edited by Mraweshumsauce

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.