• Resolved damtii

    (@damtii)


    Hi,
    after activating your plugin I am getting this database error:

    WordPress database error: [Not unique table/alias: ‘wp_posts’]
    SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments LEFT JOIN wp_posts ON comment_post_ID = wp_posts.ID INNER JOIN wp_posts ON wp_comments.comment_post_ID=wp_posts.ID WHERE ( comment_approved = ‘1’ ) AND comment_post_ID = 34 AND wp_posts.post_type NOT IN (‘shop_order’,’shop_order_refund’) AND wp_posts.post_type <> ‘shop_webhook’ AND post_type NOT IN ( ‘support_ticket’ ) ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC

    how can I fix it?

    thanks.

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

    (@smartcat)

    Hi @damtii

    Thanks for sharing this. We’re working on a patch right now that will address this issue, then will do a plugin update for it. https://github.com/smartcatdev/support-system/issues/182

    I’ll keep you updated once the update is released.

    Best regards

    Plugin Author smartcat

    (@smartcat)

    Hi again @damtii

    We released a new version 1.1.2 which includes a fix for the issue you reported. Thank you for taking the time to report the bug, please update your plugin and test again, and let me know if you’re still having any issues.

    Best regards

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database Issue’ is closed to new replies.