Database Issue breaking at territory

[Mraweshumsauce 0]

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 January 29, 2017 by Mraweshumsauce