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,
The original topic can be found at forum.joomla.org /viewtopic.php?p=2585082
Hi Lieven,
Thanks for your help!!
Elaine
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!
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.
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
Hi Lieven,
Thanks for letting us know. Very much appreciated!
Elaine
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
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′)
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′, â€
@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’);
Thanks! it works for me!!
Hi Rafius,
No problem, glad my post helped you.
Thanks for your visit,
elaine
didnt worked for me too. error #1064 – You have an error in your SQL syntax
#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
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
Thanx, u just saved me some time…works fine!
Thanks a lot!! You save me!! I really appreciate!! :)) working also for Joomla 2.5!!
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
Thanks you so much, for this help.
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
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
Thanks, that was very helpful!!!
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.)