Database Problem

  • hawk191

    (@hawk191)


    18 years, 5 months ago

    I was upgrading wordpress today and I got this error after doing so. There were no problems before I upgraded and I didn’t do anything to the database.

    WordPress database error: [Table ‘dailypro_wrdp1.wp_terms’ doesn’t exist]
    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (58) ORDER BY t.name ASC

Viewing 6 replies - 1 through 6 (of 6 total)
  • moshu

    (@moshu)

    18 years, 5 months ago

    Well, the upgrade process “does” a lot to the database…

    According to that error message your upgrade wasn’t successful. Did you follow the instructions?
    Upgrading_WordPress

    Thread Starter hawk191

    (@hawk191)

    18 years, 5 months ago

    I did everything, and even after going to the upgrade URL i get this message:

    No Upgrade Required
    Your WordPress database is already up-to-date!

    moshu

    (@moshu)

    18 years, 5 months ago

    see if this helps
    http://codex.ww.wp.xz.cn/FAQ_Installation#How_do_you_force_a_database_upgrade.3F

    Thread Starter hawk191

    (@hawk191)

    18 years, 5 months ago

    That doesn’t seem to be the problem either that was all ready set correctly.

    waveway2

    (@waveway2)

    18 years, 5 months ago

    I have same kind of problems. When I update it won’t run upgrade.php. Claims that server cuts connection. When I go to main site it has this message on top and on every post too:

    WordPress database error: [Table ‘sfi9xxxx.wp_terms’ doesn’t exist]
    SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘post_tag’) AND tr.object_id IN (219) ORDER BY t.name ASC

    Don’t really know what can I do. I checked the link provided on this thread and then checked the db version number but it is 4773 like it should be.
    I’m upgrading from 2.1.3

    Luckily I have backups. so back to version 2.1.3

    Thread Starter hawk191

    (@hawk191)

    18 years, 5 months ago

    I deleted all the old files and uploaded the new version, and now it works fine. for some reason it wouldn’t work right uploading over old files.

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

The topic ‘Database Problem’ is closed to new replies.