Pages -> Posts

WordPress 2.1 differentiates a post from a page in the post_type field in the wp_posts table; in previous versions it was the post_status field.

So you probably need to try something like the following MySQL query (at your own risk, and after backing up, of course) :

UPDATE wp_posts SET post_type = 'page' WHERE post_status = 'static';

Nothing is “static” in 2.1 – see:
https://www.transycan.net/blogtest/2007/01/23/how-pages-are-different-in-wp-21/

Hi Filosofo, my query was also related to the same. Could you please be more specific and tell us where exactly do we have to edit the MySQL and insert the code? Your help is highly appreciated.

Edit:
Sorry, I saw moshu’s post a while ago after I submitted. Moshu, I read your post and wondered where do we edit the query. Could you please help me out?

I am assuming that the post_status wasn’t upgraded either.

As I wrote in my blog: if it is not draft or attachement – then post_status for everything is “published” for posts and Pages as well!
So, after upgrade to 2.1 you will not find anything with post_status = 'static'

I don’t think there is anything to do in the database.
(sorry, filosofo, you may want to review that advice above)

If you have some queries in your theme calling Pages – check those, and modifiy the query based on what I described in the blog.

If post_type wasn’t upgraded, then there’s a good chance that post_status wasn’t either.

Of course, if there are no ‘static’ posts (because the upgrade was successful with one field of the posts table, but not the other), then there’s no harm in running my query, as it will affect no rows. See?

Edit: This has happened to me on at least one upgrade–the wp_posts fields didn’t upgrade, so I had to do it manually.

I am afraid you didn’t read it… The OP’s complaint shows exactly that the upgrade was successful. That’s why s/he cannot find the Pages.

EDIT: Ah, I see what you mean.

**I am still confused.

Can somebody translate it into a step-by-step process? Sorry for the same, but I am not a skilled developer like the rest on the forum ??

I gave up, spent the last hour hour reorganizing all my pages, and deleting the duplicate posts.

We need something similar to what Podz has done on Tamba2. That’s the best way to serve information to newbies and non-developers.

@bhooshan,

I don’t really understand what are you trying to do with your Pages (“reorganizing”) – but for sure, your theme (blix) is NOT compatible with 2.1.
There was an updated release yesterday by a user – search the forum.

ok..thanks Moshu. I will update my theme and get back. I had a hunch that that’s the issue with the pages thing not going my way ??