Reply To: Price notation and height of navigation field

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Price notation and height of navigation field Reply To: Price notation and height of navigation field

#4226
Ernest Marcinko
Ernest Marcinko
Keymaster

Interesting. I might have found a bug, but I can’t confirm yet. Could you please open up the wp-content/plugins/ajax-search-pro/includes/search_content.class.php file and go to line 302, where you should see this code:

CONCAT('--', GROUP_CONCAT(DISTINCT $wpdb->terms.term_id SEPARATOR '----'), '--') as ttid,

Replace that line with this:

(SELECT DISTINCT CONCAT('--', GROUP_CONCAT( $wpdb->term_taxonomy.term_id SEPARATOR '----' ), '--') FROM $wpdb->term_taxonomy
                LEFT JOIN $wpdb->term_relationships ON $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
                WHERE ($wpdb->term_relationships.object_id = $wpdb->posts.ID) ) as ttid,

That will possibly solve this issue, at least I hope so.

Best,
Ernest Marcinko

If you like my products, don't forget to rate them on codecanyon :)