SearchWP

This Documentation is for SearchWP Version 3

Available since: 1.6.3

searchwp_big_selects

MySQL (the database engine that powers WordPress sites) comes with many configurable options. One of those options is an upper limit to the number of SELECT statements that can be performed in a single query. This limit is in place for performance considerations. Depending on your (or your host’s) MySQL configuration, you may have seen this Admin Bar warning when first trying SearchWP:

searchwp-admin-bar-error

Don’t worry, we can easily get around this issue using this hook.

Example: To prevent MySQL from killing queries due to a SQL_BIG_SELECT limitation, add the following to your active theme’s functions.php:

<?php
add_filter( 'searchwp_big_selects', '__return_true' );
view raw gistfile1.php hosted with ❤ by GitHub
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]
[wpforms id="3080"]