[Search Everything & Bad Behavior] WP database error searching in Manage Posts

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

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.)

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

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.

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.

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

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.)

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.

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

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.

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.