• 0
Sign in to follow this  
Followers 0
JerryAtricks

0.9.8 - Waiting for Server to Load...

Question

Posted (edited)

 

I seem to be having a database issue. If I run a clean install of the database I can load into my server with no problems. However, if I reimport data from a previous save I get stuck at the 'Waiting for server to load' screen. 

I am getting this error in my server.rpt:

Spoiler

"ExileServer - Loading territories from database..."
"ExileServer - Database Error: Error Statement Exception"
Error in expression <OfTerritories - 1 do 
{
((_territoryIDs select _i)select 0) call ExileServer_sys>
Error position: <select _i)select 0) call ExileServer_sys>
Error Generic error in expression
File exile_server\code\ExileServer_world_loadAllTerritories.sqf, line 26

Here is ExileServer_world_loadAllTerritories.sqf:

Spoiler

1 /**
 2 * ExileServer_world_loadAllTerritories
 3 *
 4 * Exile Mod
 5 * www.exilemod.com
 6 * © 2015 Exile Mod Team
 7 *
 8 * This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. 
 9 * To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/.
 10 */
 11
12 private["_continueLoading","_page","_pageSize","_territoryIDs","_numberOfTerritories","_i"];
13 ExileLocations = [];
14 "Loading territories from database..." call ExileServer_util_log;
15 _continueLoading = true;
16 _page = 0;
17 _pageSize = 100;
18 while {_continueLoading} do 
19 {
20   _territoryIDs = format ["loadTerriotryIdPage:%1:%2", _page * _pageSize, _pageSize] call ExileServer_system_database_query_selectFull;
21  _numberOfTerritories = count _territoryIDs;
22   if (_numberOfTerritories > 0) then 
23   {
24       for "_i" from 0 to _numberOfTerritories - 1 do 
25       {
26           ((_territoryIDs select _i)select 0) call ExileServer_system_territory_database_load;
27       };
28   };
29   _page = _page + 1;
30   if (_numberOfTerritories < 100) then
31   {
32       _continueLoading = false;
33   };
34 };
35 "Done loading territories!" call ExileServer_util_log;
36 true

 

extDB.log

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


[22:13:22:560120 --4:00] [Thread 9804] extDB2: Database Type: MySQL
[22:13:22:568666 --4:00] [Thread 9804] extDB2: Database Session Pool Started
[22:13:22:572677 --4:00] [Thread 9804] extDB2: SQL_CUSTOM_V2: Loading Template Filename: G:\Games\Steam\SteamApps\common\Arma3Server\Server\@ExileServer\extDB\sql_custom_v2\exile.ini
[22:13:22:572862 --4:00] [Thread 9804] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[22:13:22:576721 --4:00] [Thread 9804] extDB2: SQL_CUSTOM_V2: Loading Template Filename: G:\Games\Steam\SteamApps\common\Arma3Server\Server\@ExileServer\extDB\sql_custom_v2\avs.ini
[22:13:22:576748 --4:00] [Thread 9804] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[22:13:23:087590 --4:00] [Thread 3932] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[22:13:23:087651 --4:00] [Thread 3932] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:088665 --4:00] [Thread 3932] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteUnpaidTerritories:7
[22:13:23:088954 --4:00] [Thread 7348] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'field list'    [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
[22:13:23:088993 --4:00] [Thread 7348] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:091405 --4:00] [Thread 7348] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldContainers:10
[22:13:23:092320 --4:00] [Thread 8932] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'field list'    [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
[22:13:23:092362 --4:00] [Thread 8932] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:093035 --4:00] [Thread 9964] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error    [mysql_stmt_error]: Unknown column 'deleted_at' in 'field list'    [mysql_stmt_errno]: 1054    [mysql_stmt_sqlstate]: 42S22    [statemnt]: UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[22:13:23:093082 --4:00] [Thread 9964] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:094512 --4:00] [Thread 8932] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldConstructions:2
[22:13:23:094522 --4:00] [Thread 9964] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldVehicles:3
[22:13:23:095557 --4:00] [Thread 9956] 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)
[22:13:23:095603 --4:00] [Thread 9956] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:097751 --4:00] [Thread 9956] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:0
[22:13:23:098401 --4:00] [Thread 9804] 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 ?,?
[22:13:23:098441 --4:00] [Thread 9804] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:098470 --4:00] [Thread 9804] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadTerriotryIdPage:0:100
[22:13:23:098836 --4:00] [Thread 3932] 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
[22:13:23:098874 --4:00] [Thread 3932] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:098876 --4:00] [Thread 7348] 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
[22:13:23:098895 --4:00] [Thread 3932] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:0
[22:13:23:098927 --4:00] [Thread 7348] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:098967 --4:00] [Thread 7348] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:0
[22:13:23:098996 --4:00] [Thread 8728] 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)
[22:13:23:099040 --4:00] [Thread 8728] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[22:13:23:099067 --4:00] [Thread 8728] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:0
 

Any ideas as to why it doesn't like prior data?

Disclaimer:

While I am getting better at figuring out sqf errors, I am not yet versed in database-ese. The problem might be right there but I won't see it. =\

Edited by JerryAtricks

Share this post


Link to post
Share on other sites

2 answers to this question

  • 0

Make sure you import the "upgrade-0.9.60-to-0.9.80.sql" file into your database. And the following...

ALTER TABLE `container` ADD COLUMN `money` int(11) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `vehicle` ADD COLUMN `money` int(11) unsigned NOT NULL DEFAULT '0';

 

Share this post


Link to post
Share on other sites
  • 0
13 hours ago, Mr.Pig said:

Make sure you import the "upgrade-0.9.60-to-0.9.80.sql" file into your database. And the following...


ALTER TABLE `container` ADD COLUMN `money` int(11) unsigned NOT NULL DEFAULT '0';

ALTER TABLE `vehicle` ADD COLUMN `money` int(11) unsigned NOT NULL DEFAULT '0';

 

Eureka! 

I'm not sure if that worked or because I imported the data first and then upgraded the server this time but it's working now. Thanks a lot Mr.Pig! :rock:

 

Btw... where did you find that? That would have been so helpful to be included in a readme with the download. 

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.