Upgrade OJS 3.2.1-4 to 3_3_0-8 failed

[murilodbva]

Hi there.
Trying to upgrade OJS from 3.2.1-4 to 3_3_0-8, I’m having this problem:

$ php tools/upgrade.php upgrade
…
…

[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
[migration: PKPv3_3_0UpgradeMigration]
ERROR: Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘645-pt_BR-remoteUrl’ for key ‘navigation_menu_item_settings_pkey’ (SQL: insert into navigation_menu_item_settings (navigation_menu_item_id, locale, setting_name, setting_value, setting_type) values (645, pt_BR, remoteUrl, https://websitexyz, string))

I found this publication with a similar problem a the solution, but I couldn’t yet solve too:
https://forum.pkp.sfu.ca/t/another-3-3-0-3-upgrade-problem/66264

Thanks if someone can you help. =)

[murilodbva]

I made this script and it resolved:

CREATE TEMPORARY TABLE IF NOT EXISTS navigation_menu_items_2_delete AS (
    SELECT navigation_menu_item_id
    FROM navigation_menu_items x
        LEFT JOIN rt_contexts j ON (x.context_id = j.context_id)
    WHERE j.context_id IS NULL
);
DELETE FROM navigation_menu_item_assignments WHERE navigation_menu_item_id IN (
    SELECT navigation_menu_item_id
    FROM navigation_menu_items_2_delete
);
DELETE FROM navigation_menu_item_settings WHERE navigation_menu_item_id IN (
    SELECT navigation_menu_item_id
    FROM navigation_menu_items_2_delete
);
DELETE FROM navigation_menu_items WHERE navigation_menu_item_id IN (
    SELECT navigation_menu_item_id
    FROM navigation_menu_items_2_delete
);
DROP TABLE navigation_menu_items_2_delete;