WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] 2.3 upgrade --> wp database error (10 posts)

  1. plastiquemonkey
    Member
    Posted 6 years ago #

    i can see from multiple posts on the forum that i'm not the first to have a newly-missing from 2.3 database table cause errors after upgrading. i'm only writing here because i've tried various solutions described here and the problem is still ongoing.

    my error message is:

    WordPress database error: [Table '****_****blog.wp_categories' doesn't exist]
    SELECT * FROM wp_categories

    i've deactivated all plugins and updated to a supposedly compatible version of the theme (tarski 1.7.1). the error message is still there.

    i've tried the extended upgrade, deleting files as specified here, then re-uploading the 2.3 files, but the error is still there.

    any ideas?

  2. MichaelH
    Member
    Posted 6 years ago #

    Where are you seeing the error? On your site? What happens if change to the WordPress Default 1.6 theme?

  3. plastiquemonkey
    Member
    Posted 6 years ago #

    tried that already, just forgot to mention. even when i change to the default theme, the error is still there.

    when i first click a link i get an all-white page with the error message top left. then, half a second later, the page loads with the error message right at the top, centered. it's sitting just above the header image.

  4. plastiquemonkey
    Member
    Posted 6 years ago #

    interesting -- on the "About" page the same error message shows up in the sidebar, just above the categories (which then display below it, normally).

    and then, under the about page i get this:

    Fatal error: Call to undefined function: update_comment_cache() in /home/../../../wp-includes/comment-template.php on line 303

    is it a theme issue?

  5. MichaelH
    Member
    Posted 6 years ago #

    I'd consider deleting the WordPress files and reuploading as per Steps 7 and 8 in Upgrading_WordPress_Extended.

  6. plastiquemonkey
    Member
    Posted 6 years ago #

    i did that already. should i try it again?

  7. MichaelH
    Member
    Posted 6 years ago #

    You got a link to see the problem?

  8. rawalex
    Member
    Posted 6 years ago #

    I have the same error on an upgrade I did today. I cannot post the URL because of the content of the blog.

    WordPress database error: [Table 'xxxxxxxxxxx.wp_categories' doesn't exist]
    SELECT cat_name FROM wp_categories ORDER BY cat_name ASC

  9. plastiquemonkey
    Member
    Posted 6 years ago #

    so i rolled back the entire upgrade -- dropped tables and imported my db backup, deleted all files and re-uploaded my backups -- then went through the upgrade again, this time upgrading to tarski 1.7.1 (2.3 compatible) *before* upgrading wordpress...

    ...and it worked, perfectly. no idea why the initial problem -- maybe the error was being cached somehow?

    anyway, thanks for your help.

  10. rawalex
    Member
    Posted 6 years ago #

    Okay, found the issue, the "Add Meta Tags" plugin apparently wants a table that no longer exists.

Topic Closed

This topic has been closed to new replies.

About this Topic