Title: Post Timestamp in Future – Database Problems
Last modified: August 18, 2016

---

# Post Timestamp in Future – Database Problems

 *  [dcoops](https://wordpress.org/support/users/dcoops/)
 * (@dcoops)
 * [18 years, 6 months ago](https://wordpress.org/support/topic/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 INTO`wp_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](https://wordpress.org/support/users/dcoops/)
 * (@dcoops)
 * [18 years, 6 months ago](https://wordpress.org/support/topic/post-timestamp-in-future-database-problems/#post-656977)
 * Somebody? … Anybody … ?
 *  Thread Starter [dcoops](https://wordpress.org/support/users/dcoops/)
 * (@dcoops)
 * [18 years, 6 months ago](https://wordpress.org/support/topic/post-timestamp-in-future-database-problems/#post-656978)
 * 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](https://wordpress.org/support/users/dcoops/)
 * (@dcoops)
 * [18 years, 6 months ago](https://wordpress.org/support/topic/post-timestamp-in-future-database-problems/#post-656983)
 * 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.
 *  [danielsuo](https://wordpress.org/support/users/danielsuo/)
 * (@danielsuo)
 * [18 years, 4 months ago](https://wordpress.org/support/topic/post-timestamp-in-future-database-problems/#post-657019)
 * This is probably too late, but I had this same problem and here was the problem(
   and a hint towards the solution):
 * [http://wordpress.org/support/topic/112598](http://wordpress.org/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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [posts](https://wordpress.org/support/topic-tag/posts/)
 * [timestamp](https://wordpress.org/support/topic-tag/timestamp/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [danielsuo](https://wordpress.org/support/users/danielsuo/)
 * Last activity: [18 years, 4 months ago](https://wordpress.org/support/topic/post-timestamp-in-future-database-problems/#post-657019)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics