WordPress.org

Ready to get started?Download WordPress

Forums

[Search Everything & Bad Behavior] WP database error searching in Manage Posts (12 posts)

  1. sairuh
    Member
    Posted 5 years ago #

    Hello,

    I noticed recently that when I try to search through posts in the Manage Posts web admin page, I get a database error, and the search fails to yield results even though posts exist containing that string. I tested my plugins, and it seems that I need both the Search Everything (v4.6.2) and Bad Behavior (v2.0.16) plugins turned on in order to exhibit the bug.

    I'm running WordPress 2.5.1 --is there a workaround for this?

    Steps
    -----
    1. Make sure you have the Search Everything (v4.6.2) and Bad Behavior (v2.0.16) plugins installed and activated.

    2. Go to Manage > Posts, and in the Search Posts textfield, enter a string which exists in at least one post. For example, the word "test"

    3. Hit the Search Posts button or the enter key. Rather than displaying the matching posts, I get the following database error:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts' at line 1]
    SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships AS trel ON (wp_posts.ID = trel.object_id) LEFT JOIN wp_term_taxonomy AS ttax ON ( ( ttax.taxonomy = 'category' OR ttax.taxonomy = 'post_tag' ) AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN wp_terms AS tter ON (ttax.term_id = tter.term_id) LEFT JOIN wp_comments AS c ON ( comment_post_ID = ID ) WHERE 1=1 AND (((wp_posts.post_title LIKE '%test%') OR (wp_posts.post_content LIKE '%test%') OR (wp_posts.post_excerpt LIKE '%test%'))) AND wp_posts.(wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') OR ( tter.name LIKE '%test%') OR ( tter.slug LIKE '%test%') OR ( c.comment_post_ID = wp_posts.ID AND c.comment_content LIKE '%test%') ORDER BY wp_posts.post_date DESC LIMIT 0, 15

    http://wordpress.org/extend/plugins/search-everything/
    http://wordpress.org/extend/plugins/bad-behavior/

  2. error
    Member
    Posted 5 years ago #

    Looks like a problem with the Search Everything plugin. Bad Behavior doesn't touch any of those tables/rows.

  3. sairuh
    Member
    Posted 5 years ago #

    Fwiw, this still occurs with Search Everything v4.7. (I'm still using WP 2.5.1, so it'll be interesting to see if this error stops upon upgrading to 2.6.)

  4. sairuh
    Member
    Posted 5 years ago #

    Hm, no. This is still a problem with WP 2.6 and Search Everything 4.7.1.

  5. error
    Member
    Posted 5 years ago #

    After taking a second look at that message, the error in the SQL query is quite obvious. You should report this to the author of the Search Everything plugin.

  6. sairuh
    Member
    Posted 5 years ago #

    The support forum at Scatter3d.com (the site for Search Everything's developer) now encourage posting support questions here, so I had thought they'd be able to track it here. But it looks like I forgot to add the appropriate tags...

    P.S. Search Everything v4.7.5 still exhibits this bug. Moreover, it now also displays a WP db error when I just do a search in my blog (no longer limited to the Manage Posts admin page). For example, a search for apple yields the following:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND post_type != 'revision' ORDER BY wp_posts.post_date DESC LIMIT 0, 10' at line 1]
    SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships AS trel ON (wp_posts.ID = trel.object_id) LEFT JOIN wp_term_taxonomy AS ttax ON ( ( ttax.taxonomy = 'category' OR ttax.taxonomy = 'post_tag' ) AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN wp_terms AS tter ON (ttax.term_id = tter.term_id) LEFT JOIN wp_comments AS c ON ( comment_post_ID = ID ) WHERE 1=1 AND ( (((wp_posts.post_title LIKE '%apple%') OR (wp_posts.post_content LIKE '%apple%'))) AND (wp_posts.post_status = 'publish') OR ( tter.name LIKE '%apple%') OR ( tter.slug LIKE '%apple%') AND post_status='publish') OR ( c.comment_post_ID = wp_posts.ID AND c.comment_content LIKE '%apple%') ) AND post_type != 'revision' ORDER BY wp_posts.post_date DESC LIMIT 0, 10

    I have to disable the plugin, because searches don't work at all. Tested with WP 2.6.2.

  7. Vladimir Kolesnikov
    Member
    Posted 5 years ago #

    sariuh, I have found a quick fix, if you are interested.

    Please open the file search_everything/search_everything.php and scroll down to the function SE4_no_revisions() (line 108 or so).

    Replace it with the following code:

    function SE4_no_revisions($where) {
              global $wp_query;
              if (!empty($wp_query->query_vars['s'])) {
                  if ("true" != $this->options['SE4_use_category_search']) {
                      $where = 'AND (' . substr($where, strpos($where, 'AND')+3) . ') AND post_type != \'revision\'';
                  }
                  else {
                      $where = 'AND (' . substr($where, strpos($where, 'AND')+3) . ' AND post_type != \'revision\'';
                  }
              }
              return $where;
            }

    Hope that helps.

    Best regards,
    Vladimir

  8. sairuh
    Member
    Posted 5 years ago #

    Hello Vladimir,

    Thanks for the fix. It does take care of the issue of the database error displaying on blog pages. However, the original problem of being unable to search Manage Posts still remains.

    In addition, another issue I believe I saw with v4.7.1 is that Search Everything seems to include every revision of a post in the search results! There doesn't seem to be a setting to control this. Although this seems more like a bug, since I don't think you want to have readers view multiple individual revisions of a given post --only the final/published version. (This is another reason I've disabled Search Everything on my public sites.)

  9. i3inary
    Member
    Posted 5 years ago #

    im using 4.7.5 and got errors if i enabled Search every category name or Search every custom field (metadata).

    the problem is related to a missing open parenthesis in 2 of the functions:
    SE4_search_metadata
    SE4_search_categories.

    to fix this open plugins/search-everything/search_everything.php and search for the text:
    post_status='publish') ";
    change it to:
    (post_status='publish') ";

    fyi: for version 4.7.5 i had to do this on 3 lines 239, 241, and 268.

  10. Dan Cameron
    Member
    Posted 5 years ago #

    Please download the latest version 2.7.6. I'll be releasing another getting this fix in place, I wish I saw it earlier after spending some time figuring it out.

    Thanks I3inary

  11. sairuh
    Member
    Posted 5 years ago #

    Hello Dan,

    Thanks for releasing 2.7.6.2 --it does indeed take care of the bugs with errors in blog pages and displaying revisions of posts in results (neither occur now in my local environment).

    Let me know if you need help testing in order to fix/narrow down the original problem of not being able to search Manage Posts.

  12. zota
    Member
    Posted 5 years ago #

    I'm using Search Everything 4.7.6.2 and I get a MySQL error on my search results in my sidebar, where the list recent posts widget should be. I do not get the error when I remove the recent posts widget.

Topic Closed

This topic has been closed to new replies.

About this Topic