Could not insert term into the database

What error message do you get?

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?

The site is:

https://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?

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.

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?

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?

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

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.

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.