How to change wordpress theme directly from database

How to change wordpress theme directly from database?

I had some error in my new wp theme (hybrid-news). When I enabled the new theme, I got this error – Fatal error: Call to undefined function hybrid_get_prefix() in /media/Webroot/projects/wp/wp-content/themes/hybrid-news/functions.php on line 46 . I was unable to access my wordpress blog both from frontend and backend (admin panel).

In this case, either I need to change/fix my theme’s code. So I decided to change the theme.

To do that, I open the phpMyAdmin, and selected the wp database. And then I searched the word “hybrid-news” in all the tables. When I do this search, I was able to see the word “hybrid-news” in the “wp_options” table. The option_id = 46, option_name = “stylesheet” and option_value = “hybrid-news”. So I updated the “option_value” to “default”

UPDATE wp_options SET option_value = 'default' WHERE option_name = 'stylesheet';

The result – 1 row(s) affected. I was able to get my site (front-end and admin panel) back with default theme.

I hope you found these tips helpful. Be sure to drop a comment if you have any more ideas.