WPDreams

Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

Author

Posts
December 5, 2015 at 5:10 pm in reply to: Products from one category only #6920

Wesley McDermott
Participant

Hey Ernest,

Thanks Ive added the plugin again and will let you know if i have any issues.

November 23, 2015 at 2:19 pm in reply to: Products from one category only #6714

Wesley McDermott
Participant

Hi Ernest,

Thanks I will remove the plugin for now and then proceed when you have reworked it. I appreciate your ongoing help and work on this!

Wes

November 23, 2015 at 1:46 pm in reply to: Products from one category only #6711

Wesley McDermott
Participant

Hi Ernest,

I have updated and been running the new version of the plugin now for over a week and my host is still saying the problem persists. They sent me the following message:

We see that the same query continues to executes.
Because it is heavy for the Mysql server and it need unusual long time to execute and it can lead to 503 errors.

Here it is the query and you can see that after 9 seconds it is still executing. And along with it there is another one similar to this which stays for 5 seconds.

==============================================

1789658 haunted localhost haunted_haunted Query 00:00:09 SELECT wp_posts.post_title as title, wp_posts.ID as id, wp_posts.post_date as date, wp_posts.post_content as content, wp_posts.post_excerpt as excerpt, wp_users.user_nicename as author, wp_posts.post_type as post_type, (SELECT DISTINCT CONCAT(‘–‘, GROUP_CONCAT( wp_term_taxonomy.term_id SEPARATOR ‘—-‘ ), ‘–‘) FROM wp_term_taxonomy LEFT JOIN wp_term_relationships ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id WHERE (wp_term_relationships.object_id = wp_posts.ID) ) as ttid, ((case when (lower(wp_posts.post_title) REGEXP ‘rugby|hotel|hall’) then 10 else 0 end) + (case when (lower(wp_posts.post_content) REGEXP ‘hotel|brownsover|hall|warwick|ideal|available|upon|avon|stratford|rugby’) then 8 else 0 end)) as relevance FROM wp_posts LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID LEFT JOIN wp_users ON wp_users.ID = wp_posts.post_author WHERE (wp_posts.ID <> 379) AND (wp_posts.post_
type
REGEXP ‘[[:<:]]dummy_notting[[:>:]]|[[:<:]]post[[:>:]]|[[:<:]]product[[:>:]]’) AND wp_posts.ID NOT IN (-99) AND (wp_posts.post_status = ‘publish’) AND ((lower(wp_posts.post_title) REGEXP ‘rugby|hotel|hall’) OR (lower(wp_posts.post_content) REGEXP ‘rugby|hotel|hall’) OR (lower(wp_posts.post_content) REGEXP ‘hotel|brownsover|hall|warwick|ideal|available|upon|avon|stratford|rugby’) OR (lower(wp_posts.post_title) REGEXP ‘hotel|brownsover|hall|warwick|ideal|available|upon|avon|stratford|rugby’)) GROUP BY wp_posts.ID 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 ‘–298–‘) ORDER BY relevance DESC, wp_posts.post_date DESC LIMIT 3

November 13, 2015 at 8:04 pm in reply to: Products from one category only #6629

Wesley McDermott
Participant

Hi Ernest,

I have installed the new version, have asked my host to monitor. Will get back to you when I know more.

Many thanks,
Wes

November 12, 2015 at 6:05 pm in 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: [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: [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: [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: [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: [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: [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: [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: [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: [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: [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: [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: [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: [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: [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: ‘–344–|–325–|–326–|–327̵ –|–47
5–|–476–|–477–|–478–|–479 [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: stderr: WordPress database error Got error ‘repetition-operator operand invalid’ from regexp for query
\t\tSELECT
wp_posts.post_title as title,
wp_posts.ID as id,
wp_posts.post_date as date,
wp_posts.post_content as content,
wp_posts.post_excerpt as excerpt,
wp_users.user_nicename as author,
wp_posts.post_type as post_type,
(SELECT DISTINCT CONCAT(‘–‘, GROUP_CONCAT( wp_term_taxonomy.term_id SEPARATOR ‘—-‘ ), ‘–‘) FROM wp_term_taxonomy
LEFT JOIN wp_term_relationships ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE (wp_term_relationships.object_id = wp_posts.ID) ) as ttid,
((case when
(lower(wp_posts.post_title) REGEXP ’18th|march|2016’)
then 10 else 0 end) + (case when
(lower(wp_posts.post_content) REGEXP ‘&gt|skirrid|&lt|investigation|inn|haunted|staircase|*chance|possibly|courtroom’)
then 8 else 0 end)) as relevance
\t\tFROM wp_posts
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
LEFT JOIN wp_users ON wp_users.ID = wp_posts.post_author
stderr:
WHERE
(wp_posts.ID <> 12735) AND
(wp_posts.post_type REGEXP ‘[[:<:]]dummy_notting[[:>:]]|[[:<:]]post[[:>:]]|[[:<:]]product[[:>:]]’) AND
wp_posts.ID NOT IN (-99) AND
(wp_posts.post_status = ‘publish’) AND
((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’))
GROUP BY wp_posts.ID
HAVING (ttid NOT REGEXP
1;|–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
211;|–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–‘)
\t\tORDER BY relevance DESC, wp_posts.post_date DESC
\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

November 10, 2015 at 10:34 am in reply to: Products from one category only #6596

Wesley McDermott
Participant

Okay thanks very much!

November 10, 2015 at 12:01 am in reply to: Products from one category only #6589

Wesley McDermott
Participant

Thanks for your help, I missed a few of the terms I didn’t want excluding out.

One more thing, where do I change the background and text colour of the display, i’ve been and changed the container layout colours but nothing seems to be changing?

November 9, 2015 at 5:26 pm in reply to: Products from one category only #6582

Wesley McDermott
Participant

Ah great stuff, thanks! Can’t believe I missed that!

I have noticed another issue not sure what is the matter. I have only one post showing for the tag ‘south wales’ as you can see here: http://www.hauntedrooms.co.uk/product/the-skirrid-inn-monmouthshire-south-wales

and here: http://www.hauntedrooms.co.uk/product/margam-castle-port-talbot-wales

it always seems to be the same event shown too.

There are more related products shown on other tags such as here: http://www.hauntedrooms.co.uk/product/dudley-castle-ghost-hunts-west-midlands

November 9, 2015 at 5:00 pm in reply to: Products from one category only #6580

Wesley McDermott
Participant

Ah sorry, I’ve just re-added your login. You should be able to login using original details.

November 9, 2015 at 3:53 pm in reply to: Products from one category only #6577

Wesley McDermott
Participant

Hi Ernest,

Sorry about that, please see again.

November 7, 2015 at 9:11 pm in reply to: Products from one category only #6569

Wesley McDermott
Participant

Thanks.

I’ve managed to get it showing, however it’s not obeying the relationship with products. I have set relationships for tags only.

As you can see from the page below, it’s showing posts that have different tags:

http://www.hauntedrooms.co.uk/product/the-skirrid-inn-monmouthshire-south-wales

The link above should show products that have the tag ‘south wales’.

Wes
Author

Posts

Viewing 11 posts - 1 through 11 (of 11 total)