Results 1 to 10 of 10

Thread: Refine Results Bug

  1. #1
    Thread Starter
    Veteran weiching's Avatar
    Join Date
    Apr 2011
    Posts
    489
    Thanks
    82
    Thanked 36 Times in 31 Posts

    Refine Results Bug

    Theme Version 3.3.3
    WP Version 3.8.2


    Hello,

    I have a large data sites have this problem.

    In the Refine Results If more than seven options do not have any results, if not more than seven selected is no problem.

    I found these messages in the host error_log

    Code:
    WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query SELECT SQL_CALC_FOUND_ROWS  wpark_posts.ID FROM wpark_posts  INNER JOIN wpark_term_relationships ON (wpark_posts.ID = wpark_term_relationships.object_id) INNER JOIN wpark_postmeta ON (wpark_posts.ID = wpark_postmeta.post_id)
    INNER JOIN wpark_postmeta AS mt1 ON (wpark_posts.ID = mt1.post_id)
    INNER JOIN wpark_postmeta AS mt2 ON (wpark_posts.ID = mt2.post_id)
    INNER JOIN wpark_postmeta AS mt3 ON (wpark_posts.ID = mt3.post_id)
    INNER JOIN wpark_postmeta AS mt4 ON (wpark_posts.ID = mt4.post_id)
    INNER JOIN wpark_postmeta AS mt5 ON (wpark_posts.ID = mt5.post_id)
    INNER JOIN wpark_postmeta AS mt6 ON (wpark_posts.ID = mt6.post_id)
    INNER JOIN wpark_postmeta AS mt7 ON (wpark_posts.ID = mt7.post_id) WHERE 1=1  AND ( wpark_term_relationships.term_taxonomy_id IN (24) ) AND wpark_posts.post_type = 'ad_listing' AND (wpark_posts.post_status = 'publish' OR wpark_posts.post_status = 'tr_pending' OR wpark_posts.post_status = 'tr_failed' OR wpark_posts.post_status = 'tr_completed' OR wpark_posts.post_status = 'tr_activated' OR wpark_posts.post_status = 'private') AND ( (wpark_postmeta.meta_key = 'cp_sale_01' AND CAST(wpark_postmeta.meta_value AS CHAR) IN ('電梯大樓'))
    AND  (mt1.meta_key = 'cp_sale_03' AND CAST(mt1.meta_value AS CHAR) IN ('3 房'))
    AND  (mt2.meta_key = 'cp_sale_04' AND CAST(mt2.meta_value AS CHAR) IN ('2 廳'))
    AND  (mt3.meta_key = 'cp_sale_05' AND CAST(mt3.meta_value AS CHAR) IN ('2 衛'))
    AND  (mt4.meta_key = 'cp_sale_17' AND CAST(mt4.meta_value AS CHAR) IN ('5-10 年'))
    AND  (mt5.meta_key = 'cp_sale_12' AND CAST(mt5.meta_value AS CHAR) IN ('30-40 坪'))
    AND  (mt6.meta_key = 'cp_sale_13' AND CAST(mt6.meta_value AS CHAR) IN ('平面式停車位'))
    AND  (mt7.meta_key = 'cp_sale_16' AND CAST(mt7.meta_value AS CHAR) IN ('尚未裝潢')) ) GROUP BY wpark_posts.ID ORDER BY wpark_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

    I did a test, copy the same site, and then delete all the ads, and then publish only an ad, Refine Results are not limited to the seven selected within.

    Please tell me how to fix.

  2. #2
    meloniq's Avatar
    Join Date
    May 2011
    Location
    Poland
    Posts
    1,073
    Thanks
    17
    Thanked 178 Times in 159 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Have Clipper website?! --> You need coupons importer!!!
    See available integrations with affiliate networks: Commission Factory, CJ Affiliate, Daisycon, Rakuten LinkShare, ShareASale, Tradedoubler, TradeTracker

    Payment gateways: Bitpay, Dotpay, PayU PL, Przelewy24, Skrill

    me @ AT || meloniq.net

  3. #3
    Thread Starter
    Veteran weiching's Avatar
    Join Date
    Apr 2011
    Posts
    489
    Thanks
    82
    Thanked 36 Times in 31 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    Thread Starter
    Veteran weiching's Avatar
    Join Date
    Apr 2011
    Posts
    489
    Thanks
    82
    Thanked 36 Times in 31 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #5
    Thread Starter
    Veteran weiching's Avatar
    Join Date
    Apr 2011
    Posts
    489
    Thanks
    82
    Thanked 36 Times in 31 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #6
    meloniq's Avatar
    Join Date
    May 2011
    Location
    Poland
    Posts
    1,073
    Thanks
    17
    Thanked 178 Times in 159 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Have Clipper website?! --> You need coupons importer!!!
    See available integrations with affiliate networks: Commission Factory, CJ Affiliate, Daisycon, Rakuten LinkShare, ShareASale, Tradedoubler, TradeTracker

    Payment gateways: Bitpay, Dotpay, PayU PL, Przelewy24, Skrill

    me @ AT || meloniq.net

  7. #7
    Thread Starter
    Veteran weiching's Avatar
    Join Date
    Apr 2011
    Posts
    489
    Thanks
    82
    Thanked 36 Times in 31 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  8. The Following User Says Thank You to weiching For This Useful Post:

    meloniq (June 23rd, 2014)

  9. #8
    samcy's Avatar
    Join Date
    Mar 2012
    Location
    Germany
    Posts
    12,100
    Thanks
    121
    Thanked 1,755 Times in 1,441 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Rolf Hassel (Samcy)

  10. The Following User Says Thank You to samcy For This Useful Post:

    weiching (June 24th, 2014)

  11. #9
    Thread Starter
    Veteran weiching's Avatar
    Join Date
    Apr 2011
    Posts
    489
    Thanks
    82
    Thanked 36 Times in 31 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  12. #10
    Junior Member cyjambo's Avatar
    Join Date
    Apr 2012
    Location
    Austria
    Posts
    45
    Thanks
    11
    Thanked 4 Times in 2 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [MOD NEEDED] Refine Results show in Search Results
    By danilocarneiro in forum ClassiPress General Discussion
    Replies: 6
    Last Post: April 30th, 2014, 08:40 AM
  2. Refine Results
    By comproevendo in forum ClassiPress General Discussion
    Replies: 1
    Last Post: October 9th, 2013, 12:39 PM
  3. Samcy refine results
    By streetfiredesigns in forum Help Using ClassiPress
    Replies: 1
    Last Post: May 21st, 2013, 02:44 PM
  4. 3.1.9 Refine Results bug
    By weiching in forum ClassiPress General Discussion
    Replies: 12
    Last Post: June 6th, 2012, 04:16 AM
  5. Refine Results Bug #?
    By mdowden in forum Report ClassiPress Bugs
    Replies: 3
    Last Post: July 20th, 2011, 06:37 PM