{"id":18659008,"date":"2025-09-27T14:33:15","date_gmt":"2025-09-27T14:33:15","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-syntax-error-26\/"},"modified":"2025-09-27T14:34:01","modified_gmt":"2025-09-27T14:34:01","slug":"sql-syntax-error-26","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-syntax-error-26\/","title":{"rendered":"SQL Syntax Error"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The following error is logged in the wp-admin PHP error_log whenever a search is done in the Media Library.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>[27-Sep-2025 14:05:31 UTC] WordPress database error Not unique table\/alias: 'wp_postmeta' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID<br \/>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 LEFT JOIN wp_term_relationships AS trel ON (wp_posts.ID = trel.object_id) LEFT JOIN wp_term_taxonomy AS ttax ON (( ttax.taxonomy = 'ml-slider' ) AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN wp_terms AS tter ON (ttax.term_id = tter.term_id)<br \/>WHERE 1=1 AND wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'inherit' OR wp_posts.post_status = 'private') AND ( (wp_posts.ID LIKE '%Brochure%') OR (wp_posts.post_title LIKE '%Brochure%') OR (wp_posts.guid LIKE '%Brochure%') OR (wp_posts.post_content LIKE '%Brochure%') OR (wp_posts.post_excerpt LIKE '%Brochure%') OR (wp_postmeta.meta_key = '_wp_attachment_image_alt' AND wp_postmeta.meta_value LIKE '%Brochure%') OR (wp_postmeta.meta_key = '_wp_attached_file' AND wp_postmeta.meta_value LIKE '%Brochure%') OR (tter.slug LIKE '%Brochure%') OR (ttax.description LIKE '%Brochure%') OR (tter.name LIKE '%Brochure%') )<br \/>GROUP BY wp_posts.ID<br \/>ORDER BY wp_posts.post_date DESC<br \/>LIMIT 0, 100 made by require_once('wp-admin\/admin-header.php'), do_action('admin_enqueue_scripts'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, PublishPress\\Future\\Modules\\Workflows\\Controllers\\FutureLegacyAction-&gt;enqueueScriptsLegacyAction, PublishPress\\Future\\Modules\\Workflows\\Models\\WorkflowsModel-&gt;getPublishedWorkflowsWithLegacyTriggerAsOptions, PublishPress\\Future\\Modules\\Workflows\\Models\\WorkflowsModel-&gt;getPublishedWorkflowsWithMetadataAsOptions, WP_Query-&gt;__construct, WP_Query-&gt;query, WP_Query-&gt;get_posts<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It appears that line 203 in class-media-search-enhanced.php doesn&#8217;t use an alias for the wp_postmeta table. Using an alias in line 203 and the other places where wp_postmeta is used would resolve this issue. Thanks!<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>        $pieces&#091;'join'] .= \" LEFT JOIN $wpdb-&gt;postmeta ON $wpdb-&gt;posts.ID = $wpdb-&gt;postmeta.post_id\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Media Search Enhanced Version 0.9.0&nbsp;<br \/>WordPress Version 6.8.2<\/p>\n","protected":false},"template":"","class_list":["post-18659008","topic","type-topic","status-publish","hentry","topic-tag-sql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18659008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18659008\/revisions"}],"predecessor-version":[{"id":18659009,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18659008\/revisions\/18659009"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18659008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}