Solution for error: JTableMenu: :_getNode

[russelblair]

Wow! Thank you for that Lieven Borms!

[TomT]

Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.

Wow, this works great. You really helped me.

Thanks, Tom

[Gordon1552]

I am not sure where to start here. I have the same error showing up and new components simply don't show up in the Joomla 2.5.7 admin Components menu. The components are installed into the site OK but no sign within Admin.

I have followed both sets of instructions as per Lieven's great work but unfortunately on both occaisons the problem still existed.

Any help would be greatly appreciated.

[moulinski]

No thanks. I’m happy that i could help to solve your problem.
Believe it or not but 2 years ago I didn’t know the existence of Joomla or even CMS.
So I know how hard it can be and especially with an error like these. But with good support you can learn very fast.
These solution worked for everybody and it’s much better than recreate your whole website back from zero

How I couldn't tell MANY THANKS to you? With this little file you saved me by rebuilding over 30 menus!

P.S. worked perfectly on Joomla 2.5.8

[Rinoplasti1122]

As the post says you can make the whole page in HTML including a header and footer. That is the whole point of the guide… To make the custom page look completely different than the rest of the blogs theme.
While there is a way to add different header and footer images and or styles to a theme in the stylesheet, it is not something easily explained. But basically you would have to add the new/different css code in the themes stylesheet and then call for it in the custom page template instead of the original.
----------------------------------------
Rinoplasti

[Terriz]

Many thanks! Works like a charm!

[mattisa]

Can anyone help please!!!
What if you have joomla 2.5? After the database name... what do you have to enter instead of `a8z7y_menu`.
Thanks

[sovainfo]

The prefix before menu in `a8z7y_menu` needs to be replaced with the prefix your database is using. What that prefix is can be found in Joomla admin=>Global Configuration on tab Server on the right you see Database Settings. The last attribute is called Database Tables Prefix. That value should be used.

You can also find it in configuration.php:

Code: Select all

public $dbprefix = 'j258_';

Upon installation I set it to the version of Joomla I was installing: j258_.

[Llewellyn]

Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Below you can find the renewed solution.

To solve this problem please enter the following two steps.
1. Add the missing record to the database
Unzip the file ‘slbs.zip’ (attached to this post)
Copy the file ‘slbs.php’ to the root of your domain
Go to http://www.yourdomain.com/slbs.php (replace ‘yourdomain.com’ with your real domain)
Now you can remove the ‘slbs.php’ file from the root

2. Rebuilding menus
Go to the administrator panel of joomla.
Menus --> MenuManager
Select all menus
Click on the button ‘Rebuild’
(By doing step two, the field ‘rgt’ in the just added record (step one) will get the appropriate value.)

Tanks Lieven Borms for sharing!!! I could fix the problem on Joomla 2.5.8

For those looking for the download, you must login to download this easy fix at http://forum.joomla.org/viewtopic.php?f ... 3#p2638090

[davidg82]

Thank you very much!!
This issue is still happen in Joomla 2.5 after upgrading from 1.5 with JupgradePro.
Worked perfectly

[trusting]

Thank you, Lieven Borms!

This worked great ... as soon as I followed ALL the instructions (including clicking on the Rebuild Table button).

[philsogood]

I had the same problem on a Joomla 2.5.9. and this solution has fixed it - Life saver - thank you!

[casus2402]

ooooo my good thank youuu )))))))))

[kunoichidee]

How is it that no-one is reacting to the posts of people that are not helped with this sollution?

I, as some others on this forum, are stil having the same problems, the fix is not fixing it!

I'm using Joomla 2.5.7.

Anyone have any ideas?
How about the ones that reported having the problem still?
Any fixes there?
HEEELP!!! please....

[dmccray]

Unzip the file ‘slbs.zip’ (attached to this post)
I don't see any attachment on this post. Can anyone tell me where
I can get the file for this fix? Thanks

[sergZ]

Help, I have joomla 3.0. I tried all of these methods. An error can not find columns: Invalid query: Unknown column 'ordering' in 'field Leaves
Can someone was dealing with this problem for joomla 3.0?
thanks

[gman2011]

Thank you to the gentleman who posted the slsb.php file, saved my butt and hours on hours.

Worked for the environment below. My only question would be why is it still happening and not being addressed in subsequent builds

PHP Built On Linux gator921.hostgator.com 3.2.38 #11 SMP Sat Feb 16 20:42:35 CST 2013 x86_64
Database Version 5.5.23-55
Database Collation utf8_general_ci
PHP Version 5.2.17
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 2.5.8 Stable [ Ember ] 8-November-2012 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0

[david_flo1]

Thanks a LOT, really I was so upset, My fresh installation of Joomla 2.5.9 and I created a whole Main menu then activated Multilingual stuff and tried to create a different language menu and all went to garbage, I was so upset.

Your method fixed it, thanks

[realy]

Thank you very much!!

[ratweb]

I am running 3.1, clean install as of a week ago and the same thing is happening to me.. i tried the slbs.php and get an error of "Invalid query: Unknown column 'ordering' in 'field list'" any help would greatly appreciated!

I get this error when i try rebuild Fatal error: Call to undefined method MenusModelItem::getMessage() in /MY SITE/administrator/components/com_menus/controllers/menus.php on line 111

i have disabled all SEF, disabled htaccess.. sttill same error.. any ideas? Im really not looking forward to rebuilding the site, esp if unstable..

Here is the error when i save a menu item, i can create a top menu in menu manager just nothing under it. Replaced path with MY SITE for posting


Warning

Save failed with the following error: exception 'UnexpectedValueException' with message 'MenusTableMenu::_getNode(1, ) failed.' in /MY SITE/libraries/joomla/table/nested.php:1441 Stack trace: #0 /MY SITE/libraries/joomla/table/nested.php(751): JTableNested->_getNode(1) #1 /MY SITE/libraries/legacy/table/menu.php(183): JTableNested->store(false) #2 /MY SITE/administrator/components/com_menus/models/item.php(1231): JTableMenu->store() #3 /MY SITE/administrator/components/com_menus/controllers/item.php(224): MenusModelItem->save(Array) #4 /MY SITE/libraries/legacy/controller/legacy.php(722): MenusControllerItem->save() #5 /MY SITE/administrator/components/com_menus/menus.php(18): JControllerLegacy->execute('apply') #6 /MY SITE/libraries/legacy/component/helper.php(359): require_once('/home/offroadh/...') #7 /MY SITE/libraries/legacy/component/helper.php(339): JComponentHelper::executeComponent('/MY SITE/...') #8 /MY SITE/administrator/includes/application.php(166): JComponentHelper::renderComponent('com_menus') #9 /MY SITE/administrator/index.php(56): JAdministrator->dispatch() #10 {main}

FIXED - WORK AROUND

I restored my site with Akeeba lost and 2 days of work. ugh.. After i compared the structure of the _Menu tables.. seems it lost row 1, even some of the default rows as well. I do not have the time to trace them all however here is the "Should not be an issue for you" fix. It restores the DEFAULT only menu-items such as banners, root menu, etc.

Step 1. Download the attached file PREFIX_menu.sql, its an export of a clean 3.1 install of the _menu table.

Step 2. Open the file PREFIX_menu.sql in notepad or equivalent, do not use a program that inserts carriage returns, only raw format, i have marked where you need to edit the database name and prefix to match your server. Save the file and exit

Step 3. Open your PHPMyadmin or MySQL application, go to the table _menu, once open click on Import "PREFIX_menu.sql" this should restore the Default Joomla! 3.1 menu structure, but not modify any changes you have made. i don't use any of the the default anything so you may need to tweak your site a little after if you do. But it saves a lot of time just having to change a few things than rebuilding everything.

Your menu structure, rebuild and adding new menus should be no issue again.. I do not know why the menu structure in the DB get whacked, seems like an ongoing issue, im not a programmer but this really should be looked into.

This as is, i dont know if it will fix your problem directly, it did for me.

[ChessDigital]

Unfortunately the slbs.php fix did not work. Running it generated the following error:

Parse error: syntax error, unexpected T_ECHO in [my web host path]/slbs.php on line 6

Line 6 is:
echo "Troubleshooting started<br /><br /><br />";

Not sure why that would fail, but it seems I can't even attempt to repair the database.

Any idea?

[ratweb]

If you have access to c panel you could just restore the default menu structure, look up at my previous post. It seems more complex than it it is, its a 5 min fix.. as for the other app, i had issues getting it working right on 3.1 as well, that's why i came up with this work around.

Remember row 1 gets whacked, so restoring the default structure will correct that error.

hope this helps

[ChristineBeth]

You're my hero too. I thought I was doomed, you made it a piece of cake. I'm using Joomla 2.5.14 and was afraid it wouldn't work.

[StefanKW]

Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Below you can find the renewed solution.

To solve this problem please enter the following two steps.
1. Add the missing record to the database
Unzip the file ‘slbs.zip’ (attached to this post)
Copy the file ‘slbs.php’ to the root of your domain
Go to www.yourdomain.com/slbs.php (replace ‘yourdomain.com’ with your real domain)
Now you can remove the ‘slbs.php’ file from the root

2. Rebuilding menus
Go to the administrator panel of joomla.
Menus --> MenuManager
Select all menus
Click on the button ‘Rebuild’
(By doing step two, the field ‘rgt’ in the just added record (step one) will get the appropriate value.)

Merci beaucoup !!

[EE Photo]

Thanks! Worked for me on Joomla 2.5.16.

[wjl1984]

thanks for this great sharing.

[andre4000]

FIXED - WORK AROUND

I restored my site with Akeeba lost and 2 days of work. ugh.. After i compared the structure of the _Menu tables.. seems it lost row 1, even some of the default rows as well. I do not have the time to trace them all however here is the "Should not be an issue for you" fix. It restores the DEFAULT only menu-items such as banners, root menu, etc.

Step 1. Download the attached file PREFIX_menu.sql, its an export of a clean 3.1 install of the _menu table.

Step 2. Open the file PREFIX_menu.sql in notepad or equivalent, do not use a program that inserts carriage returns, only raw format, i have marked where you need to edit the database name and prefix to match your server. Save the file and exit

Step 3. Open your PHPMyadmin or MySQL application, go to the table _menu, once open click on Import "PREFIX_menu.sql" this should restore the Default Joomla! 3.1 menu structure, but not modify any changes you have made. i don't use any of the the default anything so you may need to tweak your site a little after if you do. But it saves a lot of time just having to change a few things than rebuilding everything.

Your menu structure, rebuild and adding new menus should be no issue again.. I do not know why the menu structure in the DB get whacked, seems like an ongoing issue, im not a programmer but this really should be looked into.

This as is, i dont know if it will fix your problem directly, it did for me.

Hey Ratweb, thanks for this fix, it actually worked great. I'm running J3.2.1 stable. A couple points of interest: I had to change a few references to your db prefix (svp) to my own prefix in the sql file. Also, I was getting errors about duplicate entries, as my default menu items were still intact. So I removed all the lines except for 1.

Code: Select all

(1, '', 'Menu_Item_Root', 'root', .......

Imported and everything is fixed! Thanks a lot!

[gus33415]

Thanks alot , my problem was caused by JCH Pro , disabled problem disappear ( RS form pro not working )

[terdono]

I'm pretty sure my problem is with the database... a) how did it happen, so I can prevent it from happening again and 2) how many menus are affected?

[marcowinter89]

Lieven Borms you save me!! Thank you so much!!!