Managing Hierarchical Data in MySQL

By Mike Hillyer (Technical Writer for MySQL AB and lives in Alberta, Canada.)


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';

2010 in review

The stats helper monkeys at mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads This blog is on fire!.

Crunchy numbers

Featured image

A helper monkey made this abstract painting, inspired by your stats.

The average container ship can carry about 4,500 containers. This blog was viewed about 15,000 times in 2010. If each view were a shipping container, your blog would have filled about 3 fully loaded ships.


In 2010, there were 16 new posts, growing the total archive of this blog to 85 posts. There were 26 pictures uploaded, taking up a total of 5mb. That’s about 2 pictures per month.

The busiest day of the year was September 15th with 87 views. The most popular post that day was Auto-Grow Textarea – doing it the easy way in Javascript.

Where did they come from?

The top referring sites in 2010 were,,,, and

Some visitors came searching, mostly for autogrow textarea, textarea autogrow, difference between table and div, stylish button css, and php form validation with preg_match.

Attractions in 2010

These are the posts and pages that got the most views in 2010.


Auto-Grow Textarea – doing it the easy way in Javascript May 2009


input[type=submit] css not working in IE6 December 2009


Difference between table and div tags March 2010


PHP: Sending Email (Text/HTML/Attachments) July 2008


Dynamically Change Width and Height in embed code August 2009