WordPress › Support » Missing posts after import

nekogal
Member
Posted 1 year ago #

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!
MichaelH
moderator
Posted 1 year ago #

Any chance you can do Manage->Posts and edit those posts?
nekogal
Member
Posted 1 year ago #

The posts are missing and do not appear in Manage->Posts
MichaelH
moderator
Posted 1 year ago #

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.
ecdoesit
Member
Posted 1 year ago #

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
Member
Posted 1 year ago #

same problem here. missing 130 out of 220 posts!
treycampbell78
Member
Posted 1 year ago #

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?
ecdoesit
Member
Posted 1 year ago #

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.
nekogal
Member
Posted 1 year ago #

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
Member
Posted 1 year ago #

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
Member
Posted 1 year ago #

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.
nekogal
Member
Posted 1 year ago #

So.. is there a solution to this problem or not?
stacef
Member
Posted 1 year ago #

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
Member
Posted 1 year ago #

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
Member
Posted 1 year ago #

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
Member
Posted 1 year ago #

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.
benwood
Member
Posted 12 months ago #

I just joined because my daughter's wordpress-hosted blog croaked, and 1&1 could not, or would not recover it.

So... now that I know... I've been looking into how the import/export works, and I, too, was having trouble with the import. I'd get six of a hundred posts with an error message when it aborted.

I discovered what was tripping up my import, though, and it may help others. I'd used the image upload facility and named one image with a string that broke the import. This string is the one that appears as a tooltip (which worked as typed).

The error message:

WordPress database error: [Lost connection to MySQL server during query]
SELECT ID FROM blog_2_posts WHERE post_title = 'Sandy on the ‘barisax’' AND post_date = '2008-09-07 20:24:30'

The actual image title was
Sandy on the `barisax'

I changed this to
Sandy on the barisax

re-exported my block, re-imported into the new temporary blog and voila, it worked.

Those quotes in my label were the problem.

I still don't have a solution to backing up my 1&1 blog, however, as the image files do not back up. They are on versions 2.2.1. 1&1 does not give me access to the actual files in the blog and so I can literally only back up the text and not the images. Better than nothing, kind of.
privatepigg
Member
Posted 11 months ago #

Ok, so I created my ml blog and made a whole bunch of "pages" (not posts) as I planned on them all being static links and not data/time posts. Well, I changed my mind and started cut/paste all my pages to posts.
Now, in my wordpress control panel (for my blog) I have one post for each post, the page having been deleted, but in the host control panel, in my phpAdmin, each post is duplicated. For example, all of my posts at even numbers, so my first post is http://myblog/arachive/2250, and my second post is http://myblog/archive/2252. In myPHPadmin, howeever, there is a duplicate of 2250 at 2251, and it is labeled "inherit." And there is a duplicate of 2252 at 2253, and it is labeld as "inherit" as well. It seems to be causing mySQL slow querie problems. Can I go through and delete all thoe "inherit" posts? Is there any reason to keep them?
tranquera
Member
Posted 11 months ago #

Upgrade went fine but some posts are missing. Possibly because the "autosave" function. The post exist and can be edited but it don't appear. If someone could drop a tip to people who aren't experts with DB would be nice. Thanks!
internalwealth
Member
Posted 10 months ago #

Thanks stacef!

I was about to go squirrelly and then came across your advice.

I was missing 280 or so posts after importing the database into a new blog name on a new server. Also going from Wordpress version 2.0 to 2.7

Going through the wp_posts table, I could see that all the posts were there.... just not actually showing up in the blog itself.

The issue turned out to be no data showing in post_type within the table. I added the word 'post' to each entry - and Voila!

Anyone who doesn't know databases, get in touch with your host and ask them to check your Wordpress database, wp_posts table, and then check each entry to see what info is in post_type. If it's anything other than the word 'post', then have them change it.

Worked for me.
johnwar
Member
Posted 10 months ago #

Try to import from you mySql database. It should be work.
See this treat: http://codex.wordpress.org/Backing_Up_Your_Database
nekogal
Member
Posted 9 months ago #

Thanks stacef! Those are great tips indeed! :)
erikvisser
Member
Posted 9 months ago #

I tackled this problem by going to php my admin and trowing all post, metadata, connections away. And then importing them again trough wordpress. All post that should have been there are.
Hope this helps someone with similar problems.
shirls
Member
Posted 9 months ago #

Hello all,

I have the similar problems. I have a blog at wordpress.com and want to transfer it to a new domain hosted by other hosting company.

Strangly, for the first import, only 4 of my published posts (4 out of 200+) and all draft posts are transfered, and only a few comments are imported. I uninstalled wordpress,reinstalled, and tried again, similar problems. This time, only drafted posts are imported,none of published or comments are imported.

I looked at the XML files, all posts are there. However, when I looked at the mMySQL DB, only the drafted posts are there.

I am so sorry, I don't have much knowledge of website management technical terms. I tried very hard to understand the above suggestions, but still failed to know what I should do next.

Dear Johnwar, I am keen to try to import from mySQL DB. However, the link you shared is for backup. Is it possible to import the XML directly to MySQL database? I tried but it did not work.

Dear Erikvisser, I am a little confused with PhpAdmin & MySQL. I assume they are the same thing. Nonetheless, for what you suggested, do I delete wp_postmata, wp_posts, wp_comments, & wp_links in MySQL. And try to re-import through wordpress?

Sorry for long post. I have tried 2 days to do this, and it is driving me crazy !

Thanks in advance ! :)
oBifferson
Member
Posted 8 months ago #

Hiya,
I'm having a very similar problem as well, only I can only get 1 post to import (supposedly), and it doesn't show up in the blog (says no posts).

I'll send an email to my host and see if they can take a look at the db table for me, as suggested.
oBifferson
Member
Posted 8 months ago #

Hey all, sorry to post twice, but let me rephrase:

I'm having a similar, but different problem. I'm trying to import 40 posts and 23 comments from my Blogger blog. WordPress sees this blog, but after I click "Import" the progress bars click up to 1/43 posts and 1/43 comments.

The only way I know how to access the DB is through phpMyAdmin. Looking at the wp_posts table, I only see the 1 post and 1 comment that came as examples with the blog install. The 1 post and 1 comment supposedly imported from my Blogger blog don't show up in the WordPress Dashboard OR in the DB.

I've tried deleting all drafts from my Blogger blog, and I don't have any alt tags or captions in use so I don't think it's a character in a string that's breaking the import. I can't see anything unique about the first post that might break the import.

Any other ideas?
oBifferson
Member
Posted 8 months ago #

Update: I tried erikvisser's advice, went into phpMyAdmin and deleted all content in wp_links, wp_posts, wp_postmeta and wp_comments. I didn't delete anything else because it looks like it would break the blog rather than erase content. Did you erase more than that?

Since the import keeps stopping at 1, I tried deleting the most recent post in my Blogger blog, but that didn't work either.
oBifferson
Member
Posted 8 months ago #

K guys,
The first solution in this thread worked for me!
http://wordpress.org/support/topic/200104?replies=14
legend10
Member
Posted 6 months ago #

Deactivate all your plugins and then check your posts.

Topic Closed

This topic has been closed to new replies.

WordPress.org

Forums

Missing posts after import (29 posts)

Topic Closed

About this Topic

Tags

Code is Poetry