The backend of Book Library Pro (2.1) gives the following nasty message if there are no review saved:
| Code: |
error 12354877-[admin.booklibrary.php]:
SELECT b.id AS fk_bookid, a.id AS review_id, b.isbn, b.title AS title_book, GROUP_CONCAT(c.title SEPARATOR ', ') AS title_catigory, a.title AS title_review, a.comment, e.user_name, a.date, a.rating FROM u6hkv_booklibrary_review AS a, u6hkv_booklibrary AS b, u6hkv_booklibrary_main_categories AS c, u6hkv_booklibrary_categories AS w, ( SELECT DISTINCT d.name AS user_name, a.fk_userid FROM u6hkv_booklibrary_review AS a, u6hkv_users AS d WHERE d.id = a.fk_userid UNION all SELECT DISTINCT 'anonymous' AS user_name, a.fk_userid FROM u6hkv_booklibrary_review AS a WHERE a.fk_userid = 0) AS e WHERE a.fk_bookid = b.id AND b.id = w.bookid AND w.catid = c.id AND a.fk_userid = e.fk_userid GROUP BY review_id ORDER by date LIMIT 0,20;
returns NULL
|
And how do I add a review in the backend? I can add a review in the frontend when I am logged in as administrator, but I wish to add reviews only in the backend.
Regards
Juergen
Favoured: 0
