Support » Plugin: Search Everything » Database Error when Filtering Posts

  • Filtering posts from the admin screen results in a database error. The code generates a bad SQL query. The source of the issue is line 278 in search-everything.php.

    The fix is changing this:

    if ( $searchQuery != '' ) {

    to this

    if ( $searchQuery != '' && $searchQuery != '()' ) {

    [Moderator note: code fixed. Please wrap code in the backtick character or use the code button.]

    An alternate solution might be to check for something in $terms before adding the hardcoded parenthesis.

    • This topic was modified 2 years, 1 month ago by bdbrown.
Viewing 4 replies - 1 through 4 (of 4 total)
  • rlozano87

    (@rlozano87)

    Thank you! Your post saved me a lot of time!

    I ran into this issue as well. This fixed an issue that I was having on the front end when a search query was submitted blank in addition to the error on post filter in the admin. Thanks for the fix. It seems like this is something that should easily be fixed by the admin in an update…

    Vladimir

    (@vladimir-slonska)

    Hello,

    Same problem, and same solution. It works.

    Will this plugin will be updated in the future ?

    Thanks,

    EDIT : it will not be updated… https://wordpress.org/support/topic/search-everything-support-update/

    • This reply was modified 1 year, 7 months ago by Vladimir.
    Vladimir

    (@vladimir-slonska)

    I also add that this error also accurs when you try to access to the exports requests of personnal data (/wp-admin/tools.php?page=export_personal_data).

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Error when Filtering Posts’ is closed to new replies.