WordPress database error Unknown column ‘tt1.term_taxonomy_id’
-
We are experiencing the following error repeatedly:
[Sat Sep 12 00:18:12.285603 2020] [proxy_fcgi:error] [pid 22180] [client 54.36.148.131:35394] AH01071: Got error ‘PHP message: WordPress database error Unknown column ‘tt1.term_taxonomy_id’ in ‘where clause’ for query \n\t\t\t\tSELECT COUNT(DISTINCT(product_id)) AS term_count, term_count_id FROM (\n\t\t\t\t\tSELECT IF(wpyq_posts.post_type=’product_variation’, wpyq_posts.post_parent, wpyq_posts.ID) AS product_id, terms.term_id AS term_count_id FROM wpyq_posts \n\t\t\tINNER JOIN wpyq_term_relationships AS tr ON wpyq_posts.ID = tr.object_id\n\t\t\tINNER JOIN wpyq_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )\n\t\t\tINNER JOIN wpyq_terms AS terms USING( term_id )\n\t\t\t LEFT JOIN wpyq_term_relationships ON (wpyq_posts.ID = wpyq_term_relationships.object_id) LEFT JOIN wpyq_term_relationships AS tt1 ON (wpyq_posts.ID = tt1.object_id) \n\t\t\tWHERE\n\t\t\twpyq_posts.post_status = ‘publish’\n\t\t\t AND ( \n wpyq_posts.ID NOT IN (\n\t\t\t\tSELECT object_id\n\t\t\t\tFROM wpyq_term_relationships\n\t\t\t\tWHERE term_taxonomy_id IN (7,9)\n\t\t\t) \n AND \n wpyq_term_relationships.term_taxonomy_id IN (4361) \n AND \n tt1.term_taxonomy_id IN (4361)\n) \n\t\t\tAND (\n\t\t\t\t(\n…PHP message: WordPress database error Unknown column ‘tt1.term_taxonomy_id’ in ‘where clause’ for query \n\t\t\t\tSELECT COUNT(DISTINCT(product_id)) AS term_count, term_count_id FROM (\n\t\t\t\t\tSELECT IF(wpyq_posts.post_type=’product_variation’, wpyq_posts.post_parent, wpyq_posts.ID) AS product_id, terms.term_id AS term_count_id FROM wpyq_posts \n\t\t\tINNER JOIN wpyq_term_relationships AS tr ON wpyq_posts.ID = tr.object_id\n\t\t\tINNER JOIN wpyq_term_taxonomy AS term_taxonomy USING( term_taxonomy_id )\n\t\t\tINNER JOIN wpyq_terms AS terms USING( term_id )\n\t\t\t LEFT JOIN wpyq_term_relationships ON (wpyq_posts.ID = wpyq_term_relationships.object_id) LEFT JOIN wpyq_term_relationships AS tt1 ON (wpyq_posts.ID = tt1.object_id) \n\t\t\tWHERE\n\t\t\twpyq_posts.post_status = ‘publish’\n\t\t\t AND ( \n wpyq_posts.ID NOT IN (\n\t\t\t\tSELECT object_id\n\t\t\t\tFROM wpyq_term_relationships\n\t\t\t\tWHERE term_taxonomy_id IN (7,9)\n\t\t\t) \n AND \n wpyq_term_relationships.term_taxonomy_id IN (4361) \n AND \n tt1.term_taxonomy_id IN (4361)\n) \n\t\t\tAND (\n\t\t\t\t(\n…’
All plugins and WordPress are up to date, but can’t get our head around these errors.
Please help.
The topic ‘WordPress database error Unknown column ‘tt1.term_taxonomy_id’’ is closed to new replies.