Cannot Edit Menu or Categories, and Categories Have Disappeared

I cannot edit my menu (the theme I’m using only uses one), except by a workaround by using the customize/live preview mode. It still doesn’t save the menu out in the admin page and I can’t change it there regardless. This happens with any theme and with all plugins disabled.

The additional issue (I bring up because it seems to be related) is that my categories have disappeared and I cannot add new ones at all. This, again, is regardless of theme or active plugins.

After running some tests on a localhost, I have only been able to unearth that there appears to be something wrong with the syntax of my database, these are the errors I get using the DEBUG mode:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) ORDER BY t.name ASC’ at line 1]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND t.term_id NOT IN() ORDER BY t.name ASC

I have no idea what any of that means, despite my best efforts to decipher it.

Any help would be very much appreciated. Built this site for a client and the break seemed extremely sudden. I don’t manage the backend of the host, I have to communicate with someone to make any changed that way, but I’m trying to fix it on my localhost so I can just send him a new site that works.

• This topic was modified 8 years, 1 month ago by pfduda.