Support » Plugin: Awesome Support - WordPress HelpDesk & Support Plugin » WordPress database error Not unique table/alias

  • Resolved George

    (@subscriptiongroup)


    Hello,

    We often get the following notice on our logs:

    WordPress database error Not unique table/alias: 'wp_postmeta' for query SELECT  DISTINCT wp_posts.* FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id  WHERE 1=1  AND (
      ( wp_postmeta.meta_key = '_wpas_status' AND wp_postmeta.meta_value = 'open' )
    ) AND wp_posts.post_type = 'ticket' AND ((wp_posts.post_status = 'queued' OR wp_posts.post_status = 'processing' OR wp_posts.post_status = 'hold')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC  made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), WP_Hook->do_action, WP_Hook->apply_filters, wpas_tickets_count, wpas_get_tickets, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_Wpdb->default_query

    I’m not sure if that’s caused solely by your plugin or maybe an incompatibility with W3TC DB cache, but i believe it’s somehow related to your plugin as the query returns a list of tickets.

    This bug can be fixed by adding an alias on the query and we haven’t noticed any issues so far, so it’s probably a low priority.

    Thanks

    p.s. Even though we’ve got a few licences with you, your site will not allow me to submit a ticket as CloudFlare appears to be blocking my IP, so i’m forced to post here.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author awesomesupport

    (@awesomesupport)

    Hi George:

    Can you use the contact form on our website to give us your ip address so we can white-list it for you> Also please include the email address your product is registered under and we’ll open a ticket with the information in this post for you.

    Thanks very much!

    Plugin Author awesomesupport

    (@awesomesupport)

    We’re handling this via our ticket system so marking this closed.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress database error Not unique table/alias’ is closed to new replies.