Reply To: Products from one category only

#6620

Wesley McDermott
Participant

Hi Ernest,

I'm replying to this ticket as I couldn't get in to the website to post a new topic.

I have received an email from my host saying the plugin is creating a crazy amount msql requests. You can see the message below:

Also we have checked the log files and found the following error:

[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: WordPress database error Got error 'repetition-operator operand invalid' from regexp for query
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: \t\tSELECT
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.post_title as title,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.ID as id,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.post_date as date,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.post_content as content,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.post_excerpt as excerpt,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_users.user_nicename as author,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.post_type as post_type,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: (SELECT DISTINCT CONCAT('–', GROUP_CONCAT( wp_term_taxonomy.term_id SEPARATOR '—-' ), '–') FROM wp_term_taxonomy
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: LEFT JOIN wp_term_relationships ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: WHERE (wp_term_relationships.object_id = wp_posts.ID) ) as ttid,
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: ((case when
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: (lower(wp_posts.post_title) REGEXP '18th|march|2016')
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: then 10 else 0 end) + (case when
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: (lower(wp_posts.post_content) REGEXP '&gt|skirrid|&lt|investigation|inn|haunted|staircase|*chance|possibly|courtroom')
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: then 8 else 0 end)) as relevance
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: \t\tFROM wp_posts
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: LEFT JOIN wp_users ON wp_users.ID = wp_posts.post_author
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr:
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: WHERE
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: (wp_posts.ID <> 12735) AND
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: (wp_posts.post_type REGEXP '[[:<:]]dummy_notting[[:>:]]|[[:<:]]post[[:>:]]|[[:<:]]product[[:>:]]') AND
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: wp_posts.ID NOT IN (-99) AND
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: (wp_posts.post_status = 'publish') AND
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: ((lower(wp_posts.post_title) REGEXP '18th|march|2016′) OR (lower(wp_posts.post_content) REGEXP '18th|march|2016′) OR (lower(wp_posts.post_content) REGEXP '&gt|skirrid|&lt|investigation|inn|haunted|staircase|*chance|possibly|courtroom') OR (lower(wp_posts.post_title) REGEXP '&gt|skirrid|&lt|investigation|inn|haunted|staircase|*chance|possibly|courtroom'))
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: GROUP BY wp_posts.ID
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: HAVING (ttid NOT REGEXP
'–344–|–325–|–326–|–327–|–328–|–329–|–330–|–331–|–332–|–333–|–334–|–335–|–336–|–337–|–338–|–339–|–340–|–341–|–342–|–343–|–345–|–346–|–347–|–355–|–356–|–357–|–358–|–359–|–365–|–366–|–360–|–361–|–362–|–363–|–367–|–368–|–369–|–370–|–371–|–372–|–373–|–374–|–375–|–376–|–377–|–378–|–379–|–380–|–381–|–382–|–383–|–384–|–385–|–386–|–388–|–389–|–390–|–393–|–394–|–395–|–396–|–397–|–398–|–399–|–400–|–401–|–402–|–404–|–406–|–408–|–409–|–411–|–412–|–460–|–413–|–414–|–416–|–418–|–419–|–420–|–421–|–422–|–424–|–425–|–448–|–449–|–426–|–427–|–428–|–429–|–430–|–431–|–432–|–433–|–436–|–437–|–439–|–440–|–450–|–441–|–451–|–442–|–443–|–444–|–445–|–446–|–452–|–453–|–454–|–456–|–457–|–458–|–459–|–465–|–461–|–462–|–463–|–464–|–467–|–469–|–470–|–471–|–472–|–473
–|–47
5–|–476–|–477–|–478–|–479–|–480–|–364–|–482–|–483–|–484–|–485–|–486–|–487–|–489–|–490–|–491–|–492–|–494–|–495–|–496–|–497–|–498–|–499–|–500–|–501–|–502–|–503–|–504–|–505–|–507–|–508–|–509–|–513–|–510–|–514–|–511–|–512–') AND (ttid REGEXP '–297–')
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: \t\tORDER BY relevance DESC, wp_posts.post_date DESC
[Thu Nov 12 10:23:22 2015] [warn] [client 188.165.15.196] mod_fcgid: stderr: \t\tLIMIT 3 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/flatsome/woocommerce/single-product.php'), woocommerce_get_template_part, wc_get_template_part, load_template, require('/themes/flatsome/woocommerce/content-single-product-rightcol-fullheight.php'), woocommerce_get_template, wc_get_template, include('/themes/flatsome/woocommerce/single-product/tabs/tabs.php'), call_user_func, woocommerce_product_description_tab, wc_get_template, include('/themes/flatsome/woocommerce/single-product/tabs/description.php'), the_content, apply_filters('the_content'), call_user_func_array, fixShortcode, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, rppShortcodeContainer->wpdreams_rpp_shortcode, wpdreams_related_content->getRelatedPosts, wpdreams_related_content->simpleRelated