Joomla Templates Club 406,261 posts

[protechsb Friend protechsbJoin date: December 2011Posts: 5Downloads:0Uploads:0]

#172759

Trying to add a menu item to my main menu, and getting this error.

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

Tried running the SQL query

INSERT INTO `pro0927412203921`.`jos_menu` (`menutype` ,`name` ,`alias` ,`link` ,`type` ,`published` ,`parent` ,`componentid` ,`sublevel`,`ordering` ,`checked_out`,`checked_out_time` ,`pollid`, `browserNav` ,`access` , `utaccess`, `params` ,`lft` ,`rgt` ,`home` ) VALUES ( ”, ‘Menu_Item_Root’, ‘root’, ”, ”, ‘1’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0000-00-00 00:00:00’, ”, ‘0’, ‘0’, ”, ”, ‘0’, ‘0’, ‘0’)

the query executed, but the menu problem isn’t fixed. Any ideas. Website is protechsb.com

[TomC Moderator TomCJoin date: October 2014Posts: 14077Downloads:58Uploads:137 Thanks: 948 Thanked: 3155 times in 2495 posts]

#433760

Greetings:

Just to try to clarify … you want to add a menu item to your main navigation menu, correct?

And you have tried to do this via your Menu Manager within your site administration?

[protechsb Friend protechsbJoin date: December 2011Posts: 5Downloads:0Uploads:0]

#433791

exactly, but when i do try, i get the error listed above. I read other posts, and found other people mentioning a query add in on the sql database. I tweaked it for the joomla 1.7 menu table, but still had no luck, and the error remained…

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#433808

Try the following syntax

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′);

[protechsb Friend protechsbJoin date: December 2011Posts: 5Downloads:0Uploads:0]

#433841

didn’t like the syntax of that in the checked_out_time value. When I took that field out altogether, it then came back with an unknown column title in field list error.

FYI- I don’t have theses same fields in my _menu table. They’re a bit different, and some are missing altogether. For instance, instead of having a title field, i have a name field. Does this have something to do with it?

Thanks…

[Phill Moderator PhillJoin date: February 2014Posts: 7013Downloads:40Uploads:77 Thanks: 917 Thanked: 2206 times in 1818 posts]

#433843

Hmm, assuming jupgrade was used here? Then maybe just install the QuickStart locally and compare your tables.

[protechsb Friend protechsbJoin date: December 2011Posts: 5Downloads:0Uploads:0]

#433882

User error, thanks for the help! Was in my site’s old database…obviously not going to do anything! Thks!

[Author]

Posts