[OJS 3.3.0-8] Navigation primary menu disappears after add items

Software Support
1

I am using OJS 3.3.0-8 which have multiple navigation items defined, some are custom items. Well the editor has reported me that when she was modifying the primary navigation menu, this disappear from the front page.

I reviewed the database searching corrupt data in the following tables:

navigation_menu_item_settings
navigation_menu_items
navigation_menus


-- Buscar items huerfanos
SELECT navigation_menu_item_id 
FROM navigation_menu_items 
WHERE navigation_menu_item_id NOT IN (
    SELECT navigation_menu_item_id 
    FROM navigation_menu_item_settings
);
0 rows

-- Buscar settings corruptos
SELECT * 
FROM navigation_menu_item_settings 
WHERE setting_value IS NULL 
   OR setting_value = '';

-- 142 rows, a lot with setting_name= title, content and remoteUrl

I have noticed that there are 3 locales, es_ES, en_US and pt_BR, and a subset of 142 rows have setting_value empty or NULL for multiple locales, could it be possible these rows are the reason of the bug?


SELECT n.navigation_menu_id, n.title, COUNT(i.navigation_menu_item_id) AS items
FROM navigation_menus n
LEFT JOIN navigation_menu_item_assignments a ON a.navigation_menu_id = n.navigation_menu_id
LEFT JOIN navigation_menu_items i ON i.navigation_menu_item_id = a.navigation_menu_item_id
GROUP BY n.navigation_menu_id;

/* 
Resultset:

+--------------------+---------+-------+
| navigation_menu_id | title   | items |
+--------------------+---------+-------+
|                  1 | User    |     7 |
|                  2 | User    |     7 |
|                  3 | Primary |     4 |
+--------------------+---------+-------+
3 rows in set (0.004 sec)
 */

The OJS is using the theme bootstrap3 version 3.2.0.6.

It’s important to mention that this behaviour is intermittent, because the editor could be have modified the primary menu for sometime, saving and see her modifications on the frontend navigation menu, but if add another one which nobody could identify, after saving the menu dissapear. Sometimes it was completely vanish and other was partially.

Someone more have this issue with OJS 3.3.0-8 and bootstrap3 theme?