HELP! we are running a fairly complex Drupal 6.x site, we were on version 6.10 i think and no we hadn't done the upgrade to 6.12 yet... maybe that's the problem?
our client was just doing some routine backend work and suddenly something went sideways:
- the home page is now the default home page "welcome to your new Drupal website" etc.
- the admin menus are almost completely gone... i can still log in as admin, but instead of seeing everything i should, i just see two menu items ("hide descriptions" and "home") instead of fifty or a hundred. admin user is still bound to the correct role in the users_roles table.
- any attempt to access one of the admin pages by keying in the URL just redirects back to that same default home page
neither myself nor the other programmer have made any changes to this site in days, and the client doesn't go messing around with menu items he doesn't understand, he was just doing some routine work in a safe area when this happened.
does anybody recognize these symptoms? if so, i'm all ears!
thanks
Peter 'Fish' Fisera
GoatVirus Technologies
Comments
Well, problem solved... i
Well, problem solved... i don't think we were hacked, i think the webhosting company screwed up somehow, and one of our database tables was truncated without warning. the table menu_router suddenly only contained about 30 rows instead of a few hundred, and as a result, we couldn't access most functions.
if this ever happens to you, then you will need to restore menu_router rows from your most recent backup. and then you may need to rebuild your menu tables anyhow, because the most recent backup may not be quite correct (depends how often you change your menu items). a good way to do this is the "rebuild" module (from http://www.pre-emptive.net/doco/rebuild-module-drupal-6 , highly recommended! clears caches too!)
if you don't have a backup, you might be in bigger trouble... because even if you have the rebuild module installed, you won't be able to run it if the menu item for it is missing! Catch-22! :-)
does anyone know of reasons why the menu_router table can get corrupted? and alternate methods of fixing it? if so, please elaborate!
cheers,
Fish
Same Thing Happned To Me -
Who's your host? I'm with HostGator.
Haven't tried your rebuild module yet, off to do so now. Thanks - I've been in a panic ever since this happened on my site.
answers
publetariat - i am hosting with canadianwebhosting.com We have been there for two months and it's been smooth as silk... until now.
what version of Drupal are you on? we're on version 6.10 I wonder if this is a Drupal issue that could somehow leave menu_router that corrupted, or if it's a webhosting / database problem?
cheers
Fish
I'm on 6.10 Too
I'm on 6.10 too...have been delaying the 6.12 upgrade since reading about lots of other sites that have gone buggy since doing the upgrade. Since only the site admin has rights to create new webpages or scripts for the site, anonymous users can't create anything but comments on article (Story) pages, and authenticated users can only enter profile content and create comments in the Forum module, I'm not concerned about the scripting and HTTP header vulnerabilities.
But the fact that we both had the exact same problem on two different hosts, and in both cases our menu_router tables were truncated to exactly 30 rows, leads me to think this is a Drupal problem, not a host problem.
30 rows, and same version of Drupal?
yeah, that sounds like too much similarity to be coincidence. maybe it is. but if someone who knows the menu system code could jump in here and comment, that would be great! ;-)
cheers
Fish
Can't Access Extracted Module
I downloaded the rebuild module and extracted it, but can't access through my site interface. Any suggestions?
Found a fix...
I lucked out, since my site is a subdomain of a primary Drupal site, and the primary site's menu_router table was still fine. I backed up the bad one from the subdomain, then copied the good one into the subdomain with the correct name and presto! My Admin menu is back.
happened to me yesterday morning.
Hosted with bizland.com and got the same problem. Wound up rebuilding the database from a backup. maybe these host are all 1 in the same.
another solution: submit modules form
Thanks to you folks for the suggestions... I found another solution to this problem that may be simpler than the others: If you can access admin/build/modules, simply submit the form and that will cause the menu table to be rebuilt.
Same thing but keeps coming back
Suddenly my Drupal installation hosted by Godaddy began to experience these same symptoms. The website began to have white screens show up and then some 500 internal apache errors. Then it started to work again but differently.It had been working fine for a year. It is different in a few respects. All the menus show up but all lead to a front page of a teaser list of blog entries....when I had it set to display an entire page for the front page. No items showed on the /admin page. It was definitely not a clean urls problem. I found this forum entry and looked at my menu_router table and found that the entries were missing. Only like 10 left. So I reinserted the menu_router table entries from a backup. This immediately brought the website back. I immediately went to /admin/build/modules to click save so the menu table would rebuild. The web site worked as I scanned through maybe 10 pages. Then an hour later when I came back to it all I get is an error saying '500 Internal Server Error'.
What is going on here? I believe it 6.10 but could be 6.11 I can't remember exactly and I can't find out right now. It wasn't really a complex site maybe 60 pages with a couple of vocabularies. Obviously some other problem is cropping back up. As of now the menu_router table has all the entries it should.
I'd love to know what to do from here.
Mark Hanna
My Blog
mark@skvare.com
Turns out!
I had a module that was causing a problem. It was either Menu Block or one of the Feed modules but I think it was Menu Block. I had enabled it, tried it out and decided not to use it but still had it enabled. I can't be sure but I think it began to corrupt the menu router table. I disabled the modules by directly editing the system table and changing the status field to 0 for the suspect modules.
I then had to go to /admin/build/modules and save so the menu table was rebuilt again.
Mark Hanna
My Blog
mark@skvare.com
well, here i am again... this
well, here i am again... this just happened to ANOTHER one of our sites, hosted on Dreamhost this time. Drupal 6.13 and not using that "menu block" module that was mentioned by @markusa We restored the menu_router table from backup (and then ran the rebuild function, to be safe) and it was fine.
i wish i knew what caused this, it created quite a panic!
Peter Fisera
GoatVirus Technologies / Earth Angel Consulting