Randomize

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