Disable drupal modules using MySQL query

I am doing a project in drupal.  After enabling a module, my site is not loading and i can’t able to disable that module.  so i start searching Google and found this easy solution. May be it will be helpful for others who have similar problems.

Connect to your mysql shell or phpmyadmin and then use following query to disable a module:

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

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.

To list all drupal modules:

SELECT * FROM system WHERE type='module';

Advertisements

3 Comments

  1. January 12, 2011 at 11:26 pm

    nice post :),i really saw this today

  2. January 19, 2011 at 12:22 pm

    Hi vinod,
    I also had this problem and i will simply delete the module and re install the module again.It Works but your description is nice.Let me checked it out.

  3. bride said,

    January 24, 2011 at 3:08 pm

    Well I would like to thank you for the valuable information. I was searching alot about such posts and I am very into it. I’ll keep on checking this site from now and on. Thank you. And always keep updates please.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: