
Drupal uses modules, like plugins, they add extra features and applications to the content management system. If the module works, then congratulations! Otherwise, you will find your site totally inaccessible, not even the admin panel. However you know where the problem lies, but how do you disable or remove the module without accessing the website?
One of the ways to disable modules is through phpMyAdmin, a MySQL Database Administration Tool. I shall introduce 2 methods to disable modules via phpMyAdmin.
- Executing a MySQL query
- Browse the Table
UPDATE `system` SET `status` = '0' WHERE `name` = 'module_name' LIMIT 1;
Remember to change module_name to the name of the module you want to disable. This action will disable that module so that administrators can access to the administration panel again.
This is slightly easier if you feel uneasy executing a MySQL query. From the phpMyAdmin panel, scroll down to the entry that says "system" and click to browse system entry (see image below).

On the right side, you will notice several modules (including themes). Go to the module that you would like to disable and click on EDIT (with a pencil icon). Simply change the STATUS to "0".
Either method should deactivate the module you wanted to disable instantly. Hope this help those in need.



Thank you for this
Thank you for this information!! I was indeed having trouble with a new Drupal module and I couldn't get back in to my site to disable it. This helped a lot -- thank you very much!! --Steph
You're welcome, Steph
You're definitely most welcome, Steph. I am glad that this article is of great help to you.
Cheers!!
Hi, My name is Blair
Hi,
My name is Blair Billwards. I love your blog and could but leave a comment here
You got great information that are educative and infomative. I will like to come
around often to read more information on your blog and leave my comment if it demands
Hope you don't mind..lol
Thanks
Blair
Thank you
Hi Blair,
Thank you for your comments. It will be great to have you around.
Cheers,
Keith
Personally, I never use more
Personally, I never use more than a single link in the comment I post because doing so can trigger spam catchers if the user has that plugin activated, whereas a single link will not.
Has anybody else discovered
Has anybody else discovered that Drupal works better in IE than Mozilla?
Better in IE?
Hi GreatCreditScores,
What makes you think that Drupal works better in IE than in Mozilla. I doubt it has anything with the browser. On the contrary, it is the theme that the owner is using that affects the performance on the browser. PHP is mainly affected by the server-side performance, which eventually re-code them into HTML format for client-side.
Thanks
Awesome post. I'll be using the information if my modules break down. Thanks for sharing.
Thanks for the information on
Thanks for the information on how to disable modules through phpMyAdmin. I knew it could be done but was at a loss as to how to do it.
hate wordpress
wow, great post...i was looking for this everywhere...found you on the 20th pahge of google..lol...thanks a million tho!!
ps: i hate wordpress ;-)
With ASP
Hi,
I am not sure how well this will work with ASP. As far as I know ASP works better with Micrsoft SQL instead.
Thanks,
Keith
This saved me a lot of
This saved me a lot of headache. Thanks for the posting
Be careful
This way will not trigger hook_module_disable. In most cases it's OK but double check then that site is stable.
So many spam comments
It really bothers me to see so many generic comments which are clearly from computer which haven't even read the article, IE better than firefox, ASP, i mean come on.
keith, you should implement some sort of CAPTCA system. Maybe you should try the mollom module.
Mollom Doesn't Help
Hi Thomas,
Apparently, this is one of my greatest issue maintaining a Drupal site. I don't have such a problem on WordPress because Akismet works really well.
On Drupal, Mollom doesn't help much to differentiate those spam ones and those positive comments.
If you have some suggestions, please kindly share with me.
Post new comment