Gr8z / ExileMod

ExileMod For Arma 3
2 stars 2 forks source link

need sql #54

Closed majussiani closed 7 years ago

majussiani commented 7 years ago

freeze in spawn http://prntscr.com/d555f4

[13:20:39:373412 --2:00] [Thread 1520] extDB2: Database Type: MySQL [13:20:39:374912 --2:00] [Thread 1520] extDB2: Database Session Pool Started [13:20:39:376657 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\Servers\Arma_3\Exile_TESTE\@ExileServer\extDB\sql_custom_v2\exile.ini [13:20:39:376812 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [13:20:39:550416 --2:00] [Thread 4080] 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) [13:20:39:550459 --2:00] [Thread 4080] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [13:20:39:550472 --2:00] [Thread 4080] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3 [13:20:39:551060 --2:00] [Thread 7452] 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 [13:20:39:551084 --2:00] [Thread 7452] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [13:20:39:551093 --2:00] [Thread 7452] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldVehicles:3 [13:20:39:557994 --2:00] [Thread 1520] 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, class FROM vehicle WHERE territory_id = ? [13:20:39:558082 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [13:20:39:558106 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerritoryVehicles:37 [13:20:39:562192 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'texture' in 'field list' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id,class,account_uid,spawned_at,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,is_locked,pin_code,territory_id,deleted_at,damage,texture FROM construction WHERE id = ? [13:20:39:562259 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [13:20:39:562274 --2:00] [Thread 1520] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadConstruction:3999 [13:53:42:635508 --2:00] [Thread 1520] extDB2: Stopping ...

Gr8z commented 7 years ago

Added MySQL Dump in 6e91e65eada49a8c8b604e937657605e0af2d8fd