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.

SELECT *

FROM `wp_options`

WHERE option_value LIKE "%current%" or like "%theme%"

SELECT *

FROM `wp_options`

WHERE option_name LIKE "%style%"

- 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.