Post straight to db all posts are unpublished?

  • Hi there im posting direct to the wordpress database and only just noticed that when i log in and go to the manage page that all the posts are classed as unpublished but they are all showing … is there a way to show them all as published when posting to the database?

    the only reason i now want this is to use friendly urls as i noticed the ones that are classed as unpublished show no url at all

    thx in advance

Viewing 4 replies - 1 through 4 (of 4 total)

  • youre not filling in the field “post_status” By default, WP displays posts that are published. If there is nothing in that field that indicates that, then it wont display.

    In 2.1 the available choices for that field are:

    ‘publish’, ‘draft’, ‘private’, ‘static’, ‘object’, ‘attachment’, ‘inherit’, ‘future’ or, in your case, ‘blank’.

    Thread Starter pipster

    (@pipster)

    In the database that field is filled in and the posts are showing on the front … its just in the back end of wordpress that the manage page is showing the posts as unpublished and the fancy urls will not work but i think i noticed the field post-name and post title are filled in but on the ones that are unpublished only post-title is filled in so im thinking that the field needs to be filled in for the urls but still didnt solve the issue of it stating it was unpublished lol

    are you also populating the post2cat field as you go?

    Thread Starter pipster

    (@pipster)

    yes thats being filled also ….. the posts are showing as normal on the front page just showing as Unpublished in the backend of wordpess but in the database theyre sowing publish also … strange on but its not worying theyre posting so ill just keep trying different ways lol

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Post straight to db all posts are unpublished?’ is closed to new replies.