Search Not Working (please help!)

Anonymous

#8763

Hi, I just installed the plugin today (and have a CSS support post also), but now that I have my search form complete, I am not getting any results.

I have a list of included categories in the INCLUDE area of the settings, and a list of tags in there as well. I have both checkboxes set for “sync with settings” set.

The URL of my search page is: http://www.biia.com/biia-expanded-search

A combination that should show a result (on a post from today) is:
Company (Category): FICO (Fair Isaac)
Initiative (Tag): Partnerships
Date Range: Anything that includes today as it was posted a few hours ago.

The URL that the search form creates is:
http://www.biia.com/biia-expanded-search?_sft_category=fico&_sft_post_tag=partnerships&post_date=01012014+31122014

It is showing no results, but the correctly categorized and tagged post is here:
http://www.biia.com/fico-in-partnership-with-ctos-data-systems-sdn-bhd

As you will see, a regular TAG search for Partnerships shows this post:
http://www.biia.com/tag/partnerships

Please let me know if I am doing something wrong.

Thanks!

Anonymous

#8774

Ross,

I’ve been looking through your other help tickets looking for a solution. I noticed you’ve emailed a few people an update with an INCLUDE/EXCLUDE browser option. Is this just to make it easier to pick what you want, or does it fix a bug in the functionality of that feature?

I ask because I am using INCLUDE for both Category and Tag searches – and with Tags I only include 5, but with Categories I include a few hundred. In order to generate the list, I actually wrote a PHP script to query the WordPress database, as I needed to include all children of a specific category (Company) while excluding all other categories in the site.

I’m hoping to not have to manually check hundreds of checkboxes to make this work.

I hope to have this fixed today or tomorrow, as my client is anxious. (Aren’t they all?)

Ross Moderator

#8789

Hey Charles, just emailed you an updated version – let me know if this works for you 🙂

Anonymous

#8791

This reply has been marked as private.

Anonymous

#8818

Ross,

I just noticed that since the dev update, the “bookmarkable results” are not changing the URL. I realize this probably makes it harder to troubleshoot too. Please advise.

Anonymous

#8893

Ross,

In thinking about this, I want to add that this domain uses CloudFlare.com for their DNS. It provides CDN, Malware blocking, Caching, etc. I’ve turned caching off for testing, so that’s not an issue, however the reason I am pointing this out is that it may create a licencing issue if your licensing server blocks requests from CloudFlare instead of from the true domain. Just figured I’d put that in there in case it would cause these results.

Thanks.

Anonymous

#8899

Ross,

I’m getting really discouraged that you are not responsive to these support requests. I created a new page and new search form and I believe I have found what is causing the page to show no results.

It seems that in adding category and tag INCLUDE ids, it creates the correct search form widget with all of the options, however it also applies those limitations on the initial search results in an AND form.

In other words, if I have just a category dropdown of 10 ids, the plugin performs perfectly. As soon as I add 5 tag ids to that INCLUDE field, the plugin is doing some sort of cross-reference between the two, and never shows any results. Even if no category is selected, and you check a tag box (that shows the count of 5 posts), there will be no results.

Example: http://www.biia.com/jon-test (If I remove the TAG INCLUDE ids, the category dropdown will work perfectly, but I need it to work as is.)

PLEASE ADVISE

Thanks.

Anonymous

#8904

More info:

From my Apache error log anytime I include a TAG filter:

mod_fcgid: stderr: \t\t\t\t) = 1 AND tt1.term_taxonomy_id IN (42,57,132,146,226,238,263,1594,1629,1979,2729,3235,3881,3950,4219,5235,5272) AND tt2.term_taxonomy_id IN (5609,5823,5824,5860,5861) ) AND wp_posts.post_type IN (‘post’, ‘tribe_events’) AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 25 made by do_action(‘wp_ajax_get_results’), call_user_func_array, Search_Filter->get_results, Search_Filter_Get_Results->the_results, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

Anonymous

#8905

I changed from FastCGI to Apache running PHP and got the following error (rather than the above 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_date) AS post_date FROM wp_posts INNER JOIN wp_term_relationship’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = ‘tribe_events’, .meta_value, wp_posts.post_date) AS post_date FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_postmeta as on wp_posts.ID = .post_id AND .meta_key = ‘_EventStartDate’ WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (42,57,132,146,226,238,263,1594,1629,1979,2729,3235,3881,3950,4219,5235,5272) AND tt1.term_taxonomy_id IN (5609,5823,5824,5860,5861) ) AND wp_posts.post_type IN (‘post’, ‘tribe_events’) AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 25 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/sahifa/page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Search_Filter_Display_Shortcode->display_shortcode, Search_Filter_Display_Results->output_results, Search_Filter_Get_Results->the_results, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

Ross Moderator

#8924

Hey there

Sorry for the generic message – I got locked out and blacklisted by my host for this website!! – so been unable to login and reply to tickets – playing catchup now – will be systematically working through tickets today.

Thanks

[Author]

Posts