Solution for error: JTableMenu: :_getNode
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
-
- Joomla! Apprentice
- Posts: 15
- Joined: Wed Oct 10, 2012 4:57 pm
- Location: Philippines
- Contact:
Re: Solution for error: JTableMenu: :_getNode
Wow! Thank you for that Lieven Borms!
- TomT
- Joomla! Ace
- Posts: 1324
- Joined: Thu Aug 18, 2005 5:50 am
- Location: Amsterdam
- Contact:
Re: Solution for error: JTableMenu: :_getNode
Wow, this works great. You really helped me.Lieven Borms wrote:Because some people are struggling with the phpMyAdmin part. I simplified the first part of the solution.
Thanks, Tom
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Jan 05, 2010 8:32 am
Re: Solution for error: JTableMenu: :_getNode
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.
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.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Mar 16, 2010 4:50 pm
Re: Solution for error: JTableMenu: :_getNode
How I couldn't tell MANY THANKS to you? With this little file you saved me by rebuilding over 30 menus!Lieven Borms wrote: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
P.S. worked perfectly on Joomla 2.5.8
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Nov 17, 2012 8:55 am
Rinoplasti
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
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
-
- Joomla! Apprentice
- Posts: 5
- Joined: Wed Dec 09, 2009 12:10 pm
Re: Solution for error: JTableMenu: :_getNode
Many thanks! Works like a charm!
-
- Joomla! Fledgling
- Posts: 2
- Joined: Sat Feb 02, 2013 7:35 pm
Re: Solution for error: JTableMenu: :_getNode
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
What if you have joomla 2.5? After the database name... what do you have to enter instead of `a8z7y_menu`.
Thanks
-
- Joomla! Exemplar
- Posts: 8808
- Joined: Sat Oct 01, 2011 7:06 pm
Re: Solution for error: JTableMenu: :_getNode
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:Upon installation I set it to the version of Joomla I was installing: j258_.
You can also find it in configuration.php:
Code: Select all
public $dbprefix = 'j258_';
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!
- Llewellyn
- Joomla! Apprentice
- Posts: 31
- Joined: Sat Jun 14, 2008 10:45 am
- Location: Windhoek, Namibia
- Contact:
Re: Solution for error: JTableMenu: :_getNode
Tanks Lieven Borms for sharing!!! I could fix the problem on Joomla 2.5.8Lieven Borms wrote: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.)
For those looking for the download, you must login to download this easy fix at http://forum.joomla.org/viewtopic.php?f ... 3#p2638090
<<ewe>>yn
Joomla Component Builder - Lead Developer
Joomla Component Builder - Lead Developer
-
- Joomla! Apprentice
- Posts: 6
- Joined: Mon Jan 07, 2013 12:48 pm
Re: Solution for error: JTableMenu: :_getNode
Thank you very much!!
This issue is still happen in Joomla 2.5 after upgrading from 1.5 with JupgradePro.
Worked perfectly
This issue is still happen in Joomla 2.5 after upgrading from 1.5 with JupgradePro.
Worked perfectly
-
- Joomla! Enthusiast
- Posts: 134
- Joined: Tue Feb 10, 2009 4:49 am
Re: Solution for error: JTableMenu: :_getNode
Thank you, Lieven Borms!
This worked great ... as soon as I followed ALL the instructions (including clicking on the Rebuild Table button).
This worked great ... as soon as I followed ALL the instructions (including clicking on the Rebuild Table button).
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Mar 04, 2013 4:27 pm
Re: Solution for error: JTableMenu: :_getNode
I had the same problem on a Joomla 2.5.9. and this solution has fixed it - Life saver - thank you!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Mar 05, 2013 7:30 am
- Contact:
Re: Solution for error: JTableMenu: :_getNode
ooooo my good thank youuu )))))))))
-
- Joomla! Apprentice
- Posts: 11
- Joined: Sun Feb 14, 2010 9:38 pm
Re: Solution for error: JTableMenu: :_getNode
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....
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....
-
- Joomla! Apprentice
- Posts: 12
- Joined: Sun Jan 13, 2008 11:10 pm
Re: Solution for error: JTableMenu: :_getNode
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
I don't see any attachment on this post. Can anyone tell me where
I can get the file for this fix? Thanks
-
- Joomla! Fledgling
- Posts: 1
- Joined: Wed Mar 27, 2013 5:21 am
Re: Solution for error: JTableMenu: :_getNode
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
Can someone was dealing with this problem for joomla 3.0?
thanks
-
- Joomla! Fledgling
- Posts: 3
- Joined: Fri Aug 26, 2011 7:15 pm
Re: Solution for error: JTableMenu: :_getNode
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
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
-
- Joomla! Fledgling
- Posts: 1
- Joined: Wed Apr 17, 2013 5:49 am
Re: Solution for error: JTableMenu: :_getNode
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
Your method fixed it, thanks
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Apr 25, 2013 11:33 am
Re: Solution for error: JTableMenu: :_getNode
Thank you very much!!
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Jun 04, 2013 7:40 pm
Re: Solution for error: JTableMenu: :_getNode
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- Joomla! Fledgling
- Posts: 4
- Joined: Sat Nov 03, 2012 3:28 pm
Re: Solution for error: JTableMenu: :_getNode
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?
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?
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Jun 04, 2013 7:40 pm
Re: Solution for error: JTableMenu: :_getNode
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
Remember row 1 gets whacked, so restoring the default structure will correct that error.
hope this helps
-
- Joomla! Fledgling
- Posts: 1
- Joined: Fri Sep 13, 2013 3:56 pm
Re: Solution for error: JTableMenu: :_getNode
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.
-
- Joomla! Apprentice
- Posts: 13
- Joined: Tue Aug 13, 2013 12:13 am
Re: Solution for error: JTableMenu: :_getNode
Merci beaucoup !!Lieven Borms wrote: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.)
-
- Joomla! Ace
- Posts: 1858
- Joined: Mon Dec 14, 2009 4:17 pm
Re: Solution for error: JTableMenu: :_getNode
Thanks! Worked for me on Joomla 2.5.16.
Besök gärna min webbplats: http://www.fotoforalla.se/
-
- Joomla! Apprentice
- Posts: 38
- Joined: Sun Nov 03, 2013 2:02 pm
- Contact:
Re: Solution for error: JTableMenu: :_getNode
thanks for this great sharing.
-
- Joomla! Fledgling
- Posts: 3
- Joined: Mon Jul 27, 2009 6:23 am
Re: Solution for error: JTableMenu: :_getNode
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.ratweb wrote:
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.
Code: Select all
(1, '', 'Menu_Item_Root', 'root', .......
-
- Joomla! Fledgling
- Posts: 3
- Joined: Wed Feb 12, 2014 11:57 pm
Re: Solution for error: JTableMenu: :_getNode
Thanks alot , my problem was caused by JCH Pro , disabled problem disappear ( RS form pro not working )
-
- Joomla! Apprentice
- Posts: 24
- Joined: Wed Aug 14, 2013 6:38 am
Re: Solution for error: JTableMenu: :_getNode
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?
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Apr 22, 2014 7:33 am
Re: Solution for error: JTableMenu: :_getNode
Lieven Borms you save me!! Thank you so much!!!