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
#2700
juergend (Visitor)
Fresh Boarder
Posts: 16
graphgraph
User Offline
Nasty error Message if no reviews are avaialble 5 Years, 1 Month 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.
#2707
admin (Admin)
Admin
Posts: 4861
graph
User Offline Click here to see the profile of this user
Re:Nasty error Message if no reviews are avaialble 5 Years, 1 Month ago Karma: 61  
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.
#2708
juergend (Visitor)
Fresh Boarder
Posts: 16
graphgraph
User Offline
Re:Nasty error Message if no reviews are avaialble 5 Years, 1 Month 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.
#2712
admin (Admin)
Admin
Posts: 4861
graph
User Offline Click here to see the profile of this user
Re:Nasty error Message if no reviews are avaialble 5 Years, 1 Month ago Karma: 61  
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
What are you looking for?
Anti-spam question: How many eyes has a typical person?