How Can I change draft post to scheduled post with sql and php?

  • makinist99

    (@makinist99)


    11 years, 5 months ago

    Hello Everyone,

    I want to change drafts posts to scheduled post.
    I changed post_status = ‘future’ and Post_date
    But on post date time post cannot publish. post_status is still ‘future’
    and showing message = missed schedule

    —I update with this query..
    UPDATE wp_posts SET post_date_gmt = ‘$futuredate’, post_date = ‘$futuredate’, post_status = ‘future’ WHERE id=”.$row[‘ID’];

    Note: if I add a scheduled post with wordpress, There is no problem. On date time post is publishing.

  • The topic ‘How Can I change draft post to scheduled post with sql and php?’ is closed to new replies.