• Resolved billdennis5

    (@billdennis5)


    I hate to keep beating up on WordPress (especially since I’ve been promoting it on my blog for the years I’ve been using it).

    But I am furious at the lack on information on how to fix the database errors I’ve been getting since I upgraded.

    Folks: Listen to me very carefully: This is NOT a problem with plugins. I am getting these database errors WITH NO PLUGINS RUNNING.

    This is what by readers and advertisers are seeing at the top of my site,l ever single time (with my site username redacted:

    WordPress database error: [Table ‘XXXXXXX_wrdp1.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories

    This is what I and my writers see when they try to write or edit a post:

    WordPress database error: [Table ‘peoriapu_wrdp1.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories

    Warning: Cannot modify header information – headers already sent by (output started at /home/XXXXXXX/public_html/blogpeoria/wp-includes/wp-db.php:160) in /home/XXXXXXX/public_html/blogpeoria/wp-includes/pluggable.php on line 391

    None of the solutions offered in the threads are helpful. I have removed the carriage return.

    All this happened after I upgraded.

    My search of the forum finds case after case of this, and no real fixes being offered.

    It’s like the entire WordPress community has shrugged its shoulders and decided to write off the users who are having this problem.

    I can’t continue to use nor can I continue to ask other people to use WordPress unless someone admits there’s a problem with this version of WordPress.

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

    (@moshu)

    Your theme is most likely not compatible with WP 2.3 – meaning it is using Template_Tags that are deprecated.

    What happens if you switch to the default theme?

    MichaelH

    (@michaelh)

    So let’s cover the givens:
    1. You’ve got a backup (both files and database) before the upgrade.
    2. You’ve upgraded to 2.3 (or 2.3.1)

    Version 2.3 no longer has a categories table, but you are getting an error where something is trying to access that categories table.

    Have you disabled all plugins?
    Have you switched your theme to the WordPress Default 1.6 theme?

    Also, what version did you upgrade from? Did you use the Fantastico upgrade?

    Thread Starter billdennis5

    (@billdennis5)

    This is what I get:

    WordPress database error: [Table ‘XXXXXXXX_wrdp1.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories

    MichaelH

    (@michaelh)

    Login and change your Theme to the WordPress Default theme.

    What happens?

    Note: you can login at https://www.peoriapundit.com/blogpeoria/wp-login.php so something is working.

    Thread Starter billdennis5

    (@billdennis5)

    Michael:

    When I switch to the Default theme — included in the 2.3.2 upgrade, I get the following error message:

    WordPress database error: [Table ‘peoriapu_wrdp1.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories

    It’s the same message I get when I use the classic theme or any other theme,

    I upgraded from 2.2.2.

    I did a manual upgrade. I backed my installation and my database.

    MichaelH

    (@michaelh)

    Okay, do this.

    Delete the wp-content/themes/default folder then upload that folder from the 2.3.1 distribution.

    That insures a clean upload of that particular theme.

    Now what happens?

    Thread Starter billdennis5

    (@billdennis5)

    I renamed the old “default” folder to “defaultXXXX” and uploaded the new one. Same error message.

    And here is a new issue I just noticed. When I am writing a post, I see this error message right above the list of available categories:

    WordPress database error: [Table ‘XXXXXX_wrdp1.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories

    This is in the ADMIN PANEL.

    MichaelH

    (@michaelh)

    Are you sure you uploaded all the 2.3 files correctly? Sound’s like some core file is still from the old version.

    I’d go back to Steps 7 and 8 of Upgrading WordPress Extended and delete and reupload the wordpress 2.3.1 files.

    Thread Starter billdennis5

    (@billdennis5)

    That’s an idea.

    I’ll let you know.

    Thread Starter billdennis5

    (@billdennis5)

    OK.

    Done. Now I’m getting a directory of the folders in my installation folder:

    MichaelH

    (@michaelh)

    All I see is your blog ??

    Thread Starter billdennis5

    (@billdennis5)

    OK. I uploaded the index.php folder from my backup, and now everything seems working.

    First, thank you.

    Second, do you have the power to change the headline to this thread? I hate blaming WP because I don’t know how to operate FTP.

    Kafkaesqui

    (@kafkaesqui)

    Second

    How’s that? (You didn’t specify what to change it to :) ).

    Thread Starter billdennis5

    (@billdennis5)

    BWAHAHAHAHA! Love the new title.

    Thanks again for the assistance provided to a cranky old man.

    Hey Everyone! So ok I just want to confirm that WordPress 2.3.2 does NOT have a wp_categories folder in the database anymore.
    I saw MichealH’s post:

    So let’s cover the givens:
    1. You’ve got a backup (both files and database) before the upgrade.
    2. You’ve upgraded to 2.3 (or 2.3.1)

    Version 2.3 no longer has a categories table, but you are getting an error where something is trying to access that categories table.

    Have you disabled all plugins?
    Have you switched your theme to the WordPress Default 1.6 theme?

    Also, what version did you upgrade from? Did you use the Fantastico upgrade?

    Please confirm. My upgrade has been smooth sailing on my site and my friends but I noticed it totally got rid of a few tables including the wp_categories one. Also sort of off topic is there an advantage to using mysql 5.0 over 4.1?? Worth changing to ?

    Thanks all of you in advance

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Has FTP jumped the shark?’ is closed to new replies.