Hi all
I ran into this DB error while upgrading:
root@idubomptest01:/var/www/pkp-omp# php app/tools/upgrade.php upgrade
2025-07-15 12:51:44 [pre-install]
2025-07-15 12:51:44 [load: upgrade.xml]
2025-07-15 12:51:44 [version: 3.5.0.1]
2025-07-15 12:51:44 [code: Installer Installer::checkPhpVersion]
2025-07-15 12:51:44 [code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 2, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 2, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 3, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 3, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: , Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
2025-07-15 12:51:44 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2025-07-15 12:51:44 [migration: PKP\migration\upgrade\v3_4_0\I10249_FixProfileImageDataLoss]
2025-07-15 12:51:44 [migration: PKP\migration\upgrade\v3_4_0\I9136_MigrateUniqueSiteId]
2025-07-15 12:51:44 [migration: APP\migration\upgrade\v3_4_0\I9231_FixMetricsIndexes]
2025-07-15 12:51:44 [migration: APP\migration\upgrade\v3_4_0\I9627_AddUsageStatsTemporaryTablesIndexes]
2025-07-15 12:51:44 [revert migration: APP\migration\upgrade\v3_4_0\I9231_FixMetricsIndexes]
2025-07-15 12:51:44 [downgrade for "APP\migration\upgrade\v3_4_0\I9231_FixMetricsIndexes" unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'ustr_load_id_context_id_ip' (Connection: mysql, SQL: alter table `usage_stats_unique_title_requests_temporary_records` add index `ustr_load_id_context_id_ip`(`load_id`, `context_id`, `ip`))
root@idubomptest01:/var/www/pkp-omp#
Do I have to upgrade to an older version first? Any ideas? Many thanks.
jan