Database Error “Not unique table/alias: price_query”
-
Hello there,
first of all – thanks for your the great woocommerce plugin.
Unfortunately something weird happened. We migrated our Woocommerce from 2.6.2 to the latest version (3.2.1) as well as our WordPress (4.8.2) version. The result is documented below:
WordPress-Database-Error Not unique table/alias: ‘price_query’ für Abfrage SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN ( SELECT post_id, min( meta_valu+0 ) price FROM wp_postmeta WHERE meta_key=’_price’ GROUP BY post_id ) as price_query ON wp_posts.ID = price_query.post_id INNER JOIN ( SELECT post_id, min( meta_value+0 ) price FROM wp_postmeta WHERE meta_key=’_price’ GROUP BY post_id ) as price_query ON wp_posts.ID = price_query.post_id WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (17746)
)
AND
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (17746)
)
) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) GROUP BY wp_posts.ID ORDER BY price_query.price ASC LIMIT 0, 12 von require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts————-
Due to this error, no products are rendered in categories and shop overview. We assume that there is some kind of problem with the new version of woocommerce?. Could you please provide some help?Kind Regards,
sunnyThe page I need help with: [log in to see the link]
- The topic ‘Database Error “Not unique table/alias: price_query”’ is closed to new replies.