http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6178
--- Comment #5 from Owen Leonard <[email protected]> 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
