Categories
View Replies (4)

Resolved Issues caused by missing menu root item

  1. jjnxpct
    jjnxpct
  2. RO CSVI
  3. Wednesday, 15 February 2023
  4.  Subscribe via email
Yesterday we had an issue with inmorting menu itmes. (migration J3 -> J4). This was solved and the menu items were migrated OK. But today we saw an error after installing an new extension. (Joomla\CMS\Table\Menu::_getNode(1,id) failed) The extension was installed OK but the was no menu item in the backend. Also rebuilding the menu did not work because of an error.

After some online research I found that the menu root item was missing. I was able to add this in the database using this query:



INSERT INTO `[prefix]_menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`, `publish_up`, `publish_down`) VALUES

(1, '', 'Menu_Item_Root', 'root', '', '', '', '', 1, 0, 0, 0, NULL, NULL, 0, 0, '', 0, '', 0, 93, 0, '*', 0, NULL, NULL);


Could this have been caused by the import of the menu items? Or mabye by the first attempts that had the but (second languae field)? Anyway, just wanted to let you know and maybe this helps out someone else in the future.
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Could this have been caused by the import of the menu items?

Import of menu items do not delete menu root. I read through your previous post on issues on menu import. I had mentioned to clean up earlier imported menu items in my reply. By any chance the menu root was also deleted in this process?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
jjnxpct
jjnxpct
Accepted Answer Pending Moderation
Hi! I don't think I deleted items from the database directly, only from the backend. I don't think you can delete the root menu item from the backend?

But maybe I somehow did this myself. I had to repeat the import a few time to get it working. I did check the database using phpMyAdmin to see it any items were imported after some new attempts. So maybe I did delete the root item from phpMyAdmin. Anyway, ti's working now ;-)
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I don't think you can delete the root menu item from the backend?

You cannot delete menu root from backend. Only possibility to delete it is using PHPMyAdmin.

But maybe I somehow did this myself. I had to repeat the import a few time to get it working. I did check the database using phpMyAdmin to see it any items were imported after some new attempts. So maybe I did delete the root item from phpMyAdmin. Anyway, ti's working now ;-)

Glad to know all is working now.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
dzosh
dzosh
Accepted Answer Pending Moderation
Hi,

I understand that this issue is already 2 years old, but I have to share the same problem with others.

We’ve recently tested a completely clean installation and configuration of Joomla 5.x and RO CSVI. When importing menus using CSVI, the item with ID 1 – Menu_Item_Root – disappeared from the _menu database table. We didn’t make any manual changes to the database, so it likely happened as a result of using the menu import feature.

As a result, it’s not possible to create any new menu item — “Save failed with the following error: Joomla\Component\Menus\Administrator\Table\MenuTable::_getNode(1, id) failed.” — and the “Rebuild” function for Joomla menus also can’t be used due to the error message “Failed rebuilding Menu Items list.”.

We reinstalled the entire Joomla and CSVI, and the menu import no longer produced this problem. It was probably due to an incorrect combination of values ​​in the csv file for menu import. Unfortunately, we no longer have the original csv file that could cause the problem so that we can reproduce the problem.

So I just want to let others know that in certain combinations this problem can occur.
  1. 3 days ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!