Reset the default drupal theme with SQL

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

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;


By Marc Olivier Meunier

Marc has spent the past 7 years putting oil on the fire of a hyper growth ad tech company. At Smartly.io he was in charge of scaling the support and its culture. He leads by example and puts a lot of emphasis on diversity and inclusion, constantly working to create a safe environment. A warm leader with a passion for memorable experiences and innovation.
Find me on Linkedin

Leave a Reply

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