Skip to Content

Disable Drupal Module using phpMyAdmin

Posted in

Using Drupal for your site can be very useful, as several sites I know of are powered by Drupal system. For one reason is that it is highly configurable, which is certainly very useful for people like me.

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.

(Continue reading to find out)

  1. Executing a MySQL query
  2. 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.

  3. Browse the Table
  4. 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.

Trackback URL for this post:

http://www.neohide.com/trackback/105

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

very nice blog, one of the

very nice blog, one of the best i have read so far, found the ifo to be useful to a newbe like my self! thanks
barry

Awesome Post!I definitely

Awesome Post!I definitely learned something new today! Thanks Again!

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.

When reading blog posts my

When reading blog posts my main from concern is useful information and content.
Keep up the good work,

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.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options