Undefined Regions / Broken Regions about medieval-europe HOT 2 CLOSED

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.

from medieval-europe.

Fixed

from medieval-europe.