Hey Tiago1981,
We will check our sql queries to confirm functionality. If we can replicate the issue then we will find a solution and release an update.
I have the latest update but there is nothing changed
Managed to fix this issue.
replace the following:
function order_by($key, $sort = 'ASC') {
$this->order_by = ' ORDER BY <code>' . $key . '</code> ' . $sort;
}
with
function order_by($key, $sort = 'ASC') {
$this->order_by = ' ORDER BY ' . $key . ' ' . $sort;
}
in
wp-content/plugins/rich-reviews/lib/nmdb.php
EDIT THIS FILE ON LINE NUMBER( wp-content/plugins/rich-reviews.php LINE NUMBER:-> 446 )
( Replace this code to the new one )
OLD=>
$this->db->order_by('rand()');
NEW=>
$order_query = "ORDER BY rand()";
$this->db->$order_query;
Thank to yesmeen
