WordPress.org

Ready to get started?Download WordPress

Forums

"wp_categories' doesn't exist" error in database wp 2.3 (41 posts)

  1. stonegauge
    Member
    Posted 6 years ago #

    I figure out what was wrong and it WASN'T the theme.

    I uploaded 2.3.1 via Dreamweaver MX and opted not to upgrade certain files... That lead to the conflict. The minute I re-installed by uploading ALL WP 2.3.1 files, it worked fine with no errors.

    Oh well... Thanks again Moshu

  2. moshu
    Member
    Posted 6 years ago #

    You should always use a decent FTP client for managing your WP files. And not upgrading "certain files" is not really an option left to the users!

  3. 9114619
    Member
    Posted 6 years ago #

    i found this great explanation here:
    just need to edit theme templates a little bit by replacing 3 stuffs:

    * cat_ID –> term_ID
    * categories –> terms
    * cat_name –> name

    THIS IS EXACLY THE KIND OF THING WE NEED IN THE DOCUMENTATION OF WORDPRESS 2.3.1... I can't believe this is the only place (asside from that original blog post) where it's talked about! You change WP at it's CORE and fail to mention simple name changes?! WOW...

  4. billdennis5
    Member
    Posted 6 years ago #

    I completely agree. I'm going crazy trying to find exactly where I am supposed to make the changes necessary. Naturally, every single person here with an answer assumes the people they are talking to plays with php for a living ... oh well. It's open source, so I get what I paid for.

  5. billdennis5
    Member
    Posted 6 years ago #

    Sp THIS is the solution:

    * cat_ID –> term_ID
    * categories –> terms
    * cat_name –> name

    So. What do I do with this? Do I have it drawn on my forhead? Do I write this down on a sheet of paper mail it to Santa Claus? What?

    A little more clarity would be appreciated.

    Thanks in advance.

  6. MichaelH
    Member
    Posted 6 years ago #

    Turns out billdennis5 problem was something different:
    http://wordpress.org/support/topic/142157

  7. billdennis5
    Member
    Posted 6 years ago #

    Yep. That's me. The cranky old idiot.

    ;-)

  8. lunamania
    Member
    Posted 6 years ago #

    I've tried all of the plug-in and template change suggestions here and am still getting the following error.

    WordPress database error: [Table 'lunamani_wp_1.wp_post2cat' doesn't exist]
    SELECT DISTINCT posts.ID, posts.post_title FROM wp_posts posts, wp_post2cat post2cat WHERE posts.ID <> 365 AND posts.post_status = 'publish' AND posts.ID = post2cat.post_id AND post2cat.category_id IN(4) ORDER BY posts.post_date DESC LIMIT 5

    I'm using this template:
    http://peety-passion.com/milo/2007/10/07/lumozero/

    I do not get the error on the default and other templates. Any help would be really appreciated. Thanks.

  9. Milo
    Member
    Posted 6 years ago #

    ⇔lunamania
    Please upgrade your theme here!
    Linked to the post, but did not visit it?

  10. baronep
    Member
    Posted 6 years ago #

    all, same problem with database. Have all the plugins below. The one bugging the thing out is the Google Sitemaps 2.7.1, in my case. But new version Google XML Sitemaps 3.0.2.1 works cool. All the other plugins work just fine.
    Hope helps someone.

    Akismet 2.0.2
    All in One SEO Pack 1.3.9
    Character Map 0.3
    Get Recent Comments 2.0.2
    Google Sitemaps 2.7.1
    IImage Gallery 1.9
    JÄÅ Preview Plugin 1.0
    JPF Quotes 3.0
    My Category Order 2.3
    Polyglot 2.3
    Real WYSIWYG 0.0.2
    Recent Comments 1.18
    Spam Karma 2 2.3
    Time of day 1.0.1
    Ultimate Tag Warrior
    Ultimate Tag Warrior: Tag Archive
    Viper's Video Quicktags 5.3.0

  11. HairyPotter
    Member
    Posted 6 years ago #

    I agree completely, when I read the explanation about "the famous 5 minute installation" I knew it would be a nightmare. I am trying to update my wordpress installation since yesterday. 22 hours trying... zillions of errors.-.. 5 MINUTES, THEY SAY.... I had to restore the database 3 times and try different methods. This upgrade via browser sucks to infinity + 1. Instead of developing a shell program that could update that, a genius developed a php program to upgrade via browser. If you have a large database, of course the browser window will time out and you will be in hell.

Topic Closed

This topic has been closed to new replies.

About this Topic