Title: Missing posts after import Last modified: August 19, 2016 --- # Missing posts after import * [nekogal](https://wordpress.org/support/users/nekogal/) * (@nekogal) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/) * I have a WordPress.com account and have managed to setup my blog by importing the entries from my original Blogger blog. * I have since setup my own domain and hosting accounts, where I’ve installed the latest version of WordPress application. * I did an export at my WordPress.com blog, and then try to import into the new one. But now I have 5 missing posts. Comments/pages/categories/tags/etc are all intact. I’ve tried deleting all the posts and then re-import. I’ve even uninstalled the WordPress application and deleted the database, and then reinstall and recreate, then re-import. But none of these work. I’ve even tried to import from my original Blogger blog, but it still only imports 36/40 posts. * I’ve inspected the database, the records of the “missing” posts exists in the database, but just won’t appear on my blog. * What have I done wrong? Please help! Thanks! Viewing 15 replies - 1 through 15 (of 28 total) 1 [2](https://wordpress.org/support/topic/missing-posts-after-import/page/2/?output_format=md) [→](https://wordpress.org/support/topic/missing-posts-after-import/page/2/?output_format=md) * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860167) * Any chance you can do Manage->Posts and edit those posts? * Thread Starter [nekogal](https://wordpress.org/support/users/nekogal/) * (@nekogal) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860293) * The posts are missing and do not appear in Manage->Posts * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860302) * Can you see those posts in the WXR file created by the export from your wordpress. COM blog? You should be able to use some editor like NotePad to look at the file. * [ericrosete](https://wordpress.org/support/users/ecdoesit/) * (@ecdoesit) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860327) * I’m having the same problem. I took a peak into the WXR file and saw my missing posts in there. * I should also note that in the log after import, WordPress seems to think those posts already exist. * [treycampbell78](https://wordpress.org/support/users/treycampbell78/) * (@treycampbell78) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860329) * same problem here. missing 130 out of 220 posts! * [treycampbell78](https://wordpress.org/support/users/treycampbell78/) * (@treycampbell78) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860330) * my log after the import stops after post 124 and then it says: * “Fatal error: Cannot use object of type WP_Error as array in /home1/emptyqua/ public_html/wp-admin/import/wordpress.php on line 465” * I have re-exported from wordpress.com multiple times and re-imported the file multiple times but it always gets a fatal error at the same spot. Any suggestions? * [ericrosete](https://wordpress.org/support/users/ecdoesit/) * (@ecdoesit) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860345) * Anyone figure this out? * I got some error about clearing out my db tables when I logged into my host. I should have written it down. I have no idea what this means. * Thread Starter [nekogal](https://wordpress.org/support/users/nekogal/) * (@nekogal) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860347) * Yes, the missing posts are in the export files. When I tried importing, I got the error “Post already exists”. I even checked the MySQL database, and true enough, my posts are there. They just won’t show up on my blog or Dashboard or on Manage->Ports. * [saintless](https://wordpress.org/support/users/saintless/) * (@saintless) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860371) * I’m having this problem, as well. The entries are in the XML file I downloaded, and it looks like I’m missing 71 posts, and they’re everything after 5/22/08. * [saintless](https://wordpress.org/support/users/saintless/) * (@saintless) * [17 years, 6 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860372) * Update: I work with XML for a living, and figured that I can always wipe this out and start over, so I removed the posts that had already been imported, and left just the remaining ones, from the XML. They imported, though some are showing multiple times, which worries me. It looks like maybe the “duplicate” is just the comments, but I didn’t recall that being the case during the original import. * If it matters, I selected the option to import attachments. * Also, this time, the bottom of the page says “All Done”, which didn’t happen last time. I’m wondering if I closed the page before it was actually finished( even though the page appeared to be done, and wasn’t showing any imports happening). If I have to start over, I’m going to allow more time before I close the page. * I just checked, and all of my posts seem to have imported just fine. I would suggest anyone having this problem first try starting over, and waiting longer during the upload period. * Thread Starter [nekogal](https://wordpress.org/support/users/nekogal/) * (@nekogal) * [17 years, 5 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860402) * So.. is there a solution to this problem or not? * [stacef](https://wordpress.org/support/users/stacef/) * (@stacef) * [17 years, 5 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860414) * Add me to the list of those seeking a solution. * In going through the mysql database, it looks like the missing posts are in there but, in fact, they’re not – they’re “revisions” and “auto-saves”. Looking through the xml file shows the “post type” for each item, usually either “post” or “revision.” Also the “post status,” usually either “publish” or “inherit.” And there are multiples for each item but only one tagged “post” and “publish.” The WP files looking at the DB only see stuff tagged with “post” and “publish.” * For some reason, some items go into the db just fine with one “post/publish” and several “revisions” but others transfer with only the “revisions.” So the problem seems to be going from the xml file to the database but I can’t find any rhyme or reason for why some are allowed and some not. * Help! * [stacef](https://wordpress.org/support/users/stacef/) * (@stacef) * [17 years, 5 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860420) * UPDATE: The issue seems to be with identical “post_date”s on both a revision and a post. As the data is transferred into the DB, the revision goes first and when the post hits it, the DB sees it as already existing and so does not transfer the actual post. I’m not sure how I ended up with duplicate dates and times but, in my case, I think it has to do with moving some of these posts multiple times– out of and into different test blogs during development. * The solution I used was to go into the exporting DB prior to export and delete anything where post_type = “revision”. Then do the regular WP export / import. Should work fine. * [bornfamous](https://wordpress.org/support/users/bornfamous/) * (@bornfamous) * [17 years, 4 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860423) * I’m having the same problem. Stacef, your solution sounds good but I have no idea how or where to “go into the exporting DB,” much less delete anything from it. Is that the only way? * [stacef](https://wordpress.org/support/users/stacef/) * (@stacef) * [17 years, 4 months ago](https://wordpress.org/support/topic/missing-posts-after-import/#post-860427) * Check with your web host on how to access the database. When you first installed and set up WP you associated it with a db, which is where all of your data is stored. Whoever did this for you should be able to help you out. Viewing 15 replies - 1 through 15 (of 28 total) 1 [2](https://wordpress.org/support/topic/missing-posts-after-import/page/2/?output_format=md) [→](https://wordpress.org/support/topic/missing-posts-after-import/page/2/?output_format=md) The topic ‘Missing posts after import’ is closed to new replies. ## Tags * [Import](https://wordpress.org/support/topic-tag/import/) * [missing posts](https://wordpress.org/support/topic-tag/missing-posts/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 28 replies * 16 participants * Last reply from: [legend10](https://wordpress.org/support/users/legend10/) * Last activity: [16 years, 10 months ago](https://wordpress.org/support/topic/missing-posts-after-import/page/2/#post-860496) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics