Thanks, I was able to fix using wp-debug, but this is showing me MYSQL error in category page “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 ‘) GROUP BY terms.term_id’ at line 15]
SELECT COUNT( DISTINCT royal_posts.ID ) as term_count, terms.term_id as term_count_id FROM royal_posts INNER JOIN royal_term_relationships AS term_relationships ON royal_posts.ID = term_relationships.object_id INNER JOIN royal_term_taxonomy AS term_taxonomy USING( term_taxonomy_id ) INNER JOIN royal_terms AS terms USING( term_id ) LEFT JOIN royal_term_relationships ON (royal_posts.ID = royal_term_relationships.object_id) WHERE royal_posts.post_type IN ( ‘product’ ) AND royal_posts.post_status = ‘publish’ AND ( royal_posts.ID NOT IN ( SELECT object_id FROM royal_term_relationships WHERE term_taxonomy_id IN (7) ) AND royal_term_relationships.term_taxonomy_id IN (94) )AND terms.term_id IN () GROUP BY terms.term_id”
Did you make changes in DB?
Was prefix of tables changed?
Is the error there if all 3rd party plugins are disabled?
If “Search by SKU” is enabled in Theme Options > Header > Search, try to disable it.
Let me know results.