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 few 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. At Eficode he is now leading an engineering team and running operations. 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 Marc on Linkedin

Leave a Reply

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