Admin Components Menu Disappeared

Question:
So, in my default admin template. The Components Menu drop down has now practically disappeared. The normal Banners, Contacts, etc., Weblinks has now been truncated to just two drop downs! I didn't do any changing on the admin template. I'm not sure where to fix this!
Please, any assistance is appreciated.
Running Joomla 1.6.3 on Linux, PHP 5.2.16, MySQL 5.0.92.

Original:
Image

Problem!:
Image
Answers
I am having the same issue - kind of...

I created a second menu for a site, and for some reason a pile of the admin menus have got tied to it. In the menu manager I see i have 19 "unpublished" menu items, but nothing shows up when I try to see them in the menu manager.

However, when I go to any part of the admin area that shows menu items, I get my main menu items showing up just fine - and then on the second menu I have the one item i created and a HUGE pile of items that reads as follows:

- com_banners
- - com_banners
- - com_banners_categories
- - com_banners_clients
- - com_banners_tracks
- com_contact
- - com_contact
- - com_contact_categories
- com_messages
- - com_messages_add
- - com_messages_read
- com_newsfeeds
- - com_newsfeeds_feeds
- - com_newsfeeds_categories
- com_search
- com_weblinks
- - com_weblinks_links
- - com_weblinks_categories
- com_redirect

Obviously all items that correspond to the admin menu.

I went into my MySQL db via phpMyAdmin (I build offline using MAMP) and deleted the menu items, and lo and behold the Components menu of the admin section is emptied of everything - except any 3rd part extensions I have installed.

I did nothing out of the ordinary to make all those "unpublished" menu items show up - I've been using Joomla 1.5 since 2008 and never had a problem like this, especially on so basic a site (essentially a blog). This may be a 1.6 issue that needs addressing.

For now I will have to put up with this log list of items (why "unpublished" items show up in the assignment fields of the modules I'm working with is beyond me) as i have to get the site up and I doubt the client will notice these since they are dealing with articles. However any suggestion as to a) why it's happening and b) how to fix it without re-building the site from scratch would be useful.
I get the same as you describe I'm pretty much stuck. I've done nothing today but edit articles and edited a contact today too. Now I can't get the basic componants showing in the component menu
A similar thing happened to me. I created a menu and for some odd reason, there were 19 unpublished items associated with it. I attempted to view the items, however, they didnt appear under the menu items.

I subsequently deleted the menu and thats when I noticed that the admin menu under components had nothing other than the thrid party extensions I had installed.

Quick fix:
1. open the joomla.sql file in the joomla 1.6installationsqlmysql folder
2. Find the "Insert into '#_menu'" data
3. copy the entire section (looks to be about 22 rows)
4. open phpmyadmin
5. select the jos_menu table
6. Click the 'SQL' tab
7. paste the information copied from the joomla.sql file
8. remove the information for the 'Menu Item Root' and the 'mainmenu' leaving only those with a menutype of "menu"
9. Click Go and Voila!

All admin components are restored.

Ofcourse, it goes without saying to back up anything before you make changes.

Hope this helps!
thanks I'll give it a go
I have the same problem. My administrator component menu disappeared while I was creating a new menu and editing articles.

Is there a way to fix this permanently. The quick fix won't last very long if we don't know what is causing it.

Can anyone help please ?
Hi chynawhyte2,

Thank you very much for your guideline. I've had exactly the same problem and your advice of re-inserting the missing menu items from a fresh downloaded Joomla SQL did the trick.

The exact SQL insert statement in my case (Joomla 1.6) was the following:

Code:
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);


Thanks again!
same problem - i tried too and got thia "Table '****_jml1.jos_menu' doesn't exist

please help
ginatnoy wrote:
same problem - i tried too and got thia "Table '****_jml1.jos_menu' doesn't exist

please help

fixed and upload - now it gives me #1062 - Duplicate entry '2' for key 'PRIMARY'
andrewpep wrote:
I figured out the fix, though not the reason for the problem.
Grabbed the menutype "menu" in jos_menu in my backup mysql database. Imported them into current database. There were 7 lines missing, seems to fix the issue.
Anyone else come across this, and know why it happened to begin with?


I am in the same boat, I fixed it, but I would like to know how this is occuring...any ideas?
Well, i tried few ways to solve , especialy when i understood that the reason - why - is less important .
yot can try pass all sql tabels , and all php.index and all *.xml - to find what is wrong.
The best solution i can give to you is to install a new back-end menu modul .

I did it , and thats is . what does it matter about menu design and color when it is works ?

Ariel
http://ginatnoy.co.il
That's a Smart Move! Economy Hosting for $1.99/mo.