Number of reviews to show doesn't work

Hi,

I have the same problem, only the [RICH_REVIEWS_SHOW num=”all”] shortcode works. I’d like to display 6 reviews on my homepage and all of them on the testimonials page, and where I want to use [RICH_REVIEWS_SHOW num=”6″], it crashes and displays nothing.

Thanks for the help in advance it is much appreciated!

Andrew

I’m also having this issue. Any way to solve this?

OK, I have good news.
There is a great solution for this problem!

In the support forum, there is this topic, where the user jordanlovato92 has a great fix.

What happens is in the file rich-reviews/rich-reviews.php a line is modified.

This line:
reviewer_ip as reviewerip FROM $this->sqltable ” . $whereStatement . ” ” . $limitStatement . ‘ ORDER BY id DESC’;

is replaced with this:
reviewer_ip as reviewerip FROM $this->sqltable ” . $whereStatement . ‘ ORDER BY id DESC ‘ . $limitStatement;

As far as I know there are no more changes, but this does the job perfectly and corrects the plugin. Again, all credit goes to jordanlovato92.

Cheers!
Andrew

UPDATE: Yes this works! Awesome!

Cheers Andrew going to give this a go

Thanks. Works Great.

Confirmed fix, WP 3.8.1. Thanks!

Ugh. This is such an embarrassing error. I wish this support thread would disappear forever so that my shame was erased from the internet for good! It is because of this bug that I abstracted out all of the database (the CRUD) functions into their own class, so that my forgetful self will never again forget in what order SQL queries must be structured.

All that being said, we’ve got another developer (everyone say ‘Allo’ to Austin!) now working on this, so updates and features are now going to be launching faster than a plate of dropped food gets eaten off the floor by your puppy!