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! Fledgling
- Posts: 1
- Joined: Wed Apr 04, 2012 7:26 pm
Re: Solution for error: JTableMenu: :_getNode
Wow Lieven Borms that is probably the greatest fix I have ever used. Thanks!
-
- Joomla! Apprentice
- Posts: 26
- Joined: Tue Sep 20, 2011 11:07 am
- Contact:
Re: Solution for error: JTableMenu: :_getNode
thank you very much, Lieven Borms
that's really good, specially the php file,nice done.
that's really good, specially the php file,nice done.
-
- Joomla! Fledgling
- Posts: 2
- Joined: Sat Apr 07, 2012 4:03 pm
Re: Solution for error: JTableMenu: :_getNode
how do we get past this part
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00′, ’0′, ’0′, â€
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00′, ’0′, ’0′, â€
-
- Joomla! Fledgling
- Posts: 2
- Joined: Sat Apr 07, 2012 4:03 pm
Re: Solution for error: JTableMenu: :_getNode
Hats Off Lieven Borms used the slbs file in the end - worked a treat
-
- Joomla! Fledgling
- Posts: 2
- Joined: Tue Sep 07, 2010 7:50 pm
Re: Solution for error: JTableMenu: :_getNode
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 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.)
Sir, I take my hat of for you.
Thank you for sharing this with us
-
- Joomla! Apprentice
- Posts: 41
- Joined: Sun Nov 15, 2009 11:36 pm
Re: Solution for error: JTableMenu: :_getNode
hooray! so rarely does a forum question i need answered get answered so well. thank you so much!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Apr 17, 2012 2:03 pm
Re: Solution for error: JTableMenu: :_getNode
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!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.)
I tought i need to reinstall all system and start from zero .... You save me one week of hard work...
Beer on me
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Apr 23, 2012 10:54 am
Re: Solution for error: JTableMenu: :_getNode
Lieven Borms thanks very very much mate =)
-
- Joomla! Apprentice
- Posts: 6
- Joined: Thu Jan 13, 2011 11:13 pm
Re: Solution for error: JTableMenu: :_getNode
You are awesome. Thank you.
-
- Joomla! Fledgling
- Posts: 4
- Joined: Wed Jul 20, 2011 9:43 am
Re: Solution for error: JTableMenu: :_getNode
YOU SAVED MY LIFE. Solution worked well on joomla 2.5Lieven 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.)
You are a joomla lifesaver
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue May 01, 2012 7:32 am
Re: Solution for error: JTableMenu: :_getNode
rw1 wrote:This worked! Incredible! Thank You Very Much!!!!!!!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 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.)
Edit: On 1.7.0 too!
Thanksssssss!!!!!!!!!!!!!!!!!!! muchas gracias man! usted es un genio!!!! gracias!!!! funciona perfectamente en joomla 2.5
- Ty2u
- Joomla! Guru
- Posts: 861
- Joined: Tue Aug 23, 2005 6:41 am
- Contact:
Re: Solution for error: JTableMenu: :_getNode
I haven't tried this solution yet but I think I discovered where the problem might come from in the first place.
There is the possibility of different database collations between some of the tables and their structures. One of the SQL queries failed for me during menu migrations due to difference in collations. This could be the same problem that is happening here.
For me simply exporting the old 1.5 database and changing all collations to utf8_general_ci (my database collation) and then importing it into a temp installation on my computer and performing the upgrade with jUpgrade at that point worked perfectly fine. I don't get the SQL error during menu migration anymore.
I actually didn't get any errors until enabling migration debug and then I noticed the problem when enabling migration debug in the jUpgrade params. I thought I may as well post it here in case it helps anyone or gives any insight into what could be happening.
There is the possibility of different database collations between some of the tables and their structures. One of the SQL queries failed for me during menu migrations due to difference in collations. This could be the same problem that is happening here.
For me simply exporting the old 1.5 database and changing all collations to utf8_general_ci (my database collation) and then importing it into a temp installation on my computer and performing the upgrade with jUpgrade at that point worked perfectly fine. I don't get the SQL error during menu migration anymore.
I actually didn't get any errors until enabling migration debug and then I noticed the problem when enabling migration debug in the jUpgrade params. I thought I may as well post it here in case it helps anyone or gives any insight into what could be happening.
TY2U.com Designs http://ty2u.com - Professional Joomla! Extensions
-
- Joomla! Apprentice
- Posts: 33
- Joined: Mon Dec 03, 2007 7:14 pm
Re: Solution for error: JTableMenu: :_getNode
This was P-E-R-F-E-C-T !!!
What a timesaver!
Thank you!
Lobo
What a timesaver!
Thank you!
Lobo
-
- Joomla! Fledgling
- Posts: 4
- Joined: Sun Feb 06, 2011 3:38 am
Re: Solution for error: JTableMenu: :_getNode
Lieven,
Thank you so much for the quick fix. I have no idea what you did, but it worked perfectly!
Thank you so much for the quick fix. I have no idea what you did, but it worked perfectly!
-
- Joomla! Apprentice
- Posts: 11
- Joined: Fri May 11, 2012 10:57 pm
Re: Solution for error: JTableMenu: :_getNode
Hi
It doesn't work for me .. i get this error: #1142 - INSERT command denied to user 'xxxxxx'@'localhost' for table 'uf405_menu'
what am i missing?
I have joomla 2.5.4
It doesn't work for me .. i get this error: #1142 - INSERT command denied to user 'xxxxxx'@'localhost' for table 'uf405_menu'
what am i missing?
I have joomla 2.5.4
-
- Joomla! Apprentice
- Posts: 11
- Joined: Fri May 11, 2012 10:57 pm
Re: Solution for error: JTableMenu: :_getNode
WOW!!! solved, thank you
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.)
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.)
- systeman
- Joomla! Enthusiast
- Posts: 176
- Joined: Sat Jun 10, 2006 7:15 am
- Location: London
- Contact:
Re: Solution for error: JTableMenu: :_getNode
I recently had the same problem and should have searched the Joomla forums first to see if there was a solution.
Anyway, I managed to solve the problem and my solution is sort of similar to that mentioned here.
For those interested it's on one of the RT forums because I wasn't sure if the problem was RT related initially.
http://www.rockettheme.com/forum/index. ... =viewtopic
Anyway, I managed to solve the problem and my solution is sort of similar to that mentioned here.
For those interested it's on one of the RT forums because I wasn't sure if the problem was RT related initially.
http://www.rockettheme.com/forum/index. ... =viewtopic
-
- Joomla! Apprentice
- Posts: 32
- Joined: Sat Feb 19, 2011 12:44 pm
Re: Solution for error: JTableMenu: :_getNode
Fixed it for me
Thanks...
Thanks...
-
- Joomla! Enthusiast
- Posts: 121
- Joined: Mon May 10, 2010 4:14 am
Re: Solution for error: JTableMenu: :_getNode
How to you change the collation on a database for those of us with less of a skill set.For me simply exporting the old 1.5 database and changing all collations to utf8_general_ci (my database collation) and then importing it into a temp installation on my computer and performing the upgrade with jUpgrade at that point worked perfectly fine. I don't get the SQL error during menu migration anymore.
Many thanks,
Houston
- humvee
- Joomla! Master
- Posts: 14704
- Joined: Wed Aug 17, 2005 10:27 pm
- Location: Kent, England
Re: Solution for error: JTableMenu: :_getNode
BACKUP YOUR SITE AND DATABASEHoustonBrown wrote:How to you change the collation on a database for those of us with less of a skill set
Use phpMyAdmin to run the following command:
- To update the database itself :
Code: Select all
ALTER DATABASE database_name CHARACTER SET = utf8 COLLATE = utf8_general_ci;
- Replace database_name with your database name.
- Full documentation can be found at: http://dev.mysql.com/doc/refman/5.5/en/ ... abase.html
- You must also change any of the tables that are not configured with utf-8 collation character set and the columns in the tables.
Code: Select all
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- Do this for each table affected
- Replace table_name with the table name, including the prefix.
- Full documentation can be found at: http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Jul 28, 2012 12:17 pm
Re: Solution for error: JTableMenu: :_getNode
Accept kisses from my GF! You made my day.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Sat Aug 04, 2012 12:39 pm
- Location: Poland
- Contact:
Re: Solution for error: JTableMenu: :_getNode
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.)
Thanks. Your script saved me a few hours of work. One more time Thank You very much
Regards
Iwona
-
- Joomla! Intern
- Posts: 50
- Joined: Thu Aug 30, 2012 5:11 pm
Re: Solution for error: JTableMenu: :_getNode
Lieven Borms,
you are awesome : ). Thanks!
you are awesome : ). Thanks!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Sep 03, 2012 2:06 pm
Re: Solution for error: JTableMenu: :_getNode
Hi where is the link to download this file?
thanks a lot !
thanks a lot !
Last edited by pkpss on Mon Sep 03, 2012 3:19 pm, edited 1 time in total.
-
- Joomla! Apprentice
- Posts: 20
- Joined: Fri Jul 01, 2011 11:08 am
- Location: Dendermonde
Re: Solution for error: JTableMenu: :_getNode
You can download the file on the first page of this post. (posted by Lieven Borms on 08 oktober 2011, 19:24)
-
- Joomla! Fledgling
- Posts: 3
- Joined: Wed Mar 24, 2010 8:38 pm
Re: Solution for error: JTableMenu: :_getNode
For those having problems with the fix there is an additional step that isn't apparent in instructions for step 1....
You have to change your 'DATABASE_NAME' as well as the prefix for ???_menu (right next to the DATABASE_NAME. Find your ???_menu prefix by using the search query to find ???_menu. From there you will find j16_menu or jos_menu or whatever (mine was jos_menu in 2.5). Now edit the DATABASENAME and the prefix of your _MENU and press go.
You have to change your 'DATABASE_NAME' as well as the prefix for ???_menu (right next to the DATABASE_NAME. Find your ???_menu prefix by using the search query to find ???_menu. From there you will find j16_menu or jos_menu or whatever (mine was jos_menu in 2.5). Now edit the DATABASENAME and the prefix of your _MENU and press go.
- formfranska
- Joomla! Enthusiast
- Posts: 179
- Joined: Sun Dec 28, 2008 3:25 pm
- Location: Sweden
- Contact:
Re: Solution for error: JTableMenu: :_getNode
@Lieven,
Thank you ever so much. You have no idea how much I feel I O U for this solution
Greetings
Anna
Thank you ever so much. You have no idea how much I feel I O U for this solution
Greetings
Anna
Joomler in Sweden :-)
https://www.formfranska.com
https://www.formfranska.com
-
- Joomla! Apprentice
- Posts: 14
- Joined: Wed Jun 02, 2010 3:55 pm
Re: Solution for error: JTableMenu: :_getNode
I don't normally post on this forum, but had to here. This post has worked for me and literally saved my life! I have a client website that is due to go live any day now, and I suddenly ran into this problem.
In joomla 2.5 just make sure you substitute the 'j16_menu' for the random generated table prefix that you will find when you look in phpMyAdmin.
Thanks again!!!
In joomla 2.5 just make sure you substitute the 'j16_menu' for the random generated table prefix that you will find when you look in phpMyAdmin.
Thanks again!!!
-
- Joomla! Fledgling
- Posts: 1
- Joined: Mon Oct 01, 2012 1:29 am
Re: Solution for error: JTableMenu: :_getNode
thank you very much...finally problem solved...
-
- Joomla! Fledgling
- Posts: 2
- Joined: Fri Oct 12, 2012 11:42 am
Re: Solution for error: JTableMenu: :_getNode
Can you please help me?
Actually i`m also getting the same error on my website but before everything was fine. I`m using joomla version 2.5.7 but when i checked my jos_menu table in phpmyadmin then it appears to be 1.5 version where the table structure is completely different than the joomla 2.5.7 version structure. Actually my office-mate had imported the joomla 1.5 version jos_menu in this joomla v 2.5.7.So, can u please suggest me some tips on how to solve this problem. Even i also have checked in the jos_menu table that there is an id having value 1 is there.
Thanks,
Actually i`m also getting the same error on my website but before everything was fine. I`m using joomla version 2.5.7 but when i checked my jos_menu table in phpmyadmin then it appears to be 1.5 version where the table structure is completely different than the joomla 2.5.7 version structure. Actually my office-mate had imported the joomla 1.5 version jos_menu in this joomla v 2.5.7.So, can u please suggest me some tips on how to solve this problem. Even i also have checked in the jos_menu table that there is an id having value 1 is there.
Thanks,
Last edited by imanickam on Thu Nov 08, 2012 6:19 am, edited 1 time in total.
Reason: Duplicate post http://forum.joomla.org/viewtopic.php?f=625&t=763037 in the forum Migrating and Upgrading to Joomla! 2.5 has been removed. In the future, please do not post the same topic multiple times as it is against the forum rules to cross post.
Reason: Duplicate post http://forum.joomla.org/viewtopic.php?f=625&t=763037 in the forum Migrating and Upgrading to Joomla! 2.5 has been removed. In the future, please do not post the same topic multiple times as it is against the forum rules to cross post.