• 0
Sign in to follow this  
Followers 0
EduBR

stuck in "Waiting for server to load..." after update 0.9.4

Question

Hi guys,

I have a Linux server and having this problem to stuck in "Waiting for server to load..." after update 0.9.4 however, this happens after construction something. If I reset the database he returns to work. If I create a workbench he stay stuck in the screen...

 

301iu1j.jpg

 

This is the error I get in extdb logs

[01:33:52 --2:00] [Thread 24719] extDB2: Database Type: MySQL
[01:33:52 --2:00] [Thread 24719] extDB2: Database Session Pool Started
[01:33:52 --2:00] [Thread 24719] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/matrix/servidores/arma3/@exileserver/extDB/sql_custom_v2/exile.ini
[01:33:52 --2:00] [Thread 24719] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[01:34:03 --2:00] [Thread 24736] 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]: DELETE FROM territory WHERE last_paid_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY))
[01:34:03 --2:00] [Thread 24736] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:34:03 --2:00] [Thread 24736] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:7
[01:34:03 --2:00] [Thread 24736] 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]: DELETE FROM construction WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) AND territory_id = NULL
[01:34:03 --2:00] [Thread 24736] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:34:03 --2:00] [Thread 24737] 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]: DELETE FROM container WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY)) AND territory_id = NULL
[01:34:03 --2:00] [Thread 24737] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:34:03 --2:00] [Thread 24736] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldConstructions:2
[01:34:03 --2:00] [Thread 24737] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldContainers:7
[01:34:03 --2:00] [Thread 24736] 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]: DELETE FROM vehicle WHERE last_updated_at < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL ? DAY))
[01:34:03 --2:00] [Thread 24736] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[01:34:03 --2:00] [Thread 24736] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3
[01:42:30 --2:00] [Thread 24719] extDB2: Stopping ...

I reinstalled everything, and not solved.
Everything works normally up to build the first object, be it a workbench or wall. After build something the players can no join and is freeze on the screen "Waiting server to load".

My extdb version is: 69 (linux)
In the database table, I used the SQL version 0.9.35b version and updated segindo this tip: http://www.exilemod.com/topic/8280-sql-update-script-for-094/ because the sql file from version 0.9.4 simply does not work to create a new database.

Please help me, the server is offline since it was updated
Thank-you and sorry for my bad english!

 

Edited by EduBR

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

I have not found the solution to this problem. When instead, I change OS to windows. It was the only way I found however, even the windows OS still had a problem to stuck at the loading screen but with another message. The solution was to put the sql_mode = "" was the only thing that I not tried it on linux but as already formatted ... I'll leave it at that

Share this post


Link to post
Share on other sites
  • 0

The problem is your server is not connecting to the mysql database correctly. You need to make sure extDB is up to date and I would suggest using the old tbbmalloc.dll 

If you do not have the old tbbmalloc.dll message me and I can assist you with teamviewer and give you the old tbbmalloc.dll

Share this post


Link to post
Share on other sites
  • 0
On 12/28/2015 at 11:31 PM, crackerjack0903 said:

The problem is your server is not connecting to the mysql database correctly. You need to make sure extDB is up to date and I would suggest using the old tbbmalloc.dll 

If you do not have the old tbbmalloc.dll message me and I can assist you with teamviewer and give you the old tbbmalloc.dll

Hello I wonder if this will fix my issue which seems is along the same line except im on windows 7 I also made a post about my issue with a an error log. Thank you for your time

 

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.