Missing posts after import

Any chance you can do Manage->Posts and edit those posts?

The posts are missing and do not appear in Manage->Posts

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.

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.

same problem here. missing 130 out of 220 posts!

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?

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.

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.

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.

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.

So.. is there a solution to this problem or not?

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!

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.

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?

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.