Kobus Myburgh

Thank you, Jory. I will check if the documentation allows that – but I would prefer not to update the plugin’s source, because when it updates, the changes will be lost.

Perhaps I need to look at a different ratings plugin as well. Since this is a “pet project” I will handle that over the weekend.

Thanks for taking the time to respond.

My logic and some SQL knowledge tells me that I need a calculation at this point, but would need HAVING instead of WHERE. Any ideas?

It looks like it is abandoned. I also have a support query out for three weeks. I am now using YASR.

Is this plugin still supported?

For completeness sake, adding [kkstarratings] manually to a page does not show the voting controls either. The [pods] shortcode works, so it is not an issue with the short codes.

I am sure the plugin is activated, it is not restricted on any pages, and my pods admin template adds the following below the jokes:

[kkstarratings force=”false” valign=”bottom” align=”left”]

Not sure what force means, but with or without that flag, and with true or false values, still no luck.

Thank you, Jim. I specifically can’t buy Gravity forms right now – although I really like to support plugin authors as they do deserve to make a living as well. I just can’t right now. Anyway – I will see if I can make it work with Caldera forms, but not sure how this will work without your plugin (seems you only have a Gravity forms plugin).

Thanks for responding.

Forgot to mark as resolved. Thanks!

Thank you very much, Jim! PROBLEM SOLVED.

I tried casting initially, but I must’ve done it wrong.

Thank you for your answer, Jim! Much appreciated.

I am now not getting the error, but my result is empty.

[pods name="jokes" where="age_restriction.meta_value='parental_guidance' AND _kkr_avg.meta_value BETWEEN '4.00' AND '5.00'" template="joke"]

My query now looks like this:

SELECT DISTINCT t.* FROM wp_posts AS t LEFT JOIN wp_postmeta AS age_restriction ON age_restriction.meta_key = ‘age_restriction’ AND age_restriction.post_id = t.ID LEFT JOIN wp_postmeta AS _kkr_avg ON _kkr_avg.meta_key = ‘_kkr_avg’ AND _kkr_avg.post_id = t.ID WHERE ( ( age_restriction.meta_value=’parental_guidance’ AND _kkr_avg.meta_value BETWEEN ‘4.00’ AND ‘5.00’ ) AND ( t.post_type = “jokes” ) AND ( t.post_status IN ( “publish” ) ) ) ORDER BY t.menu_order, t.post_title, t.post_date LIMIT 0, 15;

– No error, but also no result.

Here is the entry of the post I am expecting to find in phpMyAdmin:

48 _kksr_avg 5.00

So – the post is there.

I have stripped it down to not include the rating, then I get result I am expecting:

SELECT DISTINCT t.* FROM wp_posts AS t
LEFT JOIN wp_postmeta AS age_restriction ON age_restriction.meta_key = ‘age_restriction’ AND age_restriction.post_id = t.ID
WHERE ( ( age_restriction.meta_value=’parental_guidance’ ) AND ( t.post_type = “jokes” ) AND ( t.post_status IN ( “publish” ) ) ) ORDER BY t.menu_order, t.post_title, t.post_date LIMIT 0, 15;

I have also tried CAST() to DECIMAL and without the quotes around the numbers. No success. So the problem appears to be with the rating part of the query.

The only other thing I can think of is that I create a relationship in the pod, calling it rating, and then modify the kksr plugin to update the pod field as well as the original rating field. Your thoughts?

Thanks in advance!

Kobus

Apologies – I have registered a long time ago, but probably the first time interacting. Thanks for correcting me, Sire.

Hi Esmi,

I physically had to edit my database via phpmyadmin and replace localhost/invisibleink with https://www.invisible-ink.co.za.

The problem is now solved – thank you for your response.

Kobus

Hi Esmi,

Thanks – I often find it difficult to find help pages, because I do not know what to search for. I just tried to explain my problem as good as I can. I am busy reading your reference post now.

Kobus