Geek Answers Handbook

Changing the admin theme in Drupal 6 Directly in the database

I want to restore the default admin theme in Drupal 6 through the database. Does anyone know where this is stored?

Btw, there is an excellent answer describing how to change the public theme of your site in the database here ... I just could not get it to update the admin theme.

+2
source share
4 answers

The list of topics that you can find in the table {system}, filter by type = theme, there you can set the status = 1
You can find the default theme in the {variable} table, filter by name = theme_default, change it to the theme name, since it is written in the system table (for example, a garland, not a garland).
Following this clear cache table.

+2
source

Follow these steps with db:

  • {system} table, filter by type = theme set status = 1
  • {variable}, filter name = theme_default change the name of the theme to you as written in the system table
  • {variable}, filter name = admin_theme change this topic name for you, as written in the system table. Do not miss this step.
  • trim cache
0
source

Enter your phpMyAdmin, go to the SQL tab and run:

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

Please note that you may need to add a prefix to your tables

Thanks https://drupal.org/node/200774

0
source

If you are editing variables in PHPMyAdmin, remember that you are editing a serialized value. This means that the edited value looks something like this: s: 7: "garland".

If you just changed the garland to marvin, that would change the number of letters in the serialized value from seven to six.

You will need to change ss: 7 : "garland" 'to' s: 6 : "marvin" '

That is, you will need to count the number of letters in the new topic and update the number following s: respectively.

0
source

More articles:


All Articles