Support » Fixing WordPress » Could not insert term into the database

  • I’m unable to add categories or menus.
    I have read all the posts related to this topic and tried some things from it. like disable all plugins etc but the issue is still there.
    Any help is welcome

Viewing 15 replies - 1 through 15 (of 17 total)
  • What error message do you get?

    Thread Starter mkauzlar

    (@mkauzlar)

    Just like in the title: Could not insert term into the database

    How old is this site? How large is it? Is it possible that your database size is being limited by your hosts?

    Thread Starter mkauzlar

    (@mkauzlar)

    The site is:

    http://www.jk-krilakvarnera.hr/

    Which is a gliding club site. It’s a simple site without fancy features and quite small. I think is there a few years and wasn’t updated. I’m now tasked to update it and maintain it.
    The db size is now about 1.1 mb

    Have you tried:
    – repairing your database?
    – contacting your host to ask if the database size is being limited?

    Thread Starter mkauzlar

    (@mkauzlar)

    I ran a tool called db optimize (I don’t know how else to repair the db). When I ran the tool I get:

    krila_wordpressjkk.wp_categories status : Table is already up to date 68 Byte 0 Byte krila_wordpressjkk.wp_comments status : Table is already up to date 2.17 kiB 0 Byte krila_wordpressjkk.wp_link2cat status : Table is already up to date 0 Byte 0 Byte krila_wordpressjkk.wp_links status : Table is already up to date 304 Byte 0 Byte krila_wordpressjkk.wp_options status : OK 328 kiB 0 Byte
    krila_wordpressjkk.wp_post2cat status : Table is already up to date 575 Byte 0 Byte krila_wordpressjkk.wp_postmeta status : Table is already up to date 71.2 kiB 0 Byte krila_wordpressjkk.wp_posts status : OK 746 kiB 0 Byte
    krila_wordpressjkk.wp_usermeta status : OK 5.28 kiB 0 Byte
    krila_wordpressjkk.wp_users status : Table is already up to date 808 Byte 0 Byte

    I didn’t contact the hosting provider yet.

    I don’t know how else to repair the db

    You can usually carry this out via a database management tool such as Phpmyadmin. Your hosts will be able to tell you which tool they offer.

    Thread Starter mkauzlar

    (@mkauzlar)

    I have a tool called portable pma which gives you the phpmyadmin interface.
    In the phpmyadmin i selected all the tables and chose repair option.
    Phpmyadmin is saying that all tables are ok.
    Is there any other thing to do onthe database?

    Thread Starter mkauzlar

    (@mkauzlar)

    Also running aquery on the categories table shows that there are two categories which don’t show up in wp

    Have you tried contacting your host to ask if the database size is being limited?

    Thread Starter mkauzlar

    (@mkauzlar)

    I have sent an email and waiting for answers. Isuspect it won’t be quick.

    Thread Starter mkauzlar

    (@mkauzlar)

    While im waiting for the host i did the following:

    Installed wp at home and imported the site
    The site running at home has the same problem which implies that it’s not a db size limit problem.
    What can I do on the site at home to troubleshoot?

    Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the Twenty Eleven theme to rule out any theme-specific problems.

    resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

    – re-uploading the wp-admin and wp-includes folders from a fresh download of WordPress.

    Thread Starter mkauzlar

    (@mkauzlar)

    I did most of it as mentioned in the first post.
    Yesterday i made a mistake and tested it on the live site instead of the pc at home. The install on the pc at home works.
    I was able to add a category and then i saw it’s stored in a table called wp_terms. This table doesnt exists in the live environment which has wp_categories (not present in the install home).
    In fact many tables have different names.
    Could this be the issue?
    Also the live environment was upgraded from wp 2.x to 3.2.1 some time ago

    If that upgrade was carried out in a single step instead of a series of smaller upgrades, it’s highly likely that your live database has been permanently damaged.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Could not insert term into the database’ is closed to new replies.