Page 1 of 1

Best MariaDB Version for LiF and Nyutons Tools?

Posted: 12 Mar 2020, 19:46
by Yggdrasil
Hi,

i just updatet my MariaDB Version from 5.5 to 10.2 because the Support for 5.5 ends in April 2020.
Now i ran into some issues with the new Livemapversion, so i get errormessages by usin the RCON or Charactermanagement, like:
Fatal error: Uncaught Exception: A MySQL query failed! Error 1451: Cannot delete or update a parent row: a foreign key constraint fails (`lif_1`.`movable_objects`, CONSTRAINT `FK_movable_objects_custom_text` FOREIGN KEY (`CustomNameID`) REFERENCES `custom_texts` (`ID`)) in C:\xampp\htdocs\livemap\includes\mysql.class.php:244 Stack trace: #0 C:\xampp\htdocs\livemap\includes\mysql.class.php(111): MySQL->handle_error('query', 'CALL p_deleteCh...') #1 C:\xampp\htdocs\livemap\includes\gameserver.class.php(492): MySQL->query('CALL p_deleteCh...') #2 C:\xampp\htdocs\livemap\includes\chman.handler.php(53): LiFServer->delete_character(400) #3 C:\xampp\htdocs\livemap\includes\action.handler.php(596): require_once('C:\\xampp\\htdocs...') #4 C:\xampp\htdocs\livemap\main.php(36): require_once('C:\\xampp\\htdocs...') #5 C:\xampp\htdocs\livemap\index.php(86): require_once('C:\\xampp\\htdocs...') #6 {main} thrown in C:\xampp\htdocs\livemap\includes\mysql.class.php on line 244
U see, Its hosted on my own Server but even with the FeudalTools hosted version i ran into the same issues.

Any ideas?

Thanks so far!

Re: Best MariaDB Version for LiF and Nyutons Tools?

Posted: 13 Mar 2020, 12:59
by mazytus
my choice is 10.3
10.4 crashes when setting up alliances, mines are buggy and server restart is required

Re: Best MariaDB Version for LiF and Nyutons Tools?

Posted: 13 Mar 2020, 14:53
by Chris
The only officially supported version for LiF:YO is 5.5
But we haven't had any bad experiences with 10.2 and 10.3 yet.
The error trace doesn't look like a db version issue tho