Post Timestamp in Future – Database Problems

  • Hi,

    I’m trying to import some content into the wp_posts database, which works, but I can’t figure out how to make it automatically publish at a later date.

    When I publish the imported content manually (eg. edit timestamp and hit publish) it works, but when I try and upload that into the database, it doesn’t seem to register.

    I’m doing some traveling soon and I don’t want the blog to lay dormant! Here’s my SQL for an example post:

    INSERT INTOwp_posts(ID,post_author,post_date,post_date_gmt,post_content,post_title,post_category,post_excerpt,post_status,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_content_filtered,post_parent,guid,menu_order,post_type,post_mime_type,comment_count`) VALUES
    (123, 1, ‘2007-11-21 17:45:39’, ‘2007-11-21 23:31:15’, ‘I AM THE POST CONTENT’, ‘THIS IS THE POST TITLE’, 19, ”, ‘future’, ‘open’, ‘open’, ”, ‘this-is-the-post-slug’, ”, ”, ‘2007-12-01 17:45:39’, ‘2007-12-01 23:31:15’, ”, 0, ”, 0, ‘post’, ”, 0);`

    So all times are set in the future, and the post_status is “future”. Why is it not publishing when the time comes around?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter dcoops

    (@dcoops)

    Somebody? … Anybody … ?

    Thread Starter dcoops

    (@dcoops)

    I have a large database to post. Could that be the problem? Maybe it’s timing out somewhere. But it shouldn’t then move on without an error. It’s like it forgets ??

    Thread Starter dcoops

    (@dcoops)

    OK. I have confirmed that it’s not the size of the database. It publishes in the future it if I ask it to through the wp-admin interface, no matter the size.

    Here’s the issue:
    However, if I set the timestamp to in 5 minutes and the status to “future“, it never publishes! It just continues to show it in the Dashboard as “about to be published” with 1 minute (late – but it doesn’t say that).

    If I do this through the wp-admin interface, the database says EXACTLY the same, but it DOES CHANGE the post status to “publish”.

    Can someone PLEASE help me figure out how to make it publish?

    Thanks so much.

    This is probably too late, but I had this same problem and here was the problem (and a hint towards the solution):

    https://www.ads-software.com/support/topic/112598

    I’ll post .php code when I finish and test it (for the posterity, I suppose).

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Post Timestamp in Future – Database Problems’ is closed to new replies.