disable search everything for admin area

Hello @timholz,

Thank you for your inquiry and we apologize for any inconvenience this may be causing. We are actively investigating the issue and working on a solution.

Thank you for your patience in resolving this issue.

Regards,

Sovrn Support

@timholz,

Sorry for the confusion. This is currently not part of the functionality that search everything provides nor is there a toggle to disable it in the admin portion.

If you upgrade to the latest version of the plugin and still experience the issue could you please provide the WordPress version you’re on, the PHP version you’re running and the error you’re seeing and we’d be happy to take a look.

Regards,
Sovrn Support

Hi
Thanks for your message.
Here are the infos you asked for:
Wordpress:4.7.3
PHP:5.6.30
Error: `WordPress-database-error: [Column ‘post_type’ in where clause is ambiguous]
SELECT DISTINCT SQL_CALC_FOUND_ROWS goe_posts.* FROM goe_posts LEFT JOIN goe_term_relationships ON (goe_posts.ID = goe_term_relationships.object_id) LEFT JOIN goe_posts AS p2 ON (goe_posts.post_parent = p2.ID) LEFT JOIN goe_term_relationships AS trel ON (goe_posts.ID = trel.object_id) LEFT JOIN goe_term_taxonomy AS ttax ON ( ( ttax.taxonomy = ‘category’ OR ttax.taxonomy = ‘post_tag’ OR ttax.taxonomy = ‘post_format’ OR ttax.taxonomy = ‘product_type’ OR ttax.taxonomy = ‘product_cat’ OR ttax.taxonomy = ‘product_tag’ OR ttax.taxonomy = ‘product_shipping_class’ OR ttax.taxonomy = ‘media_category’ ) AND trel.term_taxonomy_id = ttax.term_taxonomy_id) LEFT JOIN goe_terms AS tter ON (ttax.term_id = tter.term_id) LEFT JOIN goe_postmeta AS m ON (goe_posts.ID = m.post_id) LEFT JOIN goe_postmeta AS sq1 ON ( goe_posts.ID = sq1.post_id AND sq1.meta_key = ‘_wp_attached_file’ ) WHERE 1=1 AND ( ( ( goe_term_relationships.term_taxonomy_id IN (299) ) AND (((((goe_posts.post_title LIKE ‘%9783934029477%’) OR (goe_posts.post_content LIKE ‘%9783934029477%’) OR ( sq1.meta_value LIKE ‘%9783934029477%’ ))) OR ((tter.name LIKE ‘%9783934029477%’)) OR ((tter.slug LIKE ‘%9783934029477%’)) OR ((ttax.description LIKE ‘%9783934029477%’)) OR ((m.meta_value LIKE ‘%9783934029477%’)) )) AND goe_posts.post_type = ‘attachment’ AND (((goe_posts.post_status = ‘inherit’ OR goe_posts.post_status = ‘private’) OR (goe_posts.post_status = ‘inherit’ AND (p2.post_status = ‘inherit’ OR p2.post_status = ‘private’))))) AND post_type != ‘revision’) AND post_status != ‘future’ GROUP BY goe_posts.ID ORDER BY goe_posts.post_date DESC LIMIT 0, 20`

This error occurs when searching an image within a image-category.
If no image category is selected everything works well. No error is displayed.
Thanks for your interest.
regards
theo

another error occurs when choosing an image-category:

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 goe_posts.post_type = 'attachment' AND (((goe_posts.post_status = 'inhe' at line 3]
SELECT SQL_CALC_FOUND_ROWS goe_posts.ID FROM goe_posts LEFT JOIN goe_term_relationships ON (goe_posts.ID = goe_term_relationships.object_id) LEFT JOIN goe_posts AS p2 ON (goe_posts.post_parent = p2.ID) LEFT JOIN goe_postmeta AS sq1 ON ( goe_posts.ID = sq1.post_id AND sq1.meta_key = '_wp_attached_file' ) WHERE 1=1 AND ( goe_term_relationships.term_taxonomy_id IN (208) ) AND ((())) AND goe_posts.post_type = 'attachment' AND (((goe_posts.post_status = 'inherit' OR goe_posts.post_status = 'private') OR (goe_posts.post_status = 'inherit' AND (p2.post_status = 'inherit' OR p2.post_status = 'private')))) GROUP BY goe_posts.ID ORDER BY goe_posts.post_date DESC LIMIT 0, 20

When i disable the latest search everything version (8.1.9) no error occurs.
With active version 8.1.6 no error occurs.
Thanks for your interest.
theo

• This reply was modified 7 years, 7 months ago by timholz.
• This reply was modified 7 years, 7 months ago by timholz.

I know this is not correctly, but i hope to help investigating.

• Edit /wp-content/plugins/search-everything.php
• Search for
  $this->se_log( "global where: ".$where );
• Replace for

  $this->se_log( "global where: ".$where );
  $where = preg_replace( "/\(\)/", '(1=1)', $where );

Hi Marcos
Thanks for the work-around. I’ll try it and will post the result.
regards
theo

Thanks @neookano – this fixed also Woocommerce category filtering issue!