Support » Fixing WordPress » 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.

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.