Cloud22

[Done] ExtDb3 Compatibility with Exile

835 posts in this topic

@mokdevel
Confirm you have @extDB3/sql_custom/exile.ini  [loadvehicle] section is correct, compare against the github one.
Note there has been some changes recently to the repo.

Otherwise please submit a database snapshot & your exile.ini file to me on arma3 discord  or submit ticket on bitbucket.
Thanks
 

Share this post


Link to post
Share on other sites
Advertisement

I had missed the latest changes. Updated those - still the same error.

I cleared vehicle table and now database and server works! Yay!

Here is the table .csv before clearing it. MySQL Workbench does not want import it anymore. :-(

http://pastebin.com/XexNeiYM

Edited by mokdevel

Share this post


Link to post
Share on other sites

A couple of errors now seen in .rpt

21:04:58 Error in expression <DB3" callExtension "9:UPTIME:MINUTES")) select 1
>
21:04:58   Error position: <select 1
>
21:04:58   Error select: Type Number, expected Array,String,Config entry
21:04:58 File mpmissions\__cur_mp.Tanoa\override_ext3db\ExileServer_util_time_uptime.sqf, line 12

And

21:08:37 "ExileServer - Database Error: Error MariaDBStatementException0 Exception"
21:08:37 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0
>
21:08:37   Error position: <select 0
>
21:08:37   Error Generic error in expression
21:08:37 File mpmissions\__cur_mp.Tanoa\override_ext3db\ExileServer_system_database_query_selectSingle.sqf, line 27

I'm using MySQL (..and MariaDB is the other sister).

Share this post


Link to post
Share on other sites
5 minutes ago, mokdevel said:

A couple of errors now seen in .rpt


21:04:58 Error in expression <DB3" callExtension "9:UPTIME:MINUTES")) select 1
>
21:04:58   Error position: <select 1
>
21:04:58   Error select: Type Number, expected Array,String,Config entry
21:04:58 File mpmissions\__cur_mp.Tanoa\override_ext3db\ExileServer_util_time_uptime.sqf, line 12

And


21:08:37 "ExileServer - Database Error: Error MariaDBStatementException0 Exception"
21:08:37 Error in expression <ase_handleBig;
};
};
(_result select 1) select 0
>
21:08:37   Error position: <select 0
>
21:08:37   Error Generic error in expression
21:08:37 File mpmissions\__cur_mp.Tanoa\override_ext3db\ExileServer_system_database_query_selectSingle.sqf, line 27

I'm using MySQL (..and MariaDB is the other sister).

hi, check the line

ExileServer_util_time_uptime

Spoiler

(call compile ("extDB2" callExtension "9:UPTIME:MINUTES")) select 1

to

(call compile ("extDB3" callExtension "9:UPTIME:MINUTES")) select 1

 

ExileServer_system_database_query_selectSingle

Spoiler

_result = call compile ("extDB2" callExtension _query);

to

_result = call compile ("extDB3" callExtension _query);

I hope it helps

Share this post


Link to post
Share on other sites

The extDB3 reference is correct. Repacked the mission file once again and I get the same errors when spawning. Cleared the player table and when spawning I get  the same error.

Share this post


Link to post
Share on other sites

Change it to

(call compile ("extDB3" callExtension "9:UPTIME:MINUTES"))



The second error notice the 

ExileServer - Database Error: Error MariaDBStatementException0 Exception

Check extDB3 logs, it will have some errors about SQL

Share this post


Link to post
Share on other sites

The error in the log:

[21:54:46:803411 +02:00] [Thread 7608] extDB3: Locked
[21:55:28:085153 +02:00] [Thread 7608] extDB3: SQL: Error MariaDBStatementException0: Unknown column 'ai_kills' in 'field list'
[21:55:28:085153 +02:00] [Thread 7608] extDB3: SQL: Error MariaDBStatementException0: Input: getAccountStats:76561198341150000

 

Edited by mokdevel

Share this post


Link to post
Share on other sites

See the log its complaining about a column missing for getAccountStats
So if you change the 

 

[getAccountStats]

SQL1_1 = SELECT score, kills, deaths, clan_id, locker, ai_kills FROM account WHERE uid = ?
SQL1_INPUTS = 1
OUTPUT = 1,2,3,4,5,6

->

[getAccountStats]

SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ?
SQL1_INPUTS = 1
OUTPUT = 1,2,3,4,5

 

It should be good, its prob some custom code Cloud has got on his server.

  • Like 1

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.