Friends,
I've had problems with our site at EuropeanCuisines.com before on St. Patrick's Day -- our busiest day of the year -- but this one's a doozie.
I received a note from our (very nice) content provider, FutureQuest, that the (shared) server on which we have our Drupal 6 installation was taking a hammering. This happens because half of North America is after my husband's Mum's soda bread recipe.
Almost all my modules are set to throttle when usage is too high, so off I went to adjust the usage amounts. I went into my Admin panel and turned the throttling to "25 anonymous users" -- it had been running fine with that many on previous days -- and turned the overhead percentage down to 5%. Safe enough, I thought, and hit the "save" button.
Wham! Instant WSOD. All pages are now showing "500 Internal Server Error". I can't get into admin, or anything else. All white. Can't even roll back the database using Backup & Migrate.
How to I recover from this? I have DB access via phpMyAdmin (or will momentarily). Can anyone advise me what field I should kill or flag reset?
Help help, oh help.
Best! -- Diane
Comments
=-=
I'd disable the throttle module manually in the database by setting the status to 0 in the system table and test.
May be time to graduate to a VPS or dedicated box for your site. If much of your traffic is anonymous, may want to investigate the boost.module
Hey there VM! Thanks for the
Hey there VM! Thanks for the suggestion -- I'll give that a try. Thanks also for the note about boost -- will investigate that, as most of my users are anons. straight off of Google.
But here's a question. I'm looking down the table of module names and I'm not seeing "throttle". Does it have some other name? My table list goes straight from "tinymce_settings" to "trackback_node"...
=-=
I wouldn't think so. I've not enabled throttle on any sites to verify. May be best to do a search on the database for 'throttle' and see where it's popping up.
VM -- OK, so I've found
VM -- OK, so I've found "throttle" in the system table (I was looking in the wrong place. Stress. Sigh...) Can you coach me a little as to what the next step is -- how to set it to 0? I don't know database syntax that well. (blush) Thanks!
Once you have found that row
Once you have found that row of throttle module put check on that row (i hope you are using phpmyadmin) and at bottom click on edit (pencil image) and in the status field change it to 0 from 1 and hit go or save.
Once it is disabled, uninstall the module from the module page, this removed all your settings of throttle module.
Re-enable and configure it if you want to use it.
I would probably refer you to the good host after doing all this :
www.hotdrupal.com (shared/vps).
Acquia certified Developer, Back end and Front specialist
Need help? Please use my contact form
Sagar, thanks for the
Sagar, thanks for the help!
Unfortunately after clicking on the pencil icon, I'm not getting a "status" field. I've got: field, type, length/values, collation, attributes, null, default, extra, comments.
Any thoughts?
Best! D.
ETA: Resolved now. I reinstalled my last clean database, then turned off throttle and enabled aggressive caching. D.
=-=
doesn't sound like you clicked the proper edit button for the specific row required.