How to re-index wp_posts table?

  • Resolved xmiinc

    (@xmiinc)


    17 years, 4 months ago

    Can anyone confirm how I would ‘re-index’ the wp_posts table? I’m looking at the Optimize operation done from phpmyadmin. It sounds like that’ll do what I want, but I’m not enuf of a mysql guru to be sure?

    The issue:
    The Manage>Posts admin page of my blog began sprouting double entries after a certain index count, but they are simply misassigned entries, as the db itself shows properly unique entries (post text) for each id. However, the problem seems to begin where the table index-count becomes non-sequential (due to manual deletions over time). So I’m assuming WP is for some reason choking on non-sequential ids and therefore re-indexing the table would make WP happy again.

    Do the symptoms support my analysis, and will re-indexing (via ‘Optimize Table’) likely solve the problem?

    [currently running WP v1.5.1.1 preparing to upgrade to v2.0x]

Viewing 5 replies - 1 through 5 (of 5 total)
  • jkozuch

    (@jkozuch)

    17 years, 4 months ago

    Hmmm… I would try to repair the table and then optimize. That might solve your problem. I’ve not had such a problem with WP before, so I can’t say for sure why this is happening or if your suggestion would work.

    Thread Starter xmiinc

    (@xmiinc)

    17 years, 4 months ago

    yeh, I saw that too. the info given on optimize sounded somehow more applicable. everything else about the records and their corresponding table relationships is fine. just want to re-factor that auto-index. the more I think about it the more I realize I need to know that I can do this while still maintaining the correct dependencies. (Does wp_posts in fact contain the unique identifier that all other tables in the database use?) (yup, i will remember backup beforehand). And for that matter, that WP would even behave this way under these circumstances. I haven’t bothered to look at php-code yet, only because I don’t think I ever messed with anything there, and certainly not recently. thx, tom

    moshu

    (@moshu)

    17 years, 4 months ago

    Does wp_posts in fact contain the unique identifier that all other tables in the database use?
    No.
    One of the most important relational data is in the post2cat table where – as you might guessed – the post ID and the assigned category ID is stored.

    I have blogs where I’ve deleted zillions of posts, so, let’s say after ID# 25 comes 42 and then 78, but it never caused any problem. Therefore I suggest to look at other issues, too, if WP is “choking”…

    Thread Starter xmiinc

    (@xmiinc)

    17 years, 4 months ago

    thanx, moshu…I had begun to suspect as much…mounting code-hat and specs 😉

    Thread Starter xmiinc

    (@xmiinc)

    17 years, 3 months ago

    Turned out, upon closer inspection, that this was a db issue after all that was likely the result of my service provider messing with my email-posts cronjob (as near as I can tell) at some point this past summer (with no notification, of course!@#$%). This resulted in around 2 dozen duplicate posts spaced 27 days apart from the originals. For some reason this was more easily apparent in WP-Manage Posts, but required some fancy sorting to verify on the db.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to re-index wp_posts table?’ is closed to new replies.