There was no version WP 1.9.
Pages are kept in the wp_posts
table and the post_status
field should be ‘publish’ and the post_type
should be ‘page’.
My apologies Michael – the irregularities of speed typing have bested me once more.
1. I am unsure how to verify the wp-admin interface with these recommendations as the pages section is completely blank and there is no place to apply these corrections. (these options appear only while trying to create a new page — whereas I am trying to recover ones that wp-admin appears to have lost).
2. The invocation from the theme’s sidebar as follows:
<?php wp_list_pages(‘title_li=<h2>’ . __(‘Pages’) . ‘</h2>’ ); ?>
Should this be different? (as it no longer works).
You’d need to use something like phpMyAdmin to check the database.
Michael-
Thanks for the guidance. I took it from there and solved the issue.
For the benefit of any other reader:
I installed phpmyadmin as suggested
Ran the following test SQL query:
———————————
SELECT * FROM wp_posts
WHERE post_status
= ‘publish’
and noted a good set of results.
Then, I applied the rules suggested above.
——————————————
SELECT * FROM wp_posts
WHERE post_status
= ‘publish’ AND post_type
= ‘page’
I got no results.
Next I queried the post_title
with the known title of one of the pages I had made.
——————————————————-
SELECT * FROM wp_posts
WHERE post_title
= ‘contact’
Here I noted the post_type was set to ‘post’ and not ‘page’.
Using the edit feature in the row result of phpmyadmin, I changed this to ‘page’, and voila, we’re back in business.
Thanks.
Thanks so much! This resolved my issue easily since I only had a few Pages.
I have been having this problem, and can see in phpMyAdmin that the post_type is correctly set to ‘page’ – could there be any other reasons for this issue?