http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12752

--- Comment #3 from Barton Chittenden <[email protected]> ---
This became an issue at one of our partner consortia; this database row needs
to be deleted before it causes more problems:

The library had several additional OVERDUE notices:

select module, code, branchcode, name, is_html, title, message_transport_type
from letter where code='OVERDUE';
+-------------+---------+------------+----------------------------------+---------+--------------------------------+------------------------+
| module      | code    | branchcode | name                             |
is_html | title                          | message_transport_type |
+-------------+---------+------------+----------------------------------+---------+--------------------------------+------------------------+
| circulation | OVERDUE |            | Item Past Due Alert (2nd Notice) |      
0 | Library Item(s) Past Due Alert | email                  |
| circulation | OVERDUE |            | Printable Hold notice            |      
0 | Overdue Notice (phone notice)  | phone                  |
| circulation | OVERDUE | XYZZY      | Item Past Due Alert (2nd Notice) |      
0 | Library Item(s) Past Due Alert | email                  |
| circulation | OVERDUE | ABCDEF     | Item Past Due Alert              |      
0 | Library Item(s) Past Due Alert | email                  |
| circulation | OVERDUE | FOOOBARB   | Item Past Due Alert (2nd Notice) |      
0 | Library Item(s) Past Due Alert | email                  |
+-------------+---------+------------+----------------------------------+---------+--------------------------------+------------------------+

This caused confusion, because

a) The OVERDUE/"All libraries" notice with name "Printable Hold notice" did
*not* show as a distinct letter on tools/letter.pl
b) tools/overduerules.pl shows available letters by 'letter.name', but only the
letter code is stored in the overduerules table.

This also points the the necessity of adding a primary key to the letters
table, as noted in bug 13215.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
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/

Reply via email to