changing a WordPress page template in phpMyAdmin
Update 7/10/12: A slightly easier method than the one shown below would be to edit each of the template php files, putting the php at the top in one line instead of spaced out. This should fix the issue with most themes.
Ex. “<?php /* Template Name: Full Width */ ?>” instead of
/* Template Name: Full Width */
I recently updated my WordPress from 3.3 to 3.4 but my theme was not updated to support 3.4. The only issue I ran into is it did not give me the option to change the template of my page anymore. This created issues because my theme uses templates to define its layout for each page. So I discovered a temporary workaround until my theme gets updated.
1.) Before you start you need to know your page id number. It will show up in your URL if you are not using custom permalinks.
2.) login into phpMyAdmin
3.) locate your WordPress database (you can select it in the sidebar or from the drop-down depending on your version)
4.) select the wp_postmeta table
5.) sort by post_id and locate your page id number.
6.) Under the meta_key column find the record that says wp_page_template
7.) change the meta_value to the template of your choice. ( I changed mine from default to template_home.php which is the homepage template for my theme.
Hope this helps!