i have installed the book review module and activated it but the reviews are not getting indexed in the review listing page. i created several test book review nodes. both my drupal install and the module are 4.7 when i go to the 'book review' menu item i get the following (red) error message:
user warning: FUNCTION b.DISTINCT does not exist query: SELECT b.DISTINCT(n.nid), n.title, b.booktitle, b.cover, b.publisher, b.isbn, b.copyright, b.pages, b.rating FROM bookreview b INNER JOIN node n ON b.nid = n.nid WHERE n.type = 'bookreview' ORDER BY b.booktitle ASC LIMIT 0, 20 in .../public_html/drupal/includes/database.mysql.inc on line 120.
can someone tell me what this means and how to fix it or how otherwise get my book review nodes to be listed in the book revirew listing page without generating this error message?
