OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Nasty error Message if no reviews are avaialble (0 viewing) 
BookLibary Component Support
Go to bottom Favoured: 0
TOPIC: Nasty error Message if no reviews are avaialble
juergend (Visitor)
Posts: 0
graphgraph
User Offline
Nasty error Message if no reviews are avaialble 10 Years, 8 Months ago
Karma: 0  
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
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 7705
graph
User Offline Click here to see the profile of this user
Re:Nasty error Message if no reviews are avaialble 10 Years, 8 Months ago
Karma: 93  
hello Juergen,

Sorry i can reproduce that.

Please describe how I can reproduce that ?

can you give admin access to yours site or to yours demo site - ? with that we will can find where error.

Yours account details you may send to OrdaSoft contact form

Thanks,
Andrew
Logged Logged
The administrator has disabled public write access.
juergend (Visitor)
Posts: 0
graphgraph
User Offline
Re:Nasty error Message if no reviews are avaialble 10 Years, 8 Months ago
Karma: 0  
That is confusing. You can reproduce the error but you want to know how you can reproduce it?

Assuming you mean "You can't reproduce it"

Install a fresh Joomla 1.7.2, install Book Library Pro, delete the demo contents and replace it with a couple of books without review,
go to the review menu in the backend, and you will see the error.

But all in all this is a minor bug. After adding a review, the error message disappears. You just forgot to catch the case where no
reviews are available.

Regards
Juergen
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 7705
graph
User Offline Click here to see the profile of this user
Re:Nasty error Message if no reviews are avaialble 10 Years, 8 Months ago
Karma: 93  
Sorry Yes I mean "I can't reproduce error"

we will fix that

Thank you
Logged Logged
The administrator has disabled public write access.
Go to top