Mixed-up Database Tables on Upgrading

  • Resolved stevie7v

    (@stevie7v)


    17 years, 11 months ago

    I’ve recently attempted to upgrade from 1.5 to 2 and now to 2.1.3.

    My database seems to be a combination of the tables from 1.5, 2.0 and 2.1.

    For example, the database has tables wp_categories, wp_comments, wp_link2cat, wp_linkcategories, wp_links, etc. (a combination of v2.0 and v2.1)

    The wp_categories table doesn’t contain the fields link_count, posts_private and links_private (so it’s as v1.5 and 2.0).

    Can anyone help me sort out this mix up and get to version 2.1.3? I have already rerun the installation program. What am I missing?

    Thanks

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

  • Have you run the updage script after each upgrade? I’m betting that you didn’t.

    Upgrading_WordPress

    Thread Starter stevie7v

    (@stevie7v)

    Do you mean the Upgrade script as in:

    Step 1

    There’s actually only one step. So if you see this, you’re done. Have fun!

    No I’ve done that, unfortunately. The problems remain.

    I’d consider deleting the current database tables, restoring the 1.5.2 database, deleting the current WordPress files, downloading a clean 2.1.3 distribution, reuploading the 2.1.3 WordPress files, then redoing the upgrade.php.

    Thread Starter stevie7v

    (@stevie7v)

    Michael, thanks for that. I tried but couldn’t run the install program after uploading WP 1.5.2.

    I figure that there must be a problem with my DB configuration since I get the same problems whatever theme I select. I would like to clean out my DB and start again. My web site host doesn’t have PHPmyadmin but I have wp-phpmyadmin. Can I use that to ‘clean’ my DB and, if so, how (bearing in mind that the WP-phpmyadmin plugin is, presumably, a part of my DB)? Also, it might help if I knew where exactly the DB is located.

    I really need to get up and running so will be grateful for any further help.

    Thread Starter stevie7v

    (@stevie7v)

    Update:

    I finally managed to fix this by clearing the database and starting with WordPress’ own ‘wp-content’ folder.

    Thanks for your help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Mixed-up Database Tables on Upgrading’ is closed to new replies.