Title: Pages -> Posts Last modified: August 18, 2016 --- # Pages -> Posts * [basketball](https://wordpress.org/support/users/basketball/) * (@basketball) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/) * It seems that after upgrading to 2.1 all my pages have turned into posts. This is a little more complicated since I have quite a few (50+) pages that were relatively well organized until now. Just wondering if anyone knows how to revert back to the original settings? * I know this is partially my fault since I didn’t back up my database before upgrading( I’ve never had this many problems with wordpress before and I’ve been using it since pre 1.2 days) Viewing 14 replies - 1 through 14 (of 14 total) * [Austin Matzko](https://wordpress.org/support/users/filosofo/) * (@filosofo) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511869) * 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';` * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511875) * Nothing is “static” in 2.1 – see: [http://www.transycan.net/blogtest/2007/01/23/how-pages-are-different-in-wp-21/](http://www.transycan.net/blogtest/2007/01/23/how-pages-are-different-in-wp-21/) * [Bhooshan](https://wordpress.org/support/users/bhooshan/) * (@bhooshan) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511876) * 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? * [Austin Matzko](https://wordpress.org/support/users/filosofo/) * (@filosofo) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511877) * I am assuming that the post_status wasn’t upgraded either. * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511878) * 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'` * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511879) * 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. * [Austin Matzko](https://wordpress.org/support/users/filosofo/) * (@filosofo) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511880) * 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. * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511881) * 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. * [Austin Matzko](https://wordpress.org/support/users/filosofo/) * (@filosofo) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511882) * EDIT: Ah, I see what you mean. * [Bhooshan](https://wordpress.org/support/users/bhooshan/) * (@bhooshan) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511884) * **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 🙁 * Thread Starter [basketball](https://wordpress.org/support/users/basketball/) * (@basketball) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511885) * I gave up, spent the last hour hour reorganizing all my pages, and deleting the duplicate posts. * [Bhooshan](https://wordpress.org/support/users/bhooshan/) * (@bhooshan) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511896) * We need something similar to what Podz has done on Tamba2. That’s the best way to serve information to newbies and non-developers. * [moshu](https://wordpress.org/support/users/moshu/) * (@moshu) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511898) * [@bhooshan](https://wordpress.org/support/users/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. * [Bhooshan](https://wordpress.org/support/users/bhooshan/) * (@bhooshan) * [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511914) * 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 🙂 Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Pages -> Posts’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 14 replies * 4 participants * Last reply from: [Bhooshan](https://wordpress.org/support/users/bhooshan/) * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/pages-gt-posts/#post-511914) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics