Community Documentation

Disabling modules manually in the database

Last updated September 6, 2011. Created by LeeHunter on July 8, 2007.
Edited by a.ross, add1sun, VM, sepeck. Log in to edit this page.

If you need to manually disable a module you can do so in the database. Before you start, do a mysqldump (or export) of your Drupal db to a local file in case things go wrong and you need to roll back.

phpMyAdmin

To disable a module via phpMyAdmin you must login to phpMyAdmin. Then you must locate the database where Drupal is installed. Once you have done so look for the "system" table. Click and open it. Click to browse the table. Find the record for the module that is causing the problems and select the edit function. Set the status to "0" and save.

MySQL command line

To disable a module using the MySQL command line, run the following SELECT to look at the state of your data before the change. This will help you to find the full name of the module too.

SELECT name,status FROM system WHERE type='module';

Then to disable your module, set the status to 0 for the module name that you want to disable.

UPDATE system SET status='0' WHERE name='module_name';

Check your handiwork using the SELECT statement again.

Comments

What are the steps to do this

What are the steps to do this in a postgresql environment?

disalbe with blank .module

I disabled my broken module in 6.x with replace the .module file to blank file. After this, I disabled it on /admin/build/modules page.

Drupal 7 system info cached in cache_bootstrap table?

In Drupal 7, it was not sufficient for me to merely set status=0 in the system table. I also had to do the following:

DELETE FROM cache_bootstrap WHERE cid='system_list'

Without doing this, Drupal would still think the module was enabled.

About this page

Drupal version
Drupal 4.5.x or older, Drupal 4.6.x, Drupal 4.7.x, Drupal 5.x, Drupal 6.x, Drupal 7.x
Audience
Site administrators
Drupal’s online documentation is © 2000-2012 by the individual contributors and can be used in accordance with the Creative Commons License, Attribution-ShareAlike 2.0. PHP code is distributed under the GNU General Public License.