Post IDs misordered

  • Purple Frog

    (@purple-frog)


    15 years, 9 months ago

    I realise that the database assigns IDs numbers to not just posts but comments, pictures and so on which results in posts not having sequential numbering.

    However the general progression of the numbers doesn’t match the date my posts were written ie. a could write a post today that has ID #20, and write one tomorrow that has ID #25, and then one the day after that has ID #15.

    So I have some old posts with numbers that seem recent but cant be.

    I read about MySQL 5.something being buggy and screwing up numbering and have also read that when you export posts it can re-assign numbers so that when you re-import them they can be different, and even read that when importing if it finds an ID number clash it will find an alternative free number.

    We were definitely on the buggy MySQL for a while but have since upgraded and have done exports and imports when the site moved but why would numbers of posts be wrong apart from that?

    I have two year old post that according to the numbering gives the impression it was written in the last six months. Any ideas why?

    thank you

    James

Viewing 1 replies (of 1 total)
  • viktormorales

    (@viktormorales)

    15 years, 2 months ago

    I am facing the same issue. Playing with theme code, I have noticed the following:
    [code]
    # Would show the fine the order of the posts
    $args = array("posts_per_page" => 2, "cat" =>);
    $my_query = new WP_Query( $args );

    # But if: "cat" => -#, for excluding categories, posts would misorder
    $args = array("posts_per_page" => 2, "cat" => -6);
    $my_query = new WP_Query( $args );

    # But if: "cat" => #, for including categories, posts would be ordered fine
    $args = array("posts_per_page" => 2, "cat" => 6);
    $my_query = new WP_Query( $args );
    [/code]

    So… WP bug?!…

Viewing 1 replies (of 1 total)

The topic ‘Post IDs misordered’ is closed to new replies.