WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] multiple database errors upon upgrade to 2.6.1 (2 posts)

  1. Robert Simpson
    Member
    Posted 5 years ago #

    Hi folks,

    After replacing my old files and running the upgrade script I'm getting this:

    ------------------------------------------------------

    WordPress database error: [Table 'rsimpson_workwp.wp_categories' doesn't exist]
    SELECT cat_ID, cat_name, category_nicename FROM wp_categories

    WordPress database error: [Table 'rsimpson_workwp.wp_post2cat' doesn't exist]
    SELECT DISTINCT post_id FROM wp_post2cat

    WordPress database error: [Table 'rsimpson_workwp.wp_categories' doesn't exist]
    ALTER TABLE wp_categories ADD INDEX ( category_nicename )

    WordPress database error: [Unknown column 'user_nickname' in 'field list']
    SELECT ID, user_nickname, user_nicename FROM wp_users

    WordPress database error: [Table 'rsimpson_workwp.wp_categories' doesn't exist]
    SELECT * FROM wp_categories ORDER BY cat_ID

    WordPress database error: [Table 'rsimpson_workwp.wp_post2cat' doesn't exist]
    SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

    WordPress database error: [Table 'rsimpson_workwp.wp_linkcategories' doesn't exist]
    SELECT cat_id, cat_name FROM wp_linkcategories

    Upgrade Complete

    Your WordPress database has been successfully upgraded!

    ------------------------------------------------------

    Initially I tried to get back into the dashboard but it looks like it completely wiped out my database and renamed the installation to "My Blog".

    Any ideas?

    Cheers,
    Robert

  2. Robert Simpson
    Member
    Posted 5 years ago #

    I'm a complete idiot. I had the wrong table prefix in the config file.

Topic Closed

This topic has been closed to new replies.

About this Topic