I recently updated admin_menu to the latest version. I had the wrong version of Views installed so I updated it to the most up to date (which doesn't work) and then downgraded it to the latest dev of Views 2.x.

It is now missing the majority of admin links on my admin_menu bar and in my Navigation block. I cleared all the caches in Performance, Admin_Menu, and the rows in the db tables "cache", "cache_admin_menu", and "cache_menu". Those might not be word for word but you get the idea.

Admin Menu (Currently, with no more errors): http://tinypic.com/r/m79etv/5
Navigation Block: http://tinypic.com/r/efl7qt/5
Admin Page: http://tinypic.com/r/mmwiz7/5 Lots of settings are missing.
Admin Page (By Module): http://tinypic.com/r/28vbm7o/5 - All modules are listed!

When I go to the admin page, I do see a few links with a grey/glow background: http://tinypic.com/r/qozo0z/5

I'm not sure what I'm missing here.

Drupal: 6.16
Theme: Acquia Marina 6.x-3.0-alpha2 & Fusion (Both up to date)
Modules: I honestly have over 80 additional modules installed, mainly Ubercart (for user account recurring subscriptions) and Organic Groups. It's a community website.

CommentFileSizeAuthor
#11 Picture 23.png296.72 KBValerieCBL
#11 Picture 24.png578.02 KBValerieCBL
#5 Untitled-112312.jpg66.12 KBbwv
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

JCOFFEY’s picture

JCOFFEY CreditAttribution: JCOFFEY commented

As a side note, I am doing this from the user 1 so I don't foresee permissions being an issue.

JCOFFEY’s picture

JCOFFEY CreditAttribution: JCOFFEY commented

I DO have all the admin. links back in the Navigation Block. It was caused by the MySQL Max_Allowed_Packet being set too low and not being able to cache correctly.

However, when I upgrade from admin_menu 1.5 to alpha4.. I lose the admin links and just get links for a handful of my modules.

JCOFFEY’s picture

JCOFFEY CreditAttribution: JCOFFEY commented
Status: Active » Fixed

After about 8 hours of consecutive debugging and researching, I don't know what caused the error. However, I got everything resolved by using the following SQL Query:

DELETE FROM menu_links WHERE router_path LIKE 'admin%';

Then I used the "Flush All Caches" command from the admin_menu toolbar and when it reloaded, everything was where it was suppose to be.

(Side note: Most of the core admin links, including "Site Building", "User Management", etc were first enabled, but located under a menu link called (disabled) which I'm assuming used to be "Administer". There were not visible until I moved them above the (disabled) link item. I also had to set the MySQL variable of Max_Allowed_Packet from the default of (I believe) 1M to a higher amount to get the menu cache to properly work. From there, I found out that only admin links located under the "Administer" parent link now located in the "Administrative Menu" shows up in /admin under By Tasks. As I said, once I used the MySQL Query (DELETE FROM menu_links WHERE router_path LIKE 'admin%';) without the ( )'s and flushed all caches (effectively the 'menu cache' and 'admin menu cache'), everything was where it was supposed to be.

I hope no one else experiences this but if they do, this should work!

bwv’s picture

bwv CreditAttribution: bwv commented
FileSize
Untitled-112312.jpg66.12 KB

Just wondering if you can confirm that your solution applies in my case. Please see attached image, showing no links whatsoever on menu bar. Thanks.

I can confirm that the solution described above works when your admin menu toolbar is completely blank.

@ E7-JCOFFEY: Thanks for posting your research. regards

adamo’s picture

adamo CreditAttribution: adamo commented

I had the same problem but in my case the cause/solution was different. I tried everything to get this thing to work, and then I took a look in my menu_links table and noticed a had a link in the 'navigation' menu with no link_path and no router_path. Not sure where that came from but after I deleted it from the table I was able to upgrade to 3.0-alpha4 from 1.5 and everything is still there! :)

Netbuddy’s picture

Netbuddy CreditAttribution: Netbuddy commented

#4 - You're a life saver! the sql and flush worked, bit scary there for a minute.

opi’s picture

opi
Primary language French
CreditAttribution: opi commented

E7-JCOFFEY thanks a lot ! it works

boabjohn’s picture

boabjohn CreditAttribution: boabjohn commented

Variation on a theme: admin bar alpha4 with Toolbar theme suddenly stopped showing any Organic Groups items. All other menus running fine.

Bewildered I checked that the modules were still enabled (yes) tried turning them on and off/flushing cache (no change), checked that the menu entires existed in the menu managememnt interface (yes), and finally found this thread. Ran SQL, flushed cache, all good.

Even though I did not have an empty menu and was only missing one branch of the menu, the technique from #7 E7-COFFEY worked a treat. Thanks!

Now: what is causing this and how to clean up alpha4 for real world duties?

boabjohn’s picture

boabjohn CreditAttribution: boabjohn commented
Status: Fixed » Needs work

Shifting this back to live... Would that be right? Nothing has been fixed: we've just got a handy technique to reset the menu_link table...but the cause /fix has not actually been identified.

ValerieCBL’s picture

ValerieCBL CreditAttribution: ValerieCBL commented
Version: 6.x-3.0-alpha4 » 6.x-1.0
FileSize
Picture 24.png578.02 KB
Picture 23.png296.72 KB

Hi!

I'm so glad I stumbled upon your thread. I'm having the same trouble. The only links that show up in my navigation bar are "admin" and "logout". However, when I click admin, I get a message that states "You do not have any administrative items". But, I'm user 1 (the admin).

After reading your threads, I tried the MySQL query that E7-JCOFFEY suggested:
DELETE FROM menu_links WHERE router_path LIKE 'admin%';

However, after running it, I get a message stating that no rows have been found. Do I flush the caches from within PHP Admin, next? Or, should I see the navigation links by now and do the flush from "Performance" within Drupal? If it's the latter, then I'm out of luck as I don't see any new links in the navigation bar or the "admin" page.

I hope you can please help me with this. I'm completely baffled as to what the issue is and why the links disappeared.

Thank you,
Valerie

SKAUGHT’s picture

SKAUGHT
Primary language English
CreditAttribution: SKAUGHT commented

cheers to #4, E7-JCOFFEY. this has fixed it for me. note to others include db_prefix — if, like me you're using one...

nemchenk’s picture

nemchenk CreditAttribution: nemchenk commented

#4 fixed it for me :] Many thanks!

achton’s picture

achton
Location Denmark
CreditAttribution: achton commented

I can confirm that #4 works as well. 690 rows deleted in my case.

dezen’s picture

dezen CreditAttribution: dezen commented

Thanks for the trick, I did help as described! The more important fact is that it will not touch anything other the admin menu. Clearing all menu_links will remove all other navigationn entries.

ressa’s picture

ressa CreditAttribution: ressa commented

Thank you E7-JCOFFEY (post #4) - it is very unnerving to see the system collapse, for no reason.

sun’s picture

sun
Primary language German
Location Karlsruhe
CreditAttribution: sun commented
Priority: Critical » Normal
Status: Needs work » Closed (won't fix)

The original issue was against 3.x. Most recent follow-ups are about 1.x, but the entire implementation and technical design of 1.x is flawed and cannot be fixed.

willk’s picture

willk CreditAttribution: willk commented

Is tinypic.com all drupal?