cyjambo

Hi Lester,

Thanks a lot for the quick reply!

I see what you mean, that is a pity. I am trying to find a workaround. Is there some sort of action hook that I could use so that when a rating is given the cache is cleared?

Ok, thanks. Is there a way to implement this into the plugin so we don’t need to modify core files? I know this is not a top priority, just wondering ??

Thanks!

Hi,

Ok, thank you very much for the fast response!

Jambo

Hi Emre,

First of all thanks a lot for your plugin, it’s the best and most straight forward that I have used.

I am also interested in JS Minify, this is the only thing which would make it perfect ??

Keep up the good work man!

Jambo

Yes, I can confirm this.

Hi Chris,

I have the same problem and it seems this is caused by my Classipress installation. One of my problematic queries looks like this:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 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)INNER JOIN wp_postmeta AS mt7 ON (wp_posts.ID = mt7.post_id)INNER JOIN wp_postmeta AS mt8 ON (wp_posts.ID = mt8.post_id)INNER JOIN wp_postmeta AS mt9 ON (wp_posts.ID = mt9.post_id)INNER JOIN wp_postmeta AS mt10 ON (wp_posts.ID = mt10.post_id)INNER JOIN wp_postmeta AS mt11 ON (wp_posts.ID = mt11.post_id)INNER JOIN wp_postmeta AS mt12 ON (wp_posts.ID = mt12.post_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36) ) AND wp_posts.post_type IN (‘ad_listing’) AND (wp_posts.post_status = ‘publish’) AND ( (wp_postmeta.meta_key = ‘cp_price’ AND CAST(wp_postmeta.meta_value AS SIGNED) BETWEEN ’33’ AND ‘11746’)AND (mt1.meta_key = ‘cp_bezirk’ AND CAST(mt1.meta_value AS CHAR) IN (’17. Bezirk’))AND (mt2.meta_key = ‘cp_objekttyp’ AND CAST(mt2.meta_value AS CHAR) IN (‘Wohnung’))AND (mt3.meta_key = ‘cp_bau’ AND CAST(mt3.meta_value AS CHAR) IN (‘Neubau’))AND (mt4.meta_key = ‘cp_size’ AND CAST(mt4.meta_value AS CHAR) IN (’61 – 70 m2’,’71 – 80 m2’))AND (mt5.meta_key = ‘cp_zimmer’ AND CAST(mt5.meta_value AS CHAR) IN (‘2′,’3’))AND (mt6.meta_key = ‘cp_heizungsart’ AND CAST(mt6.meta_value AS CHAR) IN (‘Etagenheizung’,’Zentralheizung’))AND (mt7.meta_key = ‘cp_fahrstuhl’ AND CAST(mt7.meta_value AS CHAR) IN (‘Ja’))AND (mt8.meta_key = ‘cp_balkonloggia’ AND CAST(mt8.meta_value AS CHAR) IN (‘Ja’))AND (mt9.meta_key = ‘cp_terrasse’ AND CAST(mt9.meta_value AS CHAR) IN (‘Ja’))AND (mt10.meta_key = ‘cp_keller’ AND CAST(mt10.meta_value AS CHAR) IN (‘Ja’))AND (mt11.meta_key = ‘cp_garage’ AND CAST(mt11.meta_value AS CHAR) IN (‘Ja’))AND (mt12.meta_key = ‘cp_abstellplatz’ AND CAST(mt12.meta_value AS CHAR) IN (‘Ja’)) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20

Even though I am no sql expert, this looks horrible. My hosting provider blocked my account because I was using too much server resources and queries like the above crashed the server.

Do you know of a good way to disable the SELECT SQL_CALC_FOUND_ROWS statement but still have pagination working?

Thanks a lot!

Hi Anaisa,

I would also need this feature. Do you plan to develop this?

Are you still developing the plugin?

Thanks a lot,

CyJambo

Hi guys,

I have the same problem. Do you know if this will be fixed with the plugin or not? I suppose we just need to wait.

Hope it will be sorted soon as I love the plugin.

Peace!

Hi Joost,

I still have the same problem as Norbert.

If I use the workaround from Pascal Dreissen then it works. Do you think you could take a look please and check? Now my sitemap is ok but only after the change in Pascal’s post.

Thanks a lot for your great work,

Jambo

Hi rml,

I just found this topic, could you please tell me if there is any news on this?
Do you still plan to add the feature to disable the ads on mobile devices? Or has it been added already (can’t find it)?

Thanks a lot for your work, awesome plugin you have here!

Jambo