Database change between 2.0.2 and 2.3.3?

  • Resolved BinkyM

    (@binkym)


    16 years, 1 month ago

    Folks:

    I found someone running 2.0.2 having a lotta problems validating his blog (that’s when I noted his version) so I updated him to version 2.3.3, all the while wondering whether there may have been changes to the database between his antique version and 2.3.3. Sure enough, there’s a SQL error:

    WordPress database error: [Table ‘examples_com_-_wordpress2_bZldIl87.wp_post2cat’ doesn’t exist]
    SELECT p.id AS id, post_title, post_date, u.user_nicename AS author FROM wp_posts p, wp_post2cat p2c, wp_users u WHERE post_status = ‘publish’ AND post_date_gmt > ‘2008-02-29 00:00:00’ AND p.id = post_id AND p.post_author = u.id AND category_id = 4 ORDER BY post_date LIMIT 5

    I’ve disabled his plugins one by one, looking for the culprit, and that’s not making the error go away, so I’m thinking perhaps one or more tables were added by WP since 2.0.2. If I’m correct, what table(s) must I add to get him up to date? I’d appreciate a pointer.

    He arrived at this sorry state, BTW, by a host who installs the latest (ha!) version of software for their customers (sob!).

    Thanks for any tips!

    Binky

Viewing 6 replies - 1 through 6 (of 6 total)
  • Jeremy Clark

    (@jeremyclark13)

    16 years, 1 month ago

    It has to do with his outdated theme. You don’t need to add any tables but rather get a new theme for him to use, the new default theme from the installation package would work.

    moshu

    (@moshu)

    16 years, 1 month ago

    You don’t have to add any tables. That’s NOT how it works.

    You have to read the “sticky” post on the main page of this forum (about post2cat)

    Further reading:
    http://codex.wordpress.org/Version_2.3

    Thread Starter BinkyM

    (@binkym)

    16 years, 1 month ago

    jeremyclark13, moshu:

    Uh, that would *seem* not to be the problem (I’ve updated him to 2.3.3), but I think you’ve pointed me down a path I can use if I keep my peepers peeled. Thanks a lot! I’ll go read harder!

    Binky

    Thread Starter BinkyM

    (@binkym)

    16 years, 1 month ago

    Ah! I did it! It was that codex that helped me out. He had some plugins that were incompatible. Thanks very much, folks! That did the trick! I’m a happy bunny now! I appreciate it a lot!

    Binky

    moshu

    (@moshu)

    16 years, 1 month ago

    Oops, I missed this
    I’ve disabled his plugins one by one, looking for the culprit,
    The troubleshooting should be done the other way around: disable ALL and turn ON one by one. Reason: if two plugins cause the same error (like calling to the nonexistent post2cat) you will never realize it 🙂

    Thread Starter BinkyM

    (@binkym)

    16 years, 1 month ago

    moshu:

    That’s how I woulda done it on my own blog, but this being someone else’s blog, I didn’t wanna disable them all and then try to remember what had been on and try to re-enable just those. (He has an awful lot of them, and only some of them are enabled. Me, I immediately rip out ones I don’t plan to use as I’m an anal-retentive type.)

    Fer sure, it woulda been easier doing it the “all-off” way!

    BTW, I *did* google the error message and several pieces of it, and the sticky post didn’t turn up in the search. I tried several ays to find it before posting my question. (I know how irritating it is when someone asks a question that’s been answered already, lotsa times!)

    Binky

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database change between 2.0.2 and 2.3.3?’ is closed to new replies.