I was upgrading from WP2.3 to WP2.8.1.
Everything went well until I got the WP "Database Upgrade Required" screen. Clicked on "Upgrade Wordpress Database" and encountered a number of duplicate entry errors for INSERT commands into the "wp_terms" and "wp_term_taxonomy" tables. Example:
WordPress database error: [Duplicate entry '1' for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES
(1,'Discounts', 'discounts-2', 1)
Browsing the tables in phpMyAdmin, I see that the rows have been inserted which explains the duplication error so I emptied both tables and ran the upgrade again. Got a blank screen and when I browse back to \wp-admin\ I get the "Database Upgrade Required" page again. So now I'm basically locked out of admin.
Browsing my site, looks like the site is unlocked from maintenance mode and all my posts is there except the categories.
Any help is much appreciated!
not a support question