• Resolved sunny13

    (@sunny13)


    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,
    sunny

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • I Got same error in site dijewellery.ru

    Please help us!!!

    dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hi there @sunny13

    Looking at your site, it seems you got this fixed?

    @izumrudnij were you able to get this resolved?

    I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thanks,

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Error “Not unique table/alias: price_query”’ is closed to new replies.