Joomla Error – Save failed with the following error: JTableMenu: _getNode Failed

by Elaine on August 6, 2011

Joomla Error message when upgrading from Joomla 1.5 to Joomla 1.6 with Jupgrade.

Upgrading your Joomla version is the most dreaded part of maintaining a Joomla website.  There are always problems when it comes to upgrading your version.  That’s why I would recommend using a component to assist in the data migration.  Using Jupgrade is a simple Joomla 1.5/Joomla 1.6/Joomla 1.7 component that will download the latest version of Joomla, decompressand install it on your Joomla webhosting.  Afterwards it will migrate all data from your old Joomla website to the new installation ie Joomla 1.7 (or Joomla 1.6).

The Error Message: An error that I encountered was after using Jupgrade and in the Menu Manager creating a new menu item:

Save failed with the following error: JTableMenu: _getNode Failed

The Problem:  The issue is that in the menu table the record with id = 1 is missing and not migrated over.  This record is important to the creation of new menu items.

The Solution:  Add the record back into the database.

For example:

  • My database name = MyJoomlaDatabase
  • My prefix is = mjd17_

Follow the steps below to fix this Joomla error message:

1.  Login to your webhosting control panel.

2.  Click on the phpMyAdmin, login to your database

3.  Click on the SQL tab

4.  Copy the query below and paste it in the textbox.  REPLACE the database name and prefix in italics with your own.

INSERT INTO `MyJoomlaDatabase`.`mjd17_menu` (`id` ,`menutype` ,`title` ,`alias` ,`note` ,`path` ,`link` ,`type` ,`published` ,`parent_id` ,`level` ,`component_id` ,`ordering` ,`checked_out` ,`checked_out_time` ,`browserNav` ,`access` ,`img` ,`template_style_id` ,`params` ,`lft` ,`rgt` ,`home` ,`language` ,`client_id` ) VALUES ( ’1′, ”, ‘Menu_Item_Root’, ‘root’, ”, ”, ”, ”, ’1′, ’0′, ’0′, ’0′, ’0′, ’0′, ’0000-00-00 00:00:00′, ’0′, ’0′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘*’, ’0′)

5.  Click on the ‘GO’ button.

After the query successfully inserts a new record in your menu table, test creating a new menu item and you should have no problems.  Also I must stress before you do any upgrades or migration from Joomla versions, you should make backups of your files and database in case anything goes wrong.   In the worst case you can always revert back to your old version.

Thanks,

Elaine

 Joomla Error   Save failed with the following error: JTableMenu:  getNode Failed

Elaine

Elaine is the founder of CmsMind, an online blog providing Joomla and Wordpress tutorials. Elaine lives in Toronto and when she is not online, she is either Marathon and Triathlon training or travelling and racing somewhere in the world. Find her also at: Save Money, Premium Themes and Templates, and at Webhosting Tips.

More Posts - Website

{ 22 comments… read them below or add one }

Lieven Borms August 26, 2011 at 2:29 pm

The original topic can be found at forum.joomla.org /viewtopic.php?p=2585082

Reply

Elaine August 26, 2011 at 5:45 pm

Hi Lieven,
Thanks for your help!!
Elaine

Reply

Kurt September 18, 2011 at 4:15 am

Help with the SQL statement.

I have the same error and was anxious to try the fix you provided but everytime I try, I get an error. I was careful to replace all your quotes with proper quotes but it still won’t work. Could you please take a look at this and tell me what I’ve done wrong?

INSERT INTO ‘kcgroup’.'j17_menu’ (‘id’ ,’menutype’ ,’title’ ,’alias’ ,’note’ ,’path’ ,’link’ ,’type’ ,’published’ ,’parent_id’ ,’level’ ,’component_id’ ,’ordering’ ,’checked_out’ ,’checked_out_time’ ,’browserNav’ ,’access’ ,’img’ ,’template_style_id’ ,’params’ ,’lft’ ,’rgt’ ,’home’ ,’language’ ,’client_id’ ) VALUES ( ’1′, “, ‘Menu_Item_Root’, ‘root’, “, “, “, “, ’1′, ’0′, ’0′, ’0′, ’0′, ’0′, ’0000-00-00 00:00:00′, ’0′, ’0′, “, ’0′, “, ’0′, ’0′, ’0′, ‘*’, ’0′)

thanks!

Reply

Kurt September 18, 2011 at 4:19 am

After I submitted my post I noticed the quoted went all goofy again. If you have a way to post this in a simple text cut and paste I would appreciate that.

Reply

Lieven Borms October 8, 2011 at 5:47 pm

Because some people still struggling with the phpMyAdmin part. I simplified the solution.
You can find the renewed solution at forum.joomla.org/viewtopic.php?f=625&t=632543

Reply

Elaine October 8, 2011 at 6:09 pm

Hi Lieven,
Thanks for letting us know. Very much appreciated!
Elaine

Reply

doze October 19, 2011 at 10:07 pm

Did as you said, i got the following error
#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′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘’ at line 1

Reply

some website November 26, 2011 at 7:34 am

This problem same with me..
#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 ‘primacash1`.`smjaz_menu` (`id` ,`menutype` ,`title` ,`alias` ,`note` ,`path` ,`l’ at line 1
mymanedb`.`smja8_menu` (`id` ,`menutype` ,`title` ,`alias` ,`note` ,`path` ,`link` ,`type` ,`published` ,`parent_id` ,`level` ,`component_id` ,`ordering` ,`checked_out` ,`checked_out_time` ,`browserNav` ,`access` ,`img` ,`template_style_id` ,`params` ,`lft` ,`rgt` ,`home` ,`language` ,`client_id` ) VALUES ( ’1′, ”, ‘Menu_Item_Root’, ‘root’, ”, ”, ”, ”, ’1′, ’0′, ’0′, ’0′, ’0′, ’0′, ’0000-00-00 00:00:00′, ’0′, ’0′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘*’, ’0′)

Reply

xakbox December 18, 2011 at 1:43 pm

am getting this error

#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′, â€

Reply

xakbox December 18, 2011 at 2:10 pm

@for the one who commented above me.

i had tried adding those details manullay and it worked now am able to add new menus, and while doing that the new phpmyadmin created mysql query. (i dont knw wht is difference here, but it worked)

INSERT INTO `database_name`.`database_prefix` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `ordering`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES (’1′, ”, ‘Menu_Item_Root’, ‘root’, ”, ”, ”, ”, ’1′, ’0′, ’0′, ’0′, ’0′, ’0′, ’0000-00-00 00:00:00′, ’0′, ’0′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘*’, ’0′);

Reply

Rafius T.Firefly January 16, 2012 at 12:20 pm

Thanks! it works for me!!

Reply

Elaine January 16, 2012 at 10:43 pm

Hi Rafius,
No problem, glad my post helped you.
Thanks for your visit,
elaine

Reply

Eugene February 24, 2012 at 11:38 am

didnt worked for me too. error #1064 – You have an error in your SQL syntax

Reply

BillRayDrums February 29, 2012 at 10:57 pm

#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

Reply

Klaus Gebhardt May 15, 2012 at 5:36 am

The published SQL statement works if you correct some errors which came from copying.
During copying most single quotes have been changed into a wrong character.
1) In the first part of the SQL statement ALL quotes up to the first closing bracket are “accent grave” which is a single quote (`) from the upper left to the lower right.
2) In the second part up to the second closing bracket, all single quotes are normal ones.
3) Also in the second part ALL double quotes should be two single quotes.

If you make all these changes, the record will be properly inserted.
God luck.
Klaus

Reply

Lordaikins July 9, 2012 at 2:46 pm

Thanx, u just saved me some time…works fine!

Reply

Nikos August 21, 2012 at 8:11 pm

Thanks a lot!! You save me!! I really appreciate!! :)) working also for Joomla 2.5!!

Reply

Vic August 30, 2012 at 4:48 pm

I’m getting an error as well, can anyone answer this?
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′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘*’, ’0′)’ at line 1

Reply

Jaswant Tak October 4, 2012 at 4:34 am

Thanks you so much, for this help.

Reply

Carlotta November 21, 2012 at 11:01 am

Hi, I have this error code:
#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 ”, â€

I tried to change all details like xakbox above but… same problem!

My db details:

MySQL client: 5.1.65
MySQL charset: UTF-8 Unicode (utf8)
Localhost via UNIX socket

Thank you so much! <3

Reply

Carlotta November 22, 2012 at 9:23 am

I’VE FOUND THE SOLUTION!
No more #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 ”, †error!

See code below:

INSERT INTO `db_name`.`db_prefix` (`id` ,`menutype` ,`title` ,`alias` ,`note` ,`path` ,`link` ,`type` ,`published` ,`parent_id` ,`level` ,`component_id` ,`ordering` ,`checked_out` ,`checked_out_time` ,`browserNav` ,`access` ,`img` ,`template_style_id` ,`params` ,`lft` ,`rgt` ,`home` ,`language` ,`client_id` ) VALUES ( ’1′, ”, ‘Menu_Item_Root’, ‘root’, ”, ”, ”, ”, ’1′, ’0′, ’0′, ’0′, ’0′, ’0′, ’0000-00-00 00:00:00′, ’0′, ’0′, ”, ’0′, ”, ’0′, ’0′, ’0′, ‘*’, ’0′)

<3

Reply

Bjoern June 26, 2013 at 8:58 pm

Thanks, that was very helpful!!!

Reply

Leave a Comment

Captcha Captcha Reload

Older Post:

Newer Post: