I really need to batch publish my posts (6 posts)

  1. 3eamus
    Posted 8 years ago #

    I'm really hoping the right person out there in the WP community reads this:

    I've spent 2 weeks migrating our blog with over 5,000 posts from MT to WP 2.5 only to find out that I can't batch publish posts? In fact there's not batching of any kind. I have to publish each one individually. Please tell me this isn't true as there must be a hack for this. The posts are technically published, but IE 6 and 7 doesn't see the permalinks until I publish the post again.

    Thanks a million,

  2. haochi
    Posted 8 years ago #

    Didn't you just posted the same question?

    Do you mean by posting the existing ones (from MT) or new ones?

  3. 3eamus
    Posted 8 years ago #

    The existing ones from MT (over 5,000 entries that I imported).

    They imported fine, they're published, but IE doesn't see the individual pages until I re-publish them.

    Any tricks that you know of?

  4. haochi
    Posted 8 years ago #

    What do you mean by not showing up in IE?
    Any link(s)?

  5. semioticghost
    Posted 8 years ago #

    I ran into the same problem when importing several blogs from Movable Type into WordPress 2.5. The posts display on the main page of the blog as if they're published, but they don't display as individual posts (permalinks don't work). This only occurs in IE 6 and 7.

    In the "Manage Posts" section the imported posts don't display as published or unpublished. To make them display in IE 6 and 7 you have to go into each entry and hit publish even though the post is technically published. What 3eamus and I are looking for is a way to batch publish entries so that we don't have to publish thousands of posts one by one.

  6. semioticghost
    Posted 8 years ago #

    Okay. I just figured this out. You can fix everything with access to your MySQL database and one easy command.

    1. Choose the database where your WP blog is living (mysql> use [database_name_here];)
    2. Change the post status on all posts to publish (mysql> update wp_posts set post_status = 'publish';)

Topic Closed

This topic has been closed to new replies.

About this Topic