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.