SET SQL_BIG_SELECTS=1?

Hello,

We automatically call this from the plugin before performing the filter. Are you encountering a specific error? We may be able to guide you to the resolution if you can paste the error message here for us. Thanks!

Hi,
I’m getting
`WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]

That is when my search returned 24 rows and I’ve edited few values and pressed Save Changes.

• This reply was modified 7 years, 1 month ago by destabilizator.

Can you perform the following steps to help us isolate exactly which query is throwing this error? We set SQL_BIG_SELECTS on the main query, however it’s possible this is happening elsewhere.

1. Log into your FTP site and edit wp-config.php
2. Set the following values to “true” (add the lines if they don’t exist):
define(‘WP_DEBUG’, true);
define(‘WP_DEBUG_LOG’, true);
3. Return to the plugin and perform the steps to trigger the error.
4. Now go back to FTP and download this file: /wp-content/debug.log
5. Return to wp-config.php and set DEBUG back to false (reverting the changes made in Step 2)
6. Review the debug.log file and look for any entries for pw-bulk-edit.php

Let me know if you have any questions!

Well under the error message there’s the query printed, that’s what you are after? (I can get to FTP when I get home)

`SELECT post.ID, regular_price.meta_value AS _regular_price, sale_price.meta_value AS _sale_price, sale_price_dates_from.meta_value AS _sale_price_dates_from, sale_price_dates_to.meta_value AS _sale_price_dates_to FROM wordpress_posts AS post LEFT JOIN wordpress_postmeta AS regular_price ON (regular_price.post_id = post.ID AND regular_price.meta_key = ‘_regular_price’) LEFT JOIN wordpress_postmeta AS sale_price ON (sale_price.post_id = post.ID AND sale_price.meta_key = ‘_sale_price’) LEFT JOIN wordpress_postmeta AS sale_price_dates_from ON (sale_price_dates_from.post_id = post.ID AND sale_price_dates_from.meta_key = ‘_sale_price_dates_from’) LEFT JOIN wordpress_postmeta AS sale_price_dates_to ON (sale_price_dates_to.post_id = post.ID AND sale_price_dates_to.meta_key = ‘_sale_price_dates_to’) WHERE post.ID IN (234)

Thank you for the additional information. We found that this query is during the save, so we are testing the new query with SQL_BIG_SELECTS here. We should have an update within the next 30 minutes, I will let you know when it is available.

We just released v2.43 which adds a call to SQL_BIG_SELECTS prior to performing the save. Let me know if this resolves the issue you’re having.

It seems to work, thanks!

• This reply was modified 7 years, 1 month ago by destabilizator.