• 0
Sign in to follow this  
TheFarFlash

Territory not saved in DB

Question

Hi,

I try to get a new 1.0.4 running on a root with a new DB with extDB3.

Territories will not be safed in the DB and the RTP Log give me following error:

Spoiler

Error in expression <llExtension _query);
(_result select 1) select 0
>
 Error position: <select 0
>
Error Generic error in expression
File mpmissions\__cur_mp.xCam_Taunus\Exile_Server_Overrides\ExileServer_system_database_query_insertSingle.sqf, line 16
Error in expression <llExtension _query);
(_result select 1) select 0
>
Error position: <select 0
>
Error Generic error in expression
File mpmissions\__cur_mp.xCam_Taunus\Exile_Server_Overrides\ExileServer_system_database_query_insertSingle.sqf, line 16

Here the whole RTP https://pastebin.com/G3sAiDdx
The extDB Log https://pastebin.com/EbDW51C0

After that I corrected in the exile.ini the number of SQL1_INPUTS  @ the line 558 of  [createTerritory] from 11 to 12
Here the old exile.ini https://pastebin.com/isDDkJYS

The result is the same error in the RTP but the error in the extDB Log changes to this
 

Spoiler
[15:15:54:004975 +01:00] [Thread 4292] extDB3: SQL: Error MariaDBStatementException1: Cannot add or update a child row: a foreign key constraint fails (`test`.`territory`, CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL)
[15:15:54:004998 +01:00] [Thread 4292] extDB3: SQL: Error MariaDBStatementException1: Input: createTerritory:76561197968272085:A:14059.139648:18469.804688:-0.2789:15:1:exile_assets\texture\flag\flag_country_de_co.paa:0:["76561197968272085"]:["76561197968272085"]:
[15:15:54:006889 +01:00] [Thread 4292] extDB3: SQL: Error MariaDBStatementException1: Cannot add or update a child row: a foreign key constraint fails (`test`.`territory`, CONSTRAINT `territory_ibfk_2` FOREIGN KEY (`flag_stolen_by_uid`) REFERENCES `account` (`uid`) ON DELETE SET NULL)
[15:15:54:006902 +01:00] [Thread 4292] extDB3: SQL: Error MariaDBStatementException1: Input: createTerritory:76561197968272085:A:14059.139648:18469.804688:-0.2789:15:1:exile_assets\texture\flag\flag_country_de_co.paa:0:["76561197968272085"]:["76561197968272085"]:
[15:15:54:007018 +01:00] [Thread 4292] extDB3: SQL: Error Max Retrys Reached

[15:15:54:007031 +01:00] [Thread 4292] extDB3: SQL: Error Max Retrys Reached

The whole LOG here: https://pastebin.com/Pm0p7u5H

Could anyone help me out of this misery, pls.

The Testserver with 1.0.3 I was working on, was always fine. :-(

THX

Share this post


Link to post
Share on other sites

0 answers to this question

There have been no answers to this question yet

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  

  • Recently Browsing   0 members

    No registered users viewing this page.