• I get this error message and have no idea if this is caused by Avada or from WordPress.
    Anyone an idea how to solve this?

    [17-Feb-2016 18:01:36 UTC] WordPress database error Not unique table/alias: ‘t’ for query SELECT wp_comments.* FROM wp_comments JOIN wp_posts ON (wp_comments.comment_post_ID = wp_posts.ID) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) JOIN wp_icl_translations t
    ON wp_posts.ID = t.element_id
    AND t.element_type = CONCAT(‘post_’, wp_posts.post_type) JOIN wp_icl_translations t
    ON wp_comments.comment_post_ID = t.element_id
    AND t.element_type = ‘post_product’ AND t.language_code = ‘en’ WHERE comment_approved = ‘1’ AND (
    0 = 1
    ) AND (
    wp_postmeta.meta_key = ‘total_sales’
    AND
    (
    ( mt1.meta_key = ‘_visibility’ AND CAST(mt1.meta_value AS CHAR) IN (‘visible’,’catalog’) )
    )
    ) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’) AND ( ( t.language_code = ‘en’ AND wp_posts.post_type IN (‘post’,’page’,’attachment’,’product’,’product_variation’,’slide’,’avada_portfolio’,’avada_faq’,’themefusion_elastic’ ) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’attachment’,’product’,’product_variation’,’slide’,’avada_portfolio’,’avada_faq’,’themefusion_elastic’ ) ) AND wp_posts.post_type NOT IN (‘shop_order’,’shop_order_refund’) AND wp_posts.post_type <> ‘shop_webhook’ GROUP BY wp_comments.comment_id ORDER BY comment_date_gmt DESC LIMIT 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

  • The topic ‘WordPress database error Not unique’ is closed to new replies.