Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error
Currently i am creating a new blog in WordPress, and i was working with different themes and i have activate one WordPress theme and i got “Fatal error: Cannot redeclare the_content_limit() Error” and suddenly no other pages are seems to be working all pages are displaying the same error. So i must have to solve this error and i have come-up with a brilliant solution by changing the theme settings from database. I am trying to Change WordPress Theme from Back End Using phpMyAdmin Database & MySQL now. I must have to find “Fatal error: Cannot redeclare the_content_limit() Error Solution” for WordPress Users and for me fist of-course.
Sometimes sites get broken after an upgrade due to a bad theme or plugins, like i have encountered with the bad themes. Renaming the plugins directory will usually fix the problem and renaming the theme will sometimes help, however, sometimes the theme is just too problematic and it needs to be switched back to the default theme form back-end.
How to Change WordPress Theme from Database Using phpMyAdmin
I am using Parallel Plesk Panel so i am giving detail instruction for the Plesk panel however you can do the same thing with c-Panel which i have described after the plesk panel discussion.
Step 1. Log in to Parallels Plesk Panel.
Step 2. Find Application & Services > Database icon and click on it.
Step 3. Click on Database Management Web Interface icon.
Step 4. Now you have a phpMyAdmin database screen open. Click on Databases.
Step 4. Now Choose your database then find wp_options from left sidebar.
- Click on SQL Tab.
- Run below given queries just for the testing purpose and you will be able to judge that current_theme and style-sheet variable values.
- Run this 3 Update Queries one by one.
UPDATE wp_options SET option_value = ‘default’ WHERE option_name = ‘template’
UPDATE wp_options SET option_value = ‘default’ WHERE option_name = ‘stylesheet’
UPDATE wp_options SET option_value = ‘default’ WHERE option_name = ‘current_theme’
After updating database variable values must be :
current_theme = default
template = default
stylesheet = default
Follow Same Steps to Change WordPress theme using phpMyAdmin in Cpanel.
Click on phpMyAdmin from Cpanel, and open in new window.
Then just repeat the steps i have given above and open your wordperss blog’s login page.
example: http://Your-WP-Domain.com/wp-login.php
I hope that you will be able to recover your blog theme and also you have a solution for Fatal error: Cannot redeclare the_content_limit() Error Solution for WordPress Users.

















[...] you think I’m not being fare to you and you want more details, go to this blog (AT YOUR OWN RISK), it’s full of screen captures and a longer explanation. Tags: MySQL, phpMyAdmin, [...]
Hey man,
Saved my day. Also needed to manually disable plugins and set theme to other working theme.
Thanks,
Peter
You can rename plugin folder from FTP, so that it will become disabled automatically.
Hey man, thanks a lot for this
Tried to install a theme with a PHP error and broke my site, this saved me