I am struggling with Admin Menu like I've never struggled with anything before on Drupal.

I have received multiple errors over the last year that are as long as this but with different warnings:

user warning: Duplicate entry 'sites/all/themes/sky/sky.info' for key 'PRIMARY' query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('sky', 'themes/engines/phptemplate/phptemplate.engine', 'a:14:{s:4:\"name\";s:3:\"Sky\";s:11:\"description\";s:117:\"Sky is a center aligned, fixed or fluid theme that supports either all sidebar combinations (left, right, both, none)\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:10:\"contenttop\";s:11:\"Content top\";s:13:\"contentbottom\";s:14:\"Content bottom\";s:13:\"contentfooter\";s:14:\"Content footer\";}s:11:\"stylesheets\";a:1:{s:3:\"all\";a:3:{s:14:\"css/layout.css\";s:35:\"sites/all/themes/sky/css/layout.css\";s:9:\"style.css\";s:30:\"sites/all/themes/sky/style.css\";s:16:\"system-menus.css\";s:37:\"sites/all/themes/sky/system-menus.css\";}}s:7:\"scripts\";a:3:{s:22:\"scripts/hoverIntent.js\";s:43:\"sites/all/themes/sky/scripts/hoverIntent.js\";s:20:\"scripts/superfish.js\";s:41:\"sites/all/themes/sky/scripts/superfish.js\";s:14:\"scripts/sky.js\";s:35:\"sites/all/themes/sky/scripts/sky.js\";}s:8:\"settings\";a:16:{s:14:\"sky_background\";s:0:\"\";s:21:\"sky_background_header\";s:0:\"\";s:15:\"sky_breadcrumbs\";s:1:\"0\";s:19:\"sky_breadcrumbs_sep\";s:7:\"»\";s:9:\"sky_links\";s:0:\"\";s:16:\"sky_links_active\";s:0:\"\";s:15:\"sky_links_hover\";s:0:\"\";s:17:\"sky_links_visited\";s:0:\"\";s:8:\"sky_font\";s:6:\"lucida\";s:17:\"sky_font_headings\";s:6:\"lucida\";s:13:\"sky_font_size\";s:4:\"12px\";s:17:\"sky_header_height\";s:5:\"100px\";s:10:\"sky_layout\";s:9:\"fixed_960\";s:17:\"sky_custom_layout\";s:0:\"\";s:17:\"sky_nav_alignment\";s:6:\"center\";s:24:\"sky_sub_navigation_width\";s:4:\"15em\";}s:7:\"version\";s:8:\"6.x-3.10\";s:7:\"project\";s:3:\"sky\";s:9:\"datestamp\";s:10:\"1264385706\";s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_links\";i:9;s:15:\"secondary_links\";}s:10:\"screenshot\";s:35:\"sites/all/themes/sky/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'sites/all/themes/sky/sky.info', 0, 0, 0) in /Users/Cale/Sites/acquia-drupal/modules/system/system.module on line 822.

As an example, Another type of warning message might be this (though i haven't seen this in a while):

• user warning: Duplicate entry 'admin/content/node-type/company-staff-directory/fields/field_pho' for key 'PRIMARY' query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/content/node-type/company-staff-directory/fields/field_photo_co_staff_directory/remove', '', '', 'user_access', 'a:1:{i:0;s:24:\"administer content types\";}', 'drupal_get_form', 'a:3:{i:0;s:25:\"content_field_remove_form\";i:1;s:23:\"company_staff_directory\";i:2;s:30:\"field_photo_co_staff_directory\";}', 127, 7, '', 'admin/content/node-type/company-staff-directory/fields/field_photo_co_staff_directory/remove', 'Remove field', 't', '', 4, '', '', '', 0, 'sites/all/modules/cck/includes/content.admin.inc') in /Users/Cale/Sites/acquia-drupal/includes/menu.inc on line 2457.

Today, I updated a couple modules, all unrelated to one another.. small ones... and started getting the Error Message (1st one above) on just about every page. I deleted multiple theme folders that I wasn't using, cleared cache and ran cron. The error message persisted. . and I realized it was always present because my pages ran slower today... an example is a blank white screen while loading EVERY new page. Peculiar though for the first time, I was unable to keep any enabled themes of my chosen themes in theme configuration. Each time I would go to the user's account and click Edit Account, I was unable to find their theme configuration--and this was a result of the themes automatically disabling themselves as a result of the duplicate Warning Message.

I disabled Admin Menu and the error message went away. But my pages ran slower still. I re-enabled Admin Menu, cleared cache and my pages ran fine again... Well, then I updated the date module, ran update and got the same error message... disabled Admin Menu and error went away. But pages still ran slow!

So I updated Admin Menu to 1.6 and got this error:
user warning: Table 'acquia_drupal.cache_admin_menu' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache_admin_menu WHERE cid = 'admin_menu:1:en' in /Users/Cale/Sites/acquia-drupal/includes/cache.inc on line 26.

I disabled Admin Menu... then I installed and enabled the 6.x-3.0-alpha4 version...

Received this error again:

user warning: Table 'acquia_drupal.cache_admin_menu' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache_admin_menu WHERE cid = 'admin_menu:1:en' in /Users/Cale/Sites/acquia-drupal/includes/cache.inc on line 26.

went to updates page and saw this error:

user warning: Table 'acquia_drupal.cache_admin_menu' doesn't exist query: UPDATE cache_admin_menu SET data = 'bf92a09aa265cfa2a43399adfcd320ac', created = 1295477905, expire = 0, headers = '', serialized = 0 WHERE cid = 'admin_menu:1:en' in /Users/Cale/Sites/acquia-drupal/includes/cache.inc on line 109.

Stupidly clicked update:

The following queries were executed
admin_menu module
Update #6300
• CREATE TABLE {cache_admin_menu} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
Update #6301
• Menu for Administration menu already exists.
• DELETE FROM {menu_links} WHERE module = 'admin_menu' OR menu_name = 'admin_menu'
Update #6302
• UPDATE {system} SET weight = 100 WHERE name = 'admin_menu'




Went to frontpage... only saw organic groups in my header of admin menu

refreshed the page and admin menu disappeared.

Cleared cache and only 1st column appeared along with Organic Groups... and the logout options appeared in right side of bar.

Run cron again

Admin Menu disappears. Along with drupal core Administer link in left side bar

Now I am left with absolutely no administration menu. Everything is gone. And I have no idea how to get it back. So I have to go back to a backup install and redo my site so i can get it back to core Administration Menu back to normal.



However, now my themes are not staying enabled. Everything is messed up. . And when I reinstall my previous saved drupal site on my localhost I face the same exact problems... my only solution is to disable Admin Menu from now on :(

Comments

sun’s picture

Priority: Major » Normal
Status: Active » Postponed (maintainer needs more info)

What version of Drupal core are you running?

calefilm’s picture

Drupal 6.16 I did get my administration menu back by the way, admin/build/menu-customize/admin_menu however my admin page is empty as is my left core drupal Administer sidebar.. I go to Navigation but I can't place my Content Management, Site Building links back into the Administer Menu... So looks like I have to install a backup..

A a lot of strange things happen [to my installation] with this module installed.

sun’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)

To fix the issue of disabled themes, you need to update to the latest version of Drupal 6 core.

The missing cache_admin_menu errors can only be caused by running admin_menu 3.x code without running update.php. 1.x doesn't use that table and doesn't contain any reference to it.

calefilm’s picture

apologize. I'm running Drupal 6.19. Will update to Drupal 6.2

calefilm’s picture

Problem persists. I got drupal 6.2 working but the thing is-- my installation [from what i can tell] has a problem with Admin_Menu enabled; both version 1.5, and 1.6; I keep getting this duplication error:

user warning: Duplicate entry 'sites/all/themes/colourise/colourise.info' for key 'PRIMARY' query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('colourise', 'themes/engines/phptemplate/phptemplate.engine', 'a:13:{s:4:\"name\";s:9:\"Colourise\";s:11:\"description\";s:130:\"Dark tableless design with valid XHTML/CSS. Visit <a href=\"http://webzer.net/tags/colourise\">Webzer.net</a> for more informations.\";s:7:\"version\";s:7:\"6.x-2.1\";s:4:\"core\";s:3:\"6.x\";s:6:\"engine\";s:11:\"phptemplate\";s:10:\"screenshot\";s:48:\"sites/all/themes/colourise/images/screenshot.png\";s:7:\"regions\";a:7:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:11:\"content_top\";s:11:\"Top Content\";s:14:\"content_bottom\";s:14:\"Bottom Content\";s:8:\"footer_1\";s:14:\"Footer Block 1\";s:8:\"footer_2\";s:14:\"Footer Block 2\";s:8:\"footer_3\";s:14:\"Footer Block 3\";}s:8:\"features\";a:8:{i:0;s:4:\"name\";i:1;s:6:\"slogan\";i:2;s:7:\"mission\";i:3;s:6:\"search\";i:4;s:7:\"favicon\";i:5;s:13:\"primary_links\";i:6;s:17:\"node_user_picture\";i:7;s:20:\"comment_user_picture\";}s:11:\"stylesheets\";a:2:{s:3:\"all\";a:7:{s:13:\"css/reset.css\";s:40:\"sites/all/themes/colourise/css/reset.css\";s:16:\"css/baseline.css\";s:43:\"sites/all/themes/colourise/css/baseline.css\";s:18:\"css/typography.css\";s:45:\"sites/all/themes/colourise/css/typography.css\";s:14:\"css/layout.css\";s:41:\"sites/all/themes/colourise/css/layout.css\";s:15:\"css/modules.css\";s:42:\"sites/all/themes/colourise/css/modules.css\";s:20:\"css/system-menus.css\";s:47:\"sites/all/themes/colourise/css/system-menus.css\";s:17:\"css/colourise.css\";s:44:\"sites/all/themes/colourise/css/colourise.css\";}s:5:\"print\";a:1:{s:13:\"css/print.css\";s:40:\"sites/all/themes/colourise/css/print.css\";}}s:7:\"project\";s:9:\"colourise\";s:9:\"datestamp\";s:10:\"1240770912\";s:7:\"scripts\";a:1:{s:9:\"script.js\";s:36:\"sites/all/themes/colourise/script.js\";}s:3:\"php\";s:5:\"4.3.5\";}', 'theme', 'sites/all/themes/colourise/colourise.info', 0, 0, 0) in /Users/Cale/Sites/acquia-drupal/modules/system/system.module on line 822.


And for the life of me, now I can't keep my themes enabled!

unless I disable Administration Menu. this is my only way out of this--the theme configuration less error messages work so long as I disable Admin Menu

reference: http://drupal.org/node/477550 (#8: "Issue is caused by system_theme_data dropping all records from {system} and re-inserting them. If this happens while another request is being made, it causes a race condition and duplicate inserts.")



Wish I understood more to resolve this issue on my own but I don't understand Drupal past what I've already done to simply get my site up and running on a localhost

calefilm’s picture

UPDATE:

After disabling Admin Menu...

I disabled "NAVIGATION" module which was not working. This module is in the upper left-hand top of the page.. It wasn't functioning correctly. Don't know why--don't care. I disabled it.

Next, I uninstalled a few unnecessary modules I wasn't using and deleted their folders.

Noticed My localhost site started performing faster without the blank pages...

I re-enabled Admin Menu and haven't seen the errors as of yet, but am most excited that my theme configuration is staying as is and not disabling itself. And my site is performing well.

Real afraid to update again as this problem was a doozy. And there seems to be some correlation between menu cache, admin_menu.module and updating modules on my installation.

I will mark fixed in a couple days once I realize it's ok -- Thanks Sun!

calefilm’s picture

I'm still getting the error but others have said disabling the admin menu didn't resolve it... so we can presume that my case is an isolated case.

sonicthoughts’s picture

subscribing

calefilm’s picture

Try this:

http://drupal.org/node/147000#comment-3991278

I think the last patch I used was #81. You can try 95 or 98. And see if that helps.

sonicthoughts’s picture

I'm still having problems with this and it's very hard to debug. Patch does not seem to do it but since its so intermittent .... Version 3 does not work because it is not compatible with civicrm. may abandon for Navigate until i have time to debug. Bummer because I LOVE this module :(.

alexbk66-’s picture

subscribing

calefilm’s picture

yah, the patch never got rid of my errors--just limited them here and there. Seems to be a rather perplexing bug. My site isn't live yet but I'm very afraid of this thing once it does go live.

alexbk66-’s picture

I just uninstalled the admin_menu module, bye-bye problems! The module seems to be trouble for years, they recommend upgrading to 3.0-alpha version, but it did even more damage to my site. The author blames Drupal core menu system, great...
http://drupal.org/node/863092#comment-4300002

I simply created my own menu with links I use most often.

Also I'm going to look at Admin module, let you know how it goes.

HobbyBlob.com

calefilm’s picture

Thanks. I'll do the same.

sonicthoughts’s picture

why is this marked "won't fix???"

calefilm’s picture

Category: support » bug
Status: Closed (cannot reproduce) » Closed (won't fix)

MY PROGRESS WITH THIS THING -- To be Updated as I find fix

1/19/2010 - MY INITIAL POST:
Duplicate Entry / disabled theme
http://drupal.org/node/1033240

1/ 20/2011 - I FIND NEW THREAD
maintainer replaces his thread title to: "User warning: Duplicate entry ... " ... Themes
http://drupal.org/node/477550

1/19/2011 - I FIND NEW THREAD - PATCHES
Regression: Unify and rewrite module_rebuild_cache() and system_theme_data()
http://drupal.org/node/147000

6/24/2011 - bleen18 at http://drupal.org/node/477550 refers me to:
Calling theme function from hook_init() interferes with administration theme
http://drupal.org/node/219910 is bleen18 suggesting I follow his advice in #21 or do I apply what rjb says in post #22?

which he posts a related patch at: http://drupal.org/node/894710 at #19 (SHOULD I APPLY THIS PATCH?)

8/17/2011 - I upgrade Administration Menu module to 6.x-1.8... Problem Persists.

8/22/2011 - Uninstalled Admin_Menu module and replaced it with Simple Menu module. Problem persists. Except I don't get any VISIBLE errors (note: still errors in Reports/logs): http://drupal.org/node/477550#comment-4877548 Uninstalling Simple Menu module

Update: Problem persists even after uninstalling Simple Menu module

August 28, 2011 Update: In Log entries, I noticed a lot of PAGE NOT FOUND notices. Something like: "PAGE NOT FOUND: sites/all/themes/worksheet/images/none.png" -- This was a result of having deleted an image in my themes images folder or messing with the CSS file itself--in any case the file doesn't exist. This resulted in some of the Duplicate Errors. However, after 'cleaning' my theme files I was still getting the Duplicate Error every so often after Cron ran. As a result I thought since it's theme related I'll disable Page Theme and see what happens. Since disabling PAGE THEME module and replacing it with SECTIONS module, I am Duplicate Error free. (Note: have not reinstalled Admin Menu module yet) PROBLEM PERSISTS

9/1/2011 - http://drupal.org/node/307756#comment-3052424 After deleting all my themes and starting with just Garland and Acquia (core theme folders) I added one more, original beach theme. Run Update. Clear Cache. Run Cron. Problem persisted still... But then I just found this patch and applied it to drupal root folder. It seems to be working!

candelas’s picture

sorry that you decided no to fix this bug or collaborate to find a solution...
i have been using your module for years... and i have to desinstall because i dont find other solution.
i have tried all the patches that calefilm mentioned (thanks a lot for reporting) and i have to put in production the site.

i hope someone find a solution because i like admin menu :)

calefilm’s picture

Status: Closed (won't fix) » Active

I am overwhelmed by the amount of errors I receive using this module and don't know which patches/threads to look at anymore. Don't know where it starts but it ends with Admin Menu for me. I have no choice but to uninstall Admin Menu so I can move forward with theming my pages and surfing my site without getting hundreds of errors every few minutes. I will try Simple Menu or just create links to my admin pages.

sun’s picture

Category: bug » support
Status: Active » Closed (cannot reproduce)

The originally reported "bug" of this issue was caused by not running update.php after upgrading from 1.x to 3.x.

All following comments are blaming admin_menu (1.x) for errors it's not guilty for. That said, the original post was clearly using admin_menu 3.x, but then comments were back about 1.x, whereas it's entirely not clear whether the module was properly uninstalled and re-installed (as there is absolutely no "downgrade" facility anywhere in Drupal).

So, I'm sorry, but this issue can only be closed, because it contains many different reports about errors, which in itself are mixed about 1.x or 3.x, whereas the original issue was resolved by running update.php (like you always have to when replacing or updating modules in any way).

Lastly, I've no idea how you come to blame admin_menu, after stating and linking to a full range of issues for other projects in #16.

calefilm’s picture

I've run update countless times which never resolved the issue. This is a year old. Updated. Reinstalled. Uninstalled this module. Problem resolved by uninstalling.

The links were not meant for anyone but myself and whoever else is using Admin Menu getting same errors. Unfortunately there is no fix for this issue as of yet, but, for those of you looking into this you can find related patches at referred links. Luck

sun’s picture

That's fine. This issue got old and stale, because almost no one was able to reproduce it.

As I've seen you're using one of acquia's distributions, perhaps it's also caused by that. Or your web server / hosting provider. Or whatever. But well, I can't reproduce it either way.

calefilm’s picture

Oh. Very true. Well at least you've given me a couple suggestions on where to start. Using Acquia Drupal but on localhost (Mac OSX)... Thanks. Great module. Just wish I could use it.

I'm posting my progress in #16

candelas’s picture

please, dont figth :)
maybe its a conflict between this module and other.
lets be constructive!
i understand the desperation that calefilm has because i have been for two month trying to find a solution...
and i am very grateful to sun for this many years with his menu.
so, lets see if we find a way to reproduce, dont we?

sun: what information can i give to you to debug?
would you like i tell to you all the modules i have?
or what?

Status: Closed (won't fix) » Closed (cannot reproduce)