Wordpress 2.3 upgrade error - Any Ideas?

Discussion in 'PHP' started by comcenter, Oct 5, 2007.

  1. #1
    I recently upgraded wordpress from version 2.1 to 2.3, doing the following:

    1. Uploaded the files.
    2. Updated the database through phpmyadmin.

    PhpMyAdmin works fine, with no errors, and the data in the database is fine; I am just getting this error in the index.php:

    WordPress database error: [Table 'ccenter02_dental.wp_categories' doesn't exist]
    SELECT * FROM wp_categories


    You can the the error at work here: Dratactuk.com

    I contacted a tech at my host who provided this link in order to force a database update, which I did, and it was the reason I was able to take step 2 above, as mentioned in the article, however I am still getting an error.

    I have looked all over wordpress faqs and forums, unsuccesfully, has anyone here seen this before, or has any idea what it could be?

    I am editing this post to add a $10 incentive (via paypal only).
    ..
     
    comcenter, Oct 5, 2007 IP
  2. Pixelrage

    Pixelrage Peon

    Messages:
    5,083
    Likes Received:
    128
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I got the same exact error last night. I wound up re-installing a fresh copy of wordpress and restoring my old database, and it worked. That was the "hard way" to do it, I didn't know how else it could be done, after fighting with it for a long time.
     
    Pixelrage, Oct 5, 2007 IP
  3. comcenter

    comcenter Well-Known Member

    Messages:
    706
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    130
    #3
    I tried executing the upgrade again, uploaded all the files, updated the database, and get the same error.
    I would really like to avoid installing a fresh copy of the script, the plugins, images, configuration, etc.
     
    comcenter, Oct 5, 2007 IP
  4. chandubhai

    chandubhai Banned

    Messages:
    556
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Please PM me, ill help u out
     
    chandubhai, Oct 5, 2007 IP
  5. comcenter

    comcenter Well-Known Member

    Messages:
    706
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    130
    #5
    Things I have tried and failed:

    1. Upgrading all over again.
    2. Upgrading Google sitemaps plugin to 3.0
    3. Changing the theme to a 2.3 compatible theme according to the wordpress codex website.

    ..
     
    comcenter, Oct 5, 2007 IP
  6. chandubhai

    chandubhai Banned

    Messages:
    556
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Is this the name of your database?
    ccenter02_dental
     
    chandubhai, Oct 5, 2007 IP
  7. comcenter

    comcenter Well-Known Member

    Messages:
    706
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    130
    #7
    Yes it is...

    ..
     
    comcenter, Oct 5, 2007 IP
  8. chandubhai

    chandubhai Banned

    Messages:
    556
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    0
    #8
    and does wp_categories table exist
     
    chandubhai, Oct 5, 2007 IP
  9. comcenter

    comcenter Well-Known Member

    Messages:
    706
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    130
    #9
    The issue has been solved, thanks all for your comments.

    Thread closed.
     
    comcenter, Oct 5, 2007 IP