Undefined Regions / Broken Regions

[Enoc-GitHub]

Issue found while checking the map.

Region names:

• Siena
• Firenze

Issue found: Regions in DB belong to Kingdoms in status = deleted:

Possible fix: Update DB tables assigning proper kingdom.

[Enoc-GitHub]

SOLUTION:

Must execute commands in the following order to be able to fix. If capital and kingdom_id fields are updated on the same SQL statement, it fails to properly update row.

Disable Capital Region:
UPDATE regions SET capital = '0' WHERE name = 'regions.siena';
UPDATE regions SET capital = '0' WHERE name = 'regions.firenze';

Assign to Independent Kingdom:
UPDATE regions SET kingdom_id = '37' WHERE name = 'regions.siena';
UPDATE regions SET kingdom_id = '37' WHERE name = 'regions.firenze';

It takes a few seconds/minutes but at some point DB refreshes and changes are visible in the game.

[jeffreypicard]

Fixed