• Hello.

    I set up plugin on one of my websites.

    The problem occurs when a visitor starts search on my set up criteria. In that moment site crashes and this is what sql perform:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
    INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id)
    INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
    INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id)
    INNER JOIN wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id)
    INNER JOIN wp_postmeta AS mt5 ON (wp_posts.ID = mt5.post_id)
    INNER JOIN wp_postmeta AS mt6 ON (wp_posts.ID = mt6.post_id) WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_author = 1 AND wp_posts.post_status = ‘private’) AND ( (wp_postmeta.meta_key = ‘search_by_type’ AND CAST(wp_postmeta.meta_value AS CHAR) = ‘Free’)
    OR (mt1.meta_key = ‘search_by_layout’ AND CAST(mt1.meta_value AS CHAR) != ‘get_all_cmf_except_me’)
    OR (mt2.meta_key = ‘search_by_design’ AND CAST(mt2.meta_value AS CHAR) != ‘get_all_cmf_except_me’)
    OR (mt3.meta_key = ‘search_by_columns’ AND CAST(mt3.meta_value AS CHAR) != ‘get_all_cmf_except_me’)
    OR (mt4.meta_key = ‘search_by_sidebar’ AND CAST(mt4.meta_value AS CHAR) != ‘get_all_cmf_except_me’)
    OR (mt5.meta_key = ‘search_by_thematics’ AND CAST(mt5.meta_value AS CHAR) != ‘get_all_cmf_except_me’)
    OR (mt6.meta_key = ‘search_by_features’ AND CAST(mt6.meta_value AS CHAR) != ‘get_all_cmf_except_me’) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 8

    Where could be the problem? Why does website stop working at that moment?

    http://wordpress.org/plugins/advance-wp-query-search-filter/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author TC.K

    (@wp_dummy)

    Can’t tell what is the problem. The sql seem fine. Maybe it is because it is crashing with other plugin?

    Thread Starter armands87

    (@armands87)

    Thanks for quick reply. I don’t think that the problem is between plugins. Maybe I doing something wrong by creating a new form. Can you check the link below that everything is done right, please.

    Screenshot:

    Thread Starter armands87

    (@armands87)

    Plugin Author TC.K

    (@wp_dummy)

    Still can’t sure. Your setting is correct.

    How many posts you have in your site? One reason is too many posts have to look for, and exhaust the php memory.

    Also, what I saw on the sql query above, you have selected ‘post’, ‘page’, ‘attachment’ post type, maybe you should narrow down it to the post type that related to your posts only.

    Normally ‘page’ and ‘attachment’ are unnecessary included in the search.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Help! Website stop working after search…where is problem?’ is closed to new replies.