no categories table and lost database

  • Resolved aubrey

    (@aubrey)


    18 years, 7 months ago

    I upgraded to 2.3 and lost my categories table. Then I lost all my posts that were in the categories. I am really bummed. I tried to reinstall wordpress, but it said I had to delete my previous database. I backed it up and deleted it and all that is backed up is the uncategorized posts.

    Now I cannot even install WordPress on my server. When I run the install script this is what I get.

    ‘.__(‘Already Installed’).’

    ‘.__(‘You appear to have already installed WordPress. To reinstall please clear your old database tables first.’).’
    ‘); switch($step) { case 0: case 1: // in case people are directly linking to this ?>

    Did I completely lose my blog? How do I install again?

Viewing 9 replies - 1 through 9 (of 9 total)
  • MichaelH

    (@michaelh)

    18 years, 7 months ago

    The wp_categories, wp_post2cat, and wp_link2cat tables were melded into the three new terms tables. Those new terms tables also support the new tag feature.

    If you followed the upgrade instructions, then you have a database backup from before you upgraded. Restore from that. If you don’t have a backup ask your host if they have one.

    Thread Starter aubrey

    (@aubrey)

    18 years, 7 months ago

    thanks, i figured it out

    yoyenta

    (@yoyenta)

    18 years, 1 month ago

    I just upgraded from WP 1.5 to 2.5 and the upgrade.php wizard did not transfer my categories table into the terms table.

    I searched this forum and I don’t see anywhere how this transfer can be done automatically. Therefore I’m going to attempt to transfer the data myself.

    Using PHP_MyAdmin I’m making duplicates of my wp_categories table and changing the field names to match those of the wp_terms and wp_term_taxonomy tables.

    moshu

    (@moshu)

    18 years, 1 month ago

    Therefore I’m going to attempt to transfer the data myself.

    Very unlikely that it will work…

    I’d try another upgrade with a copy of the backed up database. Eventually, a gradual one, e.g. 1.5.x > 2.0.11 > 2.3 > 2.5
    The big change for cat tables happened in 2.3.

    yoyenta

    (@yoyenta)

    18 years, 1 month ago

    It took some SQL work but I finally got it… the categories all show up in the Dashboard but all of my blog posts remain “orphans”. The former association with the categories has been severed. When I can fish that out and change it in the database I’ll post my solution. Too bad the upgrade didn’t handle all of this for me.

    yoyenta

    (@yoyenta)

    18 years, 1 month ago

    moshu, thanks for the suggestion. Maybe the next poor soul who still operates an older version of WordPress will take heed to my upgrading dilemma (No to mention that image uploads still don’t function for me).

    yoyenta

    (@yoyenta)

    18 years, 1 month ago

    I just transfered all of the data from my old table wp_post2cat into the new 2.5 table wp_term_relationships. All of my posts are once again labeled correctly and I even browsed through my blog under each category’s page to make sure it worked.

    One problem remains, on my pages under the “categories” box on the sidebar only ONE category shows up! Even though all of my categories are the dashboard and all of my posts are labeled again there must be something I overlooked in the database.

    I’ll figure it out tomorrow. Only advanced users of PHP MyAdmin should attempt this. Everyone else try moshu’s suggestion for upgrading from WordPress 1.5 to 2.5.

    yoyenta

    (@yoyenta)

    18 years, 1 month ago

    …oK quick fix and I’m done! I created a brand new post and I added it to ALL of the categories. This ‘forced‘ all of the categories to be counted and displayed on the sidebar. As far as transferring and displaying my categories from 1.5 to 2.5, as Borat would say, “Great Success!”

    Good luck to the rest of you with the old dinosaur versions of WordPress.

    yoyenta

    (@yoyenta)

    18 years, 1 month ago

    I spoke too soon, Link categories is broken too. I’m sure its the same process.

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

The topic ‘no categories table and lost database’ is closed to new replies.

Tags