[Koha-bugs] [Bug 6178] tag cloud diff depends on where you click
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri May 20 17:20:32 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6178
--- Comment #5 from Owen Leonard <oleonard at myacpl.org> 2011-05-20 15:20:32 UTC ---
When you click the "my tags" link the tags page is passed parameter, "mine=1."
The page is supposed to display only the logged in user's tags. This is the
query which is going on in the background:
SELECT tags_approval.term AS term,
tags_approval.approved AS approved,
tags_approval.date_approved AS date_approved,
tags_approval.approved_by AS approved_by,
tags_approval.weight_total AS weight_total,
CONCAT(borrowers.surname, ', ', borrowers.firstname) AS
approved_by_name
FROM tags_approval
LEFT JOIN borrowers
ON tags_approval.approved_by = borrowers.borrowernumber
WHERE approved = 1 and borrowernumber = [logged in borrower]
The problems with this is that it will always return no results: borrowernumber
doesn't exist in the tags_approval table. It can only be found in the tags_all
table.
--
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
More information about the Koha-bugs
mailing list