Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

Posted In Uncategorized - By Piyush Dungrani On Wednesday, August 18th, 2010 With 4 Comments

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.

Wordpress Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

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.

Log+in+To+Parallels+Plesk+Panel Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

Step 2. Find Application & Services > Database icon and click on it.

Database+in+Parallel+Plesk+Panel Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

Step 3. Click on Database Management Web Interface icon.

Database+management+web+interface Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

Step 4. Now you have a phpMyAdmin database screen open. Click on Databases.

Open+phpMyAdmin+2.11.6 Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

Step 4. Now Choose your database then find wp_options from left sidebar.

Run+Query+in+phpMyAdmin Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

- 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%”

theme+default Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

SELECT *
FROM `wp_options`
WHERE option_name LIKE “%style%”

style Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

- 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

style+to+default Change WordPress Theme from Database Using phpMyAdmin and Fix Fatal error

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.

Incoming search terms:

wordpress change theme in database, change wordpress theme in database, change wordpress theme from database, wordpress theme database, wordpress change theme database, wordpress database theme, change wordpress theme via database, wordpress set theme in database, change wordpress theme database, how to change wordpress theme from database, wordpress change theme via database, change theme wordpress database, wordpress theme setting in database, theme database wordpress, reset wordpress theme database

About - A techie by profession (software engineer) and a part time blogger by choice with immense knowledge of SEO, also writes articles on Google, Microsoft, Apple, iPhone, Internet, Blogger, Social Media and windows. Catch him on Twitter, Join Facebook Fan Page. Subscribe to GeekBlogger feed via RSS or EMAIL to receive instant updates.

Displaying 4 Comments
Have Your Say

  1. [...] 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, [...]

  2. Peter says:

    Hey man,
    Saved my day. Also needed to manually disable plugins and set theme to other working theme.
    Thanks,
    Peter

  3. CB says:

    Hey man, thanks a lot for this :) Tried to install a theme with a PHP error and broke my site, this saved me :)

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>