Changeset 3389253

Timestamp:

11/04/2025 12:02:19 AM (5 months ago)

Author:

1fixdotio

Message:

Release 0.9.1 to fix a SQL bug

Location:

media-search-enhanced

Files:

• tags/0.9.1 (copied) (copied from media-search-enhanced/trunk)
• tags/0.9.1/README.txt (modified) (2 diffs)
• tags/0.9.1/languages/media-search-enhanced-es_ES.mo (added)
• tags/0.9.1/languages/media-search-enhanced-es_ES.po (added)
• tags/0.9.1/languages/media-search-enhanced-pt_BR.mo (added)
• tags/0.9.1/languages/media-search-enhanced-pt_BR.po (added)
• tags/0.9.1/media-search-enhanced.php (modified) (1 diff)
• tags/0.9.1/public/class-media-search-enhanced.php (modified) (3 diffs)
• trunk/README.txt (modified) (2 diffs)
• trunk/languages/media-search-enhanced-es_ES.mo (added)
• trunk/languages/media-search-enhanced-es_ES.po (added)
• trunk/languages/media-search-enhanced-pt_BR.mo (added)
• trunk/languages/media-search-enhanced-pt_BR.po (added)
• trunk/media-search-enhanced.php (modified) (1 diff)
• trunk/public/class-media-search-enhanced.php (modified) (3 diffs)

media-search-enhanced/tags/0.9.1/README.txt

@@ -6 +6 @@
 Requires at least: 3.5
 Tested up to: 6.4.3
-Stable tag: 0.9.0
+Stable tag: 0.9.1
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -66 +66 @@
 == Changelog ==
 
+= 0.9.1 =
+* Fix: Prevent "Not unique table/alias: wp_postmeta" SQL error by aliasing the postmeta JOIN. Props [@mikemeinz](https://wordpress.org/support/users/mikemeinz/). See https://wordpress.org/support/topic/sql-syntax-error-26/
+
 = 0.9.0 =
 * Added the languages pt_BR and es_ES. Thanks to [@larodiel](https://github.com/1fixdotio/media-search-enhanced/pull/4).

media-search-enhanced/tags/0.9.1/media-search-enhanced.php

@@ -15 +15 @@
  * Plugin URI:        https://1fix.io/media-search-enhanced
  * Description:       Search through all fields in Media Library.
- * Version:           0.9.0
+ * Version:           0.9.1
  * Author:            1fixdotio
  * Author URI:        https://1fix.io

media-search-enhanced/tags/0.9.1/public/class-media-search-enhanced.php

@@ -29 +29 @@
      * @var     string
      */
-    const VERSION = '0.8.0';
+    const VERSION = '0.9.1';
 
     /**
@@ -190 +190 @@
             $like = '%' . $wpdb->esc_like( $vars['s'] ) . '%';
             $pieces['where'] .= $wpdb->prepare( " AND ( ($wpdb->posts.ID LIKE %s) OR ($wpdb->posts.post_title LIKE %s) OR ($wpdb->posts.guid LIKE %s) OR ($wpdb->posts.post_content LIKE %s) OR ($wpdb->posts.post_excerpt LIKE %s)", $like, $like, $like, $like, $like );
-            $pieces['where'] .= $wpdb->prepare( " OR ($wpdb->postmeta.meta_key = '_wp_attachment_image_alt' AND $wpdb->postmeta.meta_value LIKE %s)", $like );
-            $pieces['where'] .= $wpdb->prepare( " OR ($wpdb->postmeta.meta_key = '_wp_attached_file' AND $wpdb->postmeta.meta_value LIKE %s)", $like );
-
-            // Get taxes for attachements
+            $pieces['where'] .= $wpdb->prepare( " OR (mse_pm.meta_key = '_wp_attachment_image_alt' AND mse_pm.meta_value LIKE %s)", $like );
+            $pieces['where'] .= $wpdb->prepare( " OR (mse_pm.meta_key = '_wp_attached_file' AND mse_pm.meta_value LIKE %s)", $like );
+
+            // Get taxes for attachments
             $taxes = get_object_taxonomies( 'attachment' );
             if ( ! empty( $taxes ) ) {
@@ -201 +201 @@
             $pieces['where'] .= " )";
 
-            $pieces['join'] .= " LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id";
-
-            // Get taxes for attachements
+            $pieces['join'] .= " LEFT JOIN $wpdb->postmeta AS mse_pm ON $wpdb->posts.ID = mse_pm.post_id";
+
+            // Get taxes for attachments
             $taxes = get_object_taxonomies( 'attachment' );
             if ( ! empty( $taxes ) ) {

media-search-enhanced/trunk/README.txt

@@ -6 +6 @@
 Requires at least: 3.5
 Tested up to: 6.4.3
-Stable tag: 0.9.0
+Stable tag: 0.9.1
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -66 +66 @@
 == Changelog ==
 
+= 0.9.1 =
+* Fix: Prevent "Not unique table/alias: wp_postmeta" SQL error by aliasing the postmeta JOIN. Props [@mikemeinz](https://wordpress.org/support/users/mikemeinz/). See https://wordpress.org/support/topic/sql-syntax-error-26/
+
 = 0.9.0 =
 * Added the languages pt_BR and es_ES. Thanks to [@larodiel](https://github.com/1fixdotio/media-search-enhanced/pull/4).

media-search-enhanced/trunk/media-search-enhanced.php

@@ -15 +15 @@
  * Plugin URI:        https://1fix.io/media-search-enhanced
  * Description:       Search through all fields in Media Library.
- * Version:           0.9.0
+ * Version:           0.9.1
  * Author:            1fixdotio
  * Author URI:        https://1fix.io

media-search-enhanced/trunk/public/class-media-search-enhanced.php

@@ -29 +29 @@
      * @var     string
      */
-    const VERSION = '0.8.0';
+    const VERSION = '0.9.1';
 
     /**
@@ -190 +190 @@
             $like = '%' . $wpdb->esc_like( $vars['s'] ) . '%';
             $pieces['where'] .= $wpdb->prepare( " AND ( ($wpdb->posts.ID LIKE %s) OR ($wpdb->posts.post_title LIKE %s) OR ($wpdb->posts.guid LIKE %s) OR ($wpdb->posts.post_content LIKE %s) OR ($wpdb->posts.post_excerpt LIKE %s)", $like, $like, $like, $like, $like );
-            $pieces['where'] .= $wpdb->prepare( " OR ($wpdb->postmeta.meta_key = '_wp_attachment_image_alt' AND $wpdb->postmeta.meta_value LIKE %s)", $like );
-            $pieces['where'] .= $wpdb->prepare( " OR ($wpdb->postmeta.meta_key = '_wp_attached_file' AND $wpdb->postmeta.meta_value LIKE %s)", $like );
-
-            // Get taxes for attachements
+            $pieces['where'] .= $wpdb->prepare( " OR (mse_pm.meta_key = '_wp_attachment_image_alt' AND mse_pm.meta_value LIKE %s)", $like );
+            $pieces['where'] .= $wpdb->prepare( " OR (mse_pm.meta_key = '_wp_attached_file' AND mse_pm.meta_value LIKE %s)", $like );
+
+            // Get taxes for attachments
             $taxes = get_object_taxonomies( 'attachment' );
             if ( ! empty( $taxes ) ) {
@@ -201 +201 @@
             $pieces['where'] .= " )";
 
-            $pieces['join'] .= " LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id";
-
-            // Get taxes for attachements
+            $pieces['join'] .= " LEFT JOIN $wpdb->postmeta AS mse_pm ON $wpdb->posts.ID = mse_pm.post_id";
+
+            // Get taxes for attachments
             $taxes = get_object_taxonomies( 'attachment' );
             if ( ! empty( $taxes ) ) {