• I just update WP to 2.3 and faced some database error.

    I found somewhere a thread teach me to change following field, after change it works fine.
    * wp_posts: added ‘auto_increment’ to ‘ID’ field
    * wp_comments: added ‘auto_increment’ to ‘comment_ID’ field
    * wp_links: added ‘auto_increment’ to ‘link_id’ field
    * wp_users: added ‘auto_increment’ to ‘ID’ field
    * wp_usermeta: added ‘auto_increment’ to ‘umeta_id’ field

    But today, when try add some new category to the current one, I found that I can not add sub-category ???

    Open the database, by browsing it, I found that the new added categories are still there, but the trouble is that it was displayed?

    Is there anyone facing the same trouble?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The wp_categories table no longer exists if that is what you are looking for. The Categories (and tags) are kept in the three new terms tables. Make sure those three tables have the correct auto_increment.

    See Database_Description

    Thread Starter yurblevn

    (@yurblevn)

    They all are there, and all have auto_increment.

    As mentioned, it works fine when I add new category. The wrong thing just happen when I add a sub-category.

    1. When add new category:
    everything OK
    2.When Add Sub-category to the old category (the one already exist in my old data)(I just update my WordPress from 2.1 to 2.3):
    everything OK
    3. When add sub-category to the new category (the one I add after upgrade from 2.1 to 2.3)
    a. Add okie
    b. After refresh, the new added sub-category disappear (in the manage panel)
    c. When check in the database, the new added sub-category is there,
    ==> the only trouble is that, it disappear after refresh, and never come up again in the manage panel

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can not add sub-category after Update’ is closed to new replies.