Micro

New Exile SQL broken?

19 posts in this topic

Spoiler

[18:27:07:929908 --4:00] [Thread 51520] extDB2: Database Type: MySQL
[18:27:07:942909 --4:00] [Thread 51520] extDB2: Database Session Pool Started
[18:27:07:944909 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Users\tnaserver.WIN-191LIK3N8NL\Desktop\micro 9.8\@ExileServer\extDB\sql_custom_v2\exile.ini
[18:27:07:944909 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[18:27:08:115919 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [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));
[18:27:08:115919 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:124919 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: setAbandonedUnlocked:2
[18:27:08:124919 --4:00] [Thread 18460] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.construction' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE construction SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[18:27:08:124919 --4:00] [Thread 18460] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:125919 --4:00] [Thread 136740] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE container SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[18:27:08:125919 --4:00] [Thread 136740] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:134920 --4:00] [Thread 18460] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldConstructions:2
[18:27:08:134920 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[18:27:08:134920 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:135920 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[18:27:08:135920 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:144921 --4:00] [Thread 136740] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldContainers:10
[18:27:08:144921 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:0
[18:27:08:144921 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:0
[18:27:08:144921 --4:00] [Thread 18460] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.construction' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
[18:27:08:144921 --4:00] [Thread 18460] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:144921 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.clan' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: SELECT id FROM clan LIMIT ?,?
[18:27:08:144921 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:145921 --4:00] [Thread 146412] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[18:27:08:145921 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.territory' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[18:27:08:145921 --4:00] [Thread 146412] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:145921 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:145921 --4:00] [Thread 18460] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:0
[18:27:08:146921 --4:00] [Thread 21584] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.vehicle' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[18:27:08:146921 --4:00] [Thread 21584] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:146921 --4:00] [Thread 136740] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.vehicle' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[18:27:08:146921 --4:00] [Thread 136740] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:156921 --4:00] [Thread 146412] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteUnpaidTerritories:7
[18:27:08:156921 --4:00] [Thread 155816] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteBaseFlagStolen:3
[18:27:08:156921 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadClansIdPage:0:100
[18:27:08:156921 --4:00] [Thread 21584] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldVehicles:3
[18:27:08:156921 --4:00] [Thread 136740] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:0
[18:27:08:156921 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.container' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [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
[18:27:08:156921 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:27:08:156921 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: addAbandonedSafes:7
[18:38:02:643356 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.account' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END
[18:38:02:643356 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:38:02:643356 --4:00] [Thread 51520] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: isKnownAccount:76561198015381740
[18:39:54:293742 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.account' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE account SET last_disconnect_at = NOW() WHERE uid = ?
[18:39:54:293742 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:39:54:293742 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: endAccountSession:76561198015381740
[18:39:54:294742 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Table 'extest.player' doesn't exist    [mysql_stmt_errno]: 1146    [mysql_stmt_sqlstate]: 42S02    [statemnt]: UPDATE player SET name = ?, damage  = ?, hunger = ?, thirst = ?, alcohol = ?, oxygen_remaining  = ?, bleeding_remaining = ?, hitpoints = ?, direction = ?, position_x = ?, position_y = ?, position_z = ?, assigned_items = ?, backpack = ?, backpack_items = ?, backpack_magazines = ?, backpack_weapons = ?, current_weapon = ?, goggles = ?, handgun_items = ?, handgun_weapon = ?, headgear = ?, binocular = ?, loaded_magazines = ?, primary_weapon = ?, primary_weapon_items = ?, secondary_weapon = ?, secondary_weapon_items = ?, uniform = ?, uniform_items = ?, uniform_magazines = ?, uniform_weapons = ?, vest = ?, vest_items = ?, vest_magazines = ?, vest_weapons = ?, temperature = ?, wetness = ? WHERE id = ?
[18:39:54:295742 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[18:39:54:295742 --4:00] [Thread 17628] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: updatePlayer:{||TNA||} Micro:0:100:100:0:1:0:[]:0:13237.161133:11705.337891:-0.000514984:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Goggles_VR:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:0:0:-1
[18:42:44:422473 --4:00] [Thread 51520] extDB2: Stopping ...
 

A whole new server and it won't let anyone load in.  I used the current exile.sql. Do I need to update it as well?

 

Share this post


Link to post
Share on other sites

Make sure you have downloaded the latest version of @ExileServer, no problems with the .sql

Share this post


Link to post
Share on other sites
Advertisement

basically the same for me i get this error 

0:55:28 "ExileServer - Installed extDB2 version: 70"
 0:55:28 "ExileServer - MySQL connection error!"
 0:55:28 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong."
 0:55:28 "ExileServer - MySQL Error: Could not add database: [0,"Database Exception Error"]"
 0:55:28 "ExileServer - Server will shutdown now :("

then 

[00:55:28:280994 +02:00] [Thread 6496] extDB2: Database Type: MySQL
[00:55:28:325216 +02:00] [Thread 6496] extDB2: Database Exception Error: Connection attempt failed: Access denied for user 'ni952072_1_DB'@'46.251.234.18' (using password: YES)
[00:55:28:331291 +02:00] [Thread 6496] extDB2: Sending Shutdown to Armaserver

But it's not the first time i've got that problem this problem after an upgrade with nitrado

DAAAAAAAAMN i gonna be crazy

 

Share this post


Link to post
Share on other sites
6 minutes ago, mojitoboy said:

basically the same for me i get this error 

0:55:28 "ExileServer - Installed extDB2 version: 70"
 0:55:28 "ExileServer - MySQL connection error!"
 0:55:28 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong."
 0:55:28 "ExileServer - MySQL Error: Could not add database: [0,"Database Exception Error"]"
 0:55:28 "ExileServer - Server will shutdown now :("

then 

[00:55:28:280994 +02:00] [Thread 6496] extDB2: Database Type: MySQL
[00:55:28:325216 +02:00] [Thread 6496] extDB2: Database Exception Error: Connection attempt failed: Access denied for user 'ni952072_1_DB'@'46.251.234.18' (using password: YES)
[00:55:28:331291 +02:00] [Thread 6496] extDB2: Sending Shutdown to Armaserver

But it's not the first time i've got that problem this problem after an upgrade with nitrado

DAAAAAAAAMN i gonna be crazy

 

[00:55:28:325216 +02:00] [Thread 6496] extDB2: Database Exception Error: Connection attempt failed: Access denied for user 'ni952072_1_DB'@'46.251.234.18' (using password: YES)

Access denied for user 'ni952072_1_DB'

Make sure that user exist, and the password is correct.

Share this post


Link to post
Share on other sites

yep it's sure i do use it since a while but all the time after an update it's the same fu******* problem that's why i quit Nitrado 

 

Share this post


Link to post
Share on other sites
8 minutes ago, mojitoboy said:

yep it's sure i do use it since a while but all the time after an update it's the same fu******* problem that's why i quit Nitrado 

 

You can't really blame a GSP for your problems, if its your problem its your problem, GSP's give you servers that are 100% working (if they are 100% a legitimate buisness)

Share this post


Link to post
Share on other sites

true but why after un update it's always the same ?? i send a ticket they erease my DB put an empty one and done but i'ts a wipe all the time then...

 

Share this post


Link to post
Share on other sites

i just do not understand that.... Maybe i do bad all the time but i do it for other server owner who get a dedicated from OVH or other and it's not a problem... 

Share this post


Link to post
Share on other sites

So i found the problem with the GSP staff !!!

They switch 1 folder in the main arma 3 directory...

 

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

  • Recently Browsing   0 members

    No registered users viewing this page.