WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Upgrading issues = horror brokeness (3 posts)

  1. irishmark
    Member
    Posted 6 years ago #

    So i wanted to upgrade my version of WP and it all went horribly wrong. From reading posts and the support docs on how to upgrade i decided to go for a clean install of the entire DB.

    So i backed up the DB throught phpMyAdmin and then deleted the db entierly. I also deleted the worpress files on my server.

    Next i created a new DB. I impotrted the old DB backup file.

    I uploaded the new WP files.

    Next I ran the upgrade php file in the admin and i got the following:

    WordPress database error: [Table 'irishmar_wpdb.wp_options' doesn't exist]
    SELECT option_value FROM wp_options WHERE option_name = 'db_version'

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

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

    WordPress database error: [Table 'irishmar_wpdb.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 'irishmar_wpdb.wp_categories' doesn't exist]
    SELECT * FROM wp_categories ORDER BY cat_ID

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

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

    then it says done but it shows none of my posts or anything. One thing i noticed was that ther error message is looking for wp_catagories, wp_comments and so on where as the actual files on the server in phpMyAdmin as wpi4f_catagories, wpi4f_comments and so on...

    How can i get this all working again?

  2. Samuel Wood (Otto)
    Tech Ninja
    Posted 6 years ago #

    Your wp-config.php file has a setting in it called "prefix". This defaults to "wp_".

    Since you didn't save it (you should have), I can't be sure, but I'd bet that you had your prefix set to "wpi4f_" instead.

    Try it anyway. Just edit your wp-config file and change the prefix. Then run the upgrade.

    Keep your backup handy just in case though.

  3. irishmark
    Member
    Posted 6 years ago #

    you are a beautiful beautifful human being! Thank you thankyou thankyou - i was about to have a hernia with this.

    Originally soemone else set this up for me so i dnt realise that but a huge lesson has been learnt!

Topic Closed

This topic has been closed to new replies.

About this Topic