class-wp-term-query.php:686 – Syntax error cause NOT IN() empty

My menu in Theme -> Menu dissapeared and nav-menus.php alwayes redirect on action=edit&menu=0 (cause wp_get_nav_menuse return empty array), and I have a lot of errors (~12) with empty NOT IN statement.

Query Monitor:
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.term_order 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 ('nav_menu')
AND t.term_id NOT IN()
ORDER BY t.term_order ASC

WP_Term_Query->get_terms()
wp-includes/class-wp-term-query.php:686
WP_Term_Query->query()
wp-includes/class-wp-term-query.php:291
get_terms()
wp-includes/taxonomy.php:1119
wp_get_nav_menus()
wp-includes/nav-menu.php:557

All of errors with syntax error in NOT IN statement in class-wp-term-query.php:686

What is it?

• This topic was modified 7 years ago by mrzherart.