Reset the default drupal theme with SQL

Reading Time: < 1 minuteSometimes a drupal theme can be broken and it can be needed to reset the default theme so the site can be accessed again in order to fix the problem.

As a rule of thumb I always try to use the theme "Cube" for the administrive part of drupal. that makes things a lot easier and if you breeak the theme you can at least still use the admin part.

Here is anyhow how to reset the theme using SQL:

Simply execute the three following commands:

UPDATE system SET status=1 WHERE name = 'garland';
Reading Time: < 1 minute

Sometimes a drupal theme can be broken and it can be needed to reset the default theme so the site can be accessed again in order to fix the problem.

As a rule of thumb I always try to use the theme "Cube" for the administrive part of drupal. that makes things a lot easier and if you breeak the theme you can at least still use the admin part.

Here is anyhow how to reset the theme using SQL:

Simply execute the three following commands:

UPDATE system SET status=1 WHERE name = 'garland';
UPDATE variable SET value='s:7:"garland"' WHERE name = 'theme_default';
TRUNCATE cache;


Related posts:

  1. 5 Great security tools for Ubuntu
  2. Fix a ubuntu upgrade problem with Grub2
  3. Work with man pages
  4. How to find which SQL is executed by a process

By Marc Olivier Meunier

Marc has spent the past few years putting oil on the fire of growth companies. He leads by example and puts a lot of emphasis on inclusion, constantly working to create a safe environment. A warm leader with a passion for memorable experiences and innovation.
Marc is available for contracting as a fractional Head of Customer Experience.
Find Marc on Linkedin

Leave a Reply

Your email address will not be published. Required fields are marked *