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: So all times are set in the future, and the post_status is "future". Why is it not publishing when the time comes around?
Why are you trying to do it via database? Just edit timestamp of the post and set it to whatever date you need and then hit publish. Post will become active on that date/time. I think there might be some additional references in DB created besides the table you are modifying to make that post active and by going through DB you are not touching it. Just write post as normal, edit Timestamp and set for future date, then publish. Mission accomplished. Alex
correct! just look at your right sidebar, you can change the datetime anytime. but beware, if your permalink has date on it, you will lose your old permalink. thanks
Thanks guys! The problem is, I want to do it by database because I don't want to leave my blog for 2 months at 2 posts per day and have to log in and post 120 things manually! post2cat is the other table that has stuff, but that's not related to publishing
Does anyone have any other feedback on how I can do this without logging in every day and hitting "post"?