• When enabling the setting “Enable seamless integration”, and calling Better_Search_Query($args) in my custom code identically to the code inside better-search/templates/template.php, I get several of the following error:

    WordPress-Datenbank-Fehler: [Not unique table/alias: ‘bsq_meta’]
    SELECT DISTINCT (MATCH(wp_posts.post_title) AGAINST ('mitglied' ) * 10 ) + (MATCH(wp_posts.post_content) AGAINST ('mitglied' ) * 1 ) as score FROM wp_posts LEFT JOIN wp_postmeta AS bsq_meta ON (wp_posts.ID = bsq_meta.post_id) LEFT JOIN wp_postmeta AS bsq_meta ON (wp_posts.ID = bsq_meta.post_id) LEFT JOIN wp_postmeta AS bsq_meta ON (wp_posts.ID = bsq_meta.post_id) WHERE 1=1 AND ( wp_posts.post_date <= '2023-05-12 16:42:03' ) AND ((MATCH(wp_posts.post_title) AGAINST ('mitglied' ) * 10 ) + (MATCH(wp_posts.post_content) AGAINST ('mitglied' ) * 1 ) OR ( ((wp_posts.post_excerpt LIKE '%mitglied%') OR (bsq_meta.meta_value LIKE '%mitglied%')) ) ) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) ORDER BY score DESC LIMIT 0,1

  • The topic ‘Database Error “Not unique table/alias”’ is closed to new replies.