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 haven’t deactivated plugins because I haven’t added any new plugins in weeks
Tried theme switching just there. No effect
The only inactive plugins are the spare twitter tools plugins, again have been there months if not years
I’ve re-uploaded a fresh copy of the site. No joy either
tried adding a new category
it appears in the categories box once I click add but if I refresh the page it disappears
I have ran
SELECT * FROM wp_term_taxonomy WHERE taxonomy=”category” LIMIT 15;
This shows me all my categories are still in the database
I trace them across the taxonomy for example the news category is
SELECT * FROM wp_terms WHERE term_id = 1;
+———+——+——+————+
| term_id | name | slug | term_group |
+———+——+——+————+
| 1 | News | news | 0 |
+———+——+——+————+
1 row in set (0.00 sec)
and back as far as the relationship
SELECT * FROM wp_term_relationships WHERE term_taxonomy_id = 1 ORDER BY object_id DESC LIMIT 10;
+———–+——————+————+
| object_id | term_taxonomy_id | term_order |
+———–+——————+————+
| 35187 | 1 | 0 |
| 35167 | 1 | 0 |
| 35146 | 1 | 0 |
| 35144 | 1 | 0 |
| 35135 | 1 | 0 |
| 35130 | 1 | 0 |
| 35127 | 1 | 0 |
| 35115 | 1 | 0 |
| 35113 | 1 | 0 |
| 35111 | 1 | 0 |
+———–+——————+————+
I am unsure what is happening here, this is bizarre to say the least.
My theme has a recent news function that allows a list of news excluding categories. It still lists the categories absolutely fine.
So only WP is not showing categories, and they seem to still be in the DB absolutely fine.
Created a test wordpress system with twenty ten theme, out of box database and no plugins
Still has the category problem
Sadly, this seems to have just resolved itself. I have no answer as to why it’s suddenly working, all I did was backup the entire contents of the site incase I had to do something drastic and whilst it downloaded I went away for a few hours. Came back to the site working.
I’m confused but running with it for now.