Error occurred while searching for snippets

  • Hi!

    When I searched for snippets on the WPCode panel, I received error log as below.

    AH01071: Got error ＇PHP message: WordPress database error Not unique table/alias: ＇wp_postmeta＇ for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID\n\t\t\t\t\t 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 \n\t\t\t\t\t WHERE 1=1 AND (((wp_posts.post_title LIKE ＇%replace%＇) OR (wp_postmeta.meta_value LIKE ＇%replace%＇) OR (wp_posts.post_excerpt LIKE ＇%replace%＇) OR (wp_posts.post_content LIKE ＇%replace%＇))) AND ( \n wp_postmeta.meta_key = ＇_wpcode_priority＇\n) AND wp_posts.post_type = ＇wpcode＇ AND ((wp_posts.post_status = ＇publish＇ OR wp_posts.post_status = ＇draft＇))\n\t\t\t\t\t GROUP BY wp_posts.ID\n\t\t\t\t\t ORDER BY wp_postmeta.meta_value+0 ASC\n\t\t\t\t\t LIMIT 0, 40 made by do_action(＇toplevel_page_wpcode＇), WP_Hook-＞do_action, WP_Hook-＞apply_filters, WPCode_Admin_Page_Loader-＞admin_menu_page, do_action(＇wpcode_admin_page＇), WP_Hook-＞do_action, WP_Hook-＞apply_filters, WPCode_Admin_Page-＞ou…＇, referer: httpsxxxxwww.xxxxx.com/wp-admin/admin.php?page=wpcode

    I’m using php8.2 and mysql8.0

    Thanks!

Viewing 1 replies (of 1 total)
  • Plugin Author Mircea Sandu

    (@gripgrip)

    Hi @stanleychan,

    Thank you for reporting this – we have not encountered this on our end, and we can’t reproduce it at this time. From the details of the error it seems like the modified query we are making in order to provide better results there is interfering with another plugin that is also making a change to the query.

    Is it possible to try searching in WPCode with no other plugins active to confirm? If you have a staging site, that would be very helpful.

    We’ll try to update our custom query to prevent such conflicts in the future but if you can identify which plugin is causing this it would be very helpful in order to make sure our fix addresses the issue correctly.

Viewing 1 replies (of 1 total)
  • The topic ‘Error occurred while searching for snippets’ is closed to new replies.