WordPress.org
Get WordPress

Make WordPress Core

Changes between Version 1 and Version 2 of Ticket #24093, comment 23


Ignore:
Timestamp:
09/22/2014 10:50:03 AM (10 years ago)
Author:
sarukuku
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #24093, comment 23

    v1 v2  
    11It would be good to get this finally in. I happened to stuble on this when I was looking for an answer to a problem I have with a dynamically generated meta_query. When the amount of the meta_query arrays exceeds nine my local development server and my staging server both just freeze. The DB query seems to run indefinitely and I need to restart the MySQL server to get the site operational again.
    22
    3 EDIT: I can confirm that vprat's latest patch fixes the issue on my development and test server.
     3EDIT 1: I can confirm that vprat's latest patch fixes the issue on my development and test server.
     4
     5EDIT 2: The patch doesn't seem to break anything but cases WP to show errors on the admin side, example below.
     6
     7{{{
     8WordPress database error: [Unknown column 'mt1.meta_key' in 'where clause']
     9SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta AS mt0 ON (wp_posts.ID = mt0.post_id AND mt0.meta_key = '_searchwp_last_index') WHERE 1=1 AND wp_posts.post_type IN ('post', 'page', 'attachment', 'person', 'product', 'service_provider', 'q_and_a') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) AND ( mt0.post_id IS NULL AND mt1.meta_key = '_searchwp_skip' ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
     10}}}