How To Fix A Broken Theme Using Phpmyadmin

Description: If you ever load up a new theme and it doesn't load correctly or it breaks your site, learn how to get into phpmyadmin and manually change it

Version: 1.0

Added on: 18 February 2008

Author: Ped

Difficulty Level: Easy

Views: 1426

Rating: 9.0 (1 Vote)

Detailed Profile • View Comments (1) •

Firstly, this tutorial will not teach you how to access phpmyadmin, you would gain access to phpmyadmin via your host control panel usually. Please check with your host if you cannot find or work out how to access phpmyadmin.

MAKE A BACKUP OF YOUR DATABASE

Many a time i have had to do this, as i load many themes for testing or re-design, if when you load a new theme and you get a blank screen or you cannot access the admin area to change it back, then this is a step by step way of how to do it via phpmyadmin.

Once into phpmyadmin you will see a screen similar to the one below:

nothing to be scared of !! all you need to do is scroll the navigation bar on the left down looking for the table nuke_config (some sites may be different than nuke_ as this is your "prefix" and can be set when installing phpnuke for the first time.



Once you have found nuke_config just click it to access it.

When the pages loads you can tell that you are in nuke_config by looking at the address at the top of the screen, it should say what table you are in... If you are in the correct place, then you will notice a tabbed browser bar at the top of the tables, just click on the browse to view the table in detail:


Once you hit the browse tab, you will be presented with your sites configuration details, this is where you can manually edit your sites details... hit the pencil icon located to the left of the information


Now you will be able to edit your sites configuration, you will notice the default theme



My default theme was set to Aviator in my image, this is where you will see your current working theme, all you need to do is delete it and input your old or new working theme then scroll to the bottom and hit go !!

Thats it, go view your site and all should be all good and working again !