Joomla · Joomla 1.6 · Joomla 1.7 · Joomla Errors

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

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

23 thoughts on “Joomla Error – Save failed with the following error: JTableMenu: _getNode Failed

  1. 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!

  2. 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.

    1. 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

  3. 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

    1. 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′)

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

  5. @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’);

  6. #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

  7. 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

  8. 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

  9. 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

  10. 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

  11. No more #1064 – Works!
    1) INSERT INTO `db_name`.`prefix_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’)

    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.)

Leave a Reply to Bjoern Cancel reply

Your email address will not be published. Required fields are marked *

Captcha Captcha Reload