Navigation Menu Items missing on OJS 3.1

Software Support
1

Hi,

I upgraded from ojs 2.4.8 to 3.1, but the navigation menus are missing?
image

Any suggestions?

2

Hi @Nardusg, we actually encountered a similar issue with one of our migrations. It was caused by missing titles in our database.

What we did was run a command on the database to see all of the navigation items missing a title:

SELECT *
FROM (
 SELECT navigation_menu_item_id, setting_name, setting_value
 FROM navigation_menu_item_settings
 GROUP BY navigation_menu_item_id
 HAVING COUNT(*) = 1
) AS ONLY_ONCE;

Then we used the results to construct statements to resolve the issue:

INSERT INTO `navigation_menu_item_settings` (`navigation_menu_item_id`, `locale`, `setting_name`, `setting_value`, `setting_type`)
VALUES
('213', 'en_US', 'title', '{$loggedInUsername}', 'string'),
....

and replaced the values as necessary. I used regex in a text editor to create these statements, but I’m sure someone with more SQL knowledge may be able to come up with a better solution!

1 Like
3

Hi @kaitlin

Awesome… thank you so much for the info, that fixed the issue for me as well .

Regards

4

Hello I am having the same issue and I tired the SQL queries but it didn’t work. Can you help me?