Component Menu Items Missing J1.6

armstrongsrus · Post by **armstrongsrus** » Thu Feb 10, 2011 12:30 pm

Is anyone experienceing missing menu items in J1.6?

Ive installed a component seccessfully yet it still doesnt show on the components menu.

eskayel · Post by **eskayel** » Thu Feb 10, 2011 11:26 pm

Yes, I have the same problem. The component in question (Phoca Upload) is installed and has been working fine for two days. It's still working fine but I cannot make any changes to the settings because the menu item is missing from the Components Menu.

Help would be appreciated.

mcsmom · Post by **mcsmom** » Fri Feb 11, 2011 9:48 am

eskayel were you typing the url directly when you were working with it? Or was the menu working earlier?
Also, did you do anything with the ACL for it? Are you a super admin on the site?

eskayel · Post by **eskayel** » Fri Feb 11, 2011 4:44 pm

mcsmom wrote:eskayel were you typing the url directly when you were working with it? Or was the menu working earlier?
Also, did you do anything with the ACL for it? Are you a super admin on the site?

I was not typing the url directly, I was just happily building a site and when I went to change some settings the menu item was gone.

As far as doing something with the ACL - that's the most likely problem, I suppose, since I'm bumbling around in the new version trying to see how it all fits togther. I'm trying to retrace my steps to see if I've some how turned off the access to that menu item in the back end.

I was hoping it would have fixed itself overnight.

mcsmom · Post by **mcsmom** » Fri Feb 11, 2011 5:12 pm

Yeah, sadly the little elves don't always turn up.

If you are logged in as a superadministrator you should be able to see everything in the back end though.

eskayel · Post by **eskayel** » Fri Feb 11, 2011 5:49 pm

mcsmom wrote:Yeah, sadly the little elves don't always turn up.

If you are logged in as a superadministrator you should be able to see everything in the back end though.

Well, I am logged in as Super Admin. I tried reinstalling the component and that put the menu item back where it belongs, but I have to rebuild my categories, etc. Not a big deal, because there was very little in there.

I'm concerned about continuing with the same component. I may have to change direction and look at another option.

mcsmom · Post by **mcsmom** » Fri Feb 11, 2011 6:03 pm

I've not used Phoca Upload, but you should perhaps go to their site and see if they know of any problems.

H13 · Post by **H13** » Wed Feb 16, 2011 9:44 pm

Hi, if the menu of Phoca Gallery or other component is not displayed in Joomla! administration menu, try to run this sql query in your database (it is a code directly for Phoca Gallery)

Code: Select all

UPDATE `jos_menu` 
SET `published` =  '1', 
`component_id` = ( SELECT extension_id 
FROM `jos_extensions` 
WHERE element = 'com_phocagallery' ) 
WHERE `title` LIKE '%phocagallery%';

see:
http://www.phoca.cz/news/30-phoca-news/ ... 6-released

Not displaying a component menu happened in some of Joomla! RC and some specific Joomla! installations like some German installation.

I still don't know what is wrong there, becasue the installation XML of Phoca Gallery is OK and it is installed normally on most servers. But on some (RC or specific Joomla! installation) the published is set to NULL instead of 1 in jos_menu.

Really no idea who or what makes the extension unpublished in the the jos_menu table??? The component includes standard installation XML (extension XML) and is installable in standard Joomla! Extension Manager.

Jan

mcsmom · Post by **mcsmom** » Thu Feb 17, 2011 3:30 am

Jan can you please ask that on the general dev list? I'm sure it will be helpful to a lot of people for someone to tell you this.

H13 · Post by **H13** » Fri Feb 18, 2011 2:46 pm

h2mao · Post by **h2mao** » Wed Mar 02, 2011 11:18 pm

Meet the same problem, unsure what had happened.

h2mao · Post by **h2mao** » Wed Mar 02, 2011 11:22 pm

All the component looks working fine at the moment when I trying to type the url manually.
For instance:
administrator/index.php?option=com_contact
administrator/index.php?option=com_redirect
.....

But all the component menu disappeared.

jaammes · Post by **jaammes** » Wed Mar 09, 2011 12:13 pm

I've exactly the same problem.

Component working fine, with url direct access.

But they are not showing in the administrator component menu.

Any idea how to solve the problem?

jaammes · Post by **jaammes** » Wed Mar 09, 2011 12:17 pm

Actually, my problem is a little differrent:

The component menu itself is ok. It is the drop-down menu that is incomplete. See print screen attached.

mcsmom · Post by **mcsmom** » Wed Mar 09, 2011 2:36 pm

Are the links in the menu table of the database?

jaammes · Post by **jaammes** » Wed Mar 09, 2011 3:13 pm

Do you mean: jos_menu with menutype == main ?

In this case, component entry are missing.

I did some intensive menu "move" recently. Is it possible that the "menutype == main" where deleted?

mcsmom · Post by **mcsmom** » Wed Mar 09, 2011 9:24 pm

In 1.6 unlike 1.5 the back end menu items are in the menu tables. They should be the first big group in the table. If they are missing you probably can import them if you download a fresh zip file and get joomla.sql out of the installation/sql folder. You can find the relevant lines there.

h2mao · Post by **h2mao** » Thu Mar 10, 2011 1:56 am

mcsmom wrote:In 1.6 unlike 1.5 the back end menu items are in the menu tables. They should be the first big group in the table. If they are missing you probably can import them if you download a fresh zip file and get joomla.sql out of the installation/sql folder. You can find the relevant lines there.

Champion!!!

All the admin component menu are menutype="menu".

I've run this SQL and all sorted.

Code: Select all

INSERT INTO `#__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
(2, 'menu', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 0, 1, 1, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 1, 10, 0, '*', 1),
(3, 'menu', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1),
(4, 'menu', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', 0, 2, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1),
(5, 'menu', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1),
(6, 'menu', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1),
(7, 'menu', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 0, 1, 1, 8, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 11, 16, 0, '*', 1),
(8, 'menu', 'com_contact', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact', 'component', 0, 7, 2, 8, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 12, 13, 0, '*', 1),
(9, 'menu', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&extension=com_contact', 'component', 0, 7, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact-cat', 0, '', 14, 15, 0, '*', 1),
(10, 'menu', 'com_messages', 'Messaging', '', 'Messaging', 'index.php?option=com_messages', 'component', 0, 1, 1, 15, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages', 0, '', 17, 22, 0, '*', 1),
(11, 'menu', 'com_messages_add', 'New Private Message', '', 'Messaging/New Private Message', 'index.php?option=com_messages&task=message.add', 'component', 0, 10, 2, 15, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-add', 0, '', 18, 19, 0, '*', 1),
(12, 'menu', 'com_messages_read', 'Read Private Message', '', 'Messaging/Read Private Message', 'index.php?option=com_messages', 'component', 0, 10, 2, 15, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-read', 0, '', 20, 21, 0, '*', 1),
(13, 'menu', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 1, 1, 17, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 23, 28, 0, '*', 1),
(14, 'menu', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 13, 2, 17, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 24, 25, 0, '*', 1),
(15, 'menu', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&extension=com_newsfeeds', 'component', 0, 13, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds-cat', 0, '', 26, 27, 0, '*', 1),
(16, 'menu', 'com_redirect', 'Redirect', '', 'Redirect', 'index.php?option=com_redirect', 'component', 0, 1, 1, 24, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:redirect', 0, '', 37, 38, 0, '*', 1),
(17, 'menu', 'com_search', 'Search', '', 'Search', 'index.php?option=com_search', 'component', 0, 1, 1, 19, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:search', 0, '', 29, 30, 0, '*', 1),
(18, 'menu', 'com_weblinks', 'Weblinks', '', 'Weblinks', 'index.php?option=com_weblinks', 'component', 0, 1, 1, 21, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 31, 36, 0, '*', 1),
(19, 'menu', 'com_weblinks_links', 'Links', '', 'Weblinks/Links', 'index.php?option=com_weblinks', 'component', 0, 18, 2, 21, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 32, 33, 0, '*', 1),
(20, 'menu', 'com_weblinks_categories', 'Categories', '', 'Weblinks/Categories', 'index.php?option=com_categories&extension=com_weblinks', 'component', 0, 18, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks-cat', 0, '', 34, 35, 0, '*', 1);

h2mao · Post by **h2mao** » Thu Mar 10, 2011 2:01 am

Be aware, you need to remove this 2 records if you get the SQL from installation folder, since you may have already done a lot of modifications:
1, '', 'Menu_Item_Root', 'root'
101, 'mainmenu', 'Home', 'home'

Highly recommended: Check your Database before you run the SQL, make sure id 2-20 are missing.

I reckon the reason of admin menu missing may related with install/uninstall components.

jaammes · Post by **jaammes** » Thu Mar 10, 2011 12:23 pm

Thanks!

I ran the sql query provided by h2mao and everything is sorted!

enbsp · Post by **enbsp** » Fri Apr 15, 2011 6:50 pm

Boys, I tryed to run the SQL posted on Thu Mar 10, 2011 1:56 am but I receive the following message from phpMyAdmin:

#1146 - Table 'databasename.#__menu' doesn't exist

and, of course, didn't resolve the problem.

Can you help me please?

mcsmom · Post by **mcsmom** » Fri Apr 15, 2011 9:42 pm

Do you have a table called something_menu?

enbsp · Post by **enbsp** » Fri Apr 15, 2011 10:03 pm

I have jos_menu

mcsmom · Post by **mcsmom** » Sat Apr 16, 2011 1:51 am

Change #__menu to jos_menu in the query.

enbsp · Post by **enbsp** » Sat Apr 16, 2011 9:24 am

Great!
I changed #--menu to jos_menu, phpMyAdmin applied the Query and now it's all ok!

Many thanks.

rosariopa · Post by **rosariopa** » Tue Apr 19, 2011 2:47 pm

Hi,
i've just tried H2mao method, but SQL don't run the insert query... when i try, it response

Code: Select all

Errore

query SQL:

INSERT INTO `jos_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 ( 2, 'menu', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 0, 1, 1, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 1, 10, 0, '*', 1 ) , ( 3, 'menu', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1 ) , ( 4, 'menu', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', 0, 2, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1 ) , ( 5, 'menu', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1 ) , ( 6, 'menu', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 0, 2, 2, 4, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1 ) , ( 7, 'menu', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 0, 1, 1, 8, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 11, 16, 0, '*', 1 ) , ( 8, 'menu', 'com_contact', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact', 'component', 0, 7, 2, 8, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 12, 13, 0, '*', 1 ) , ( 9, 'menu', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&extension=com_contact', 'component', 0, 7, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact-cat', 0, '', 14, 15, 0, '*', 1 ) , ( 10, 'menu', 'com_messages', 'Messaging', '', 'Messaging', 'index.php?option=com_messages', 'component', 0, 1, 1, 15, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages', 0, '', 17, 22, 0, '*', 1 ) , ( 11, 'menu', 'com_messages_add', 'New Private Message', '', 'Messaging/New Private Message', 'index.php?option=com_messages&task=message.add', 'component', 0, 10, 2, 15, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-add', 0, '', 18, 19, 0, '*', 1 ) , ( 12, 'menu', 'com_messages_read', 'Read Private Message', '', 'Messaging/Read Private Message', 'index.php?option=com_messages', 'component', 0, 10, 2, 15, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-read', 0, '', 20, 21, 0, '*', 1 ) , ( 13, 'menu', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 1, 1, 17, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 23, 28, 0, '*', 1 ) , ( 14, 'menu', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 13, 2, 17, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 24, 25, 0, '*', 1 ) , ( 15, 'menu', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&extension=com_newsfeeds', 'component', 0, 13, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds-cat', 0, '', 26, 27, 0, '*', 1 ) , ( 16, 'menu', 'com_redirect', 'Redirect', '', 'Redirect', 'index.php?option=com_redirect', 'component', 0, 1, 1, 24, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:redirect', 0, '', 37, 38, 0, '*', 1 ) , ( 17, 'menu', 'com_search', 'Search', '', 'Search', 'index.php?option=com_search', 'component', 0, 1, 1, 19, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:search', 0, '', 29, 30, 0, '*', 1 ) , ( 18, 'menu', 'com_weblinks', 'Weblinks', '', 'Weblinks', 'index.php?option=com_weblinks', 'component', 0, 1, 1, 21, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 31, 36, 0, '*', 1 ) , ( 19, 'menu', 'com_weblinks_links', 'Links', '', 'Weblinks/Links', 'index.php?option=com_weblinks', 'component', 0, 18, 2, 21, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 32, 33, 0, '*', 1 ) , ( 20, 'menu', 'com_weblinks_categories', 'Categories', '', 'Weblinks/Categories', 'index.php?option=com_categories&extension=com_weblinks', 'component', 0, 18, 2, 6, 0, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks-cat', 0, '', 34, 35, 0, '*', 1 ) ;

Messaggio di MySQL: Documentazione
#1062 - Duplicate entry '2' for key 1

When i try to enter on admin menu, i see just this page

joomroz · Post by **joomroz** » Fri Apr 22, 2011 11:09 am

Got similar problem with my j16.3 italian.
in components administrator menu I got only...
admin tools
akeeba backup.

I was going mad searching "contacts" creation menu!!
then found the contacts menu item is missing.
yet I can reach it manually browsing to:
administrator/index.php?option=com_contact
the contact component seems to be there...
but can't show it otherwise.

I attached a screenshot of my components menu.

do you think I should try the sql solution?
which is the final suggested insert sequence?

it would be useful to track which extension did whipe the components menu, if one.
I've installed recently phoca gallery, phoca_noob, simple image gallery, akeeba backup and admin tools.

UPDATE: followed the sql insert command suggested, and everything works fine now.
see the second attached image. thanks guys!

uaintgotthisid · Post by **uaintgotthisid** » Tue May 03, 2011 6:22 pm

rosariopa did you find a solution? I've got the same screenshot on my screen in English right now! I guess you could rule out the language file (at least preliminarily). Besides I haven't changed anything there as far as I know. I was fiddling with user prividleges.

rosariopa · Post by **rosariopa** » Wed May 04, 2011 8:12 am

uaintgotthisid wrote:rosariopa did you find a solution? I've got the same screenshot on my screen in English right now! I guess you could rule out the language file (at least preliminarily). Besides I haven't changed anything there as far as I know. I was fiddling with user prividleges.

HI uaintgotthisid, Unfortunately... no solution.
I installed a new copy of joomla, tried to copy admin rights db table in old copy but nothing... so i deleted everything and i reinstalled a fresh 1.6.3 version.

uaintgotthisid · Post by **uaintgotthisid** » Wed May 04, 2011 8:26 am

Its something to do with acl. It seems to be the special user group. There are other posts about this on here but I still didn't solve my problem.

The Joomla! Forum™

Component Menu Items Missing J1.6

Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6

Re: Component Menu Items Missing J1.6