[Bug 13171] New: Check box for email is missing for hold notifications in patron messaging preferences.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 Bug ID: 13171 Summary: Check box for email is missing for hold notifications in patron messaging preferences. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: barton@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com After upgrade to 3.16, I've seen two partners who have the 'Email' check-box missing in the 'Patron Messaging Preferences' area on moremember.pl. There is a '-' where the check box should appear. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 Jesse Maseto <jesse@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P1 - high CC| |jesse@bywatersolutions.com Severity|enhancement |blocker -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 --- Comment #1 from Barton Chittenden <barton@bywatersolutions.com> --- Additional research shows that message_transports does not have a row containing letter_code='HOLD' and message_transport_type='email'. I don't know what message_transports looked like prior to the 3.16 upgrade, but I did see that there were email messages in message_queue of type 'HOLD'. I suspect that update_database.pl may have caused the issue, but I don't have proof. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz Severity|blocker |critical -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 --- Comment #2 from Barton Chittenden <barton@bywatersolutions.com> --- I am seeing the same thing happen at a different library; this time on PREDUEDGST. Note that this occurred significantly after the upgrade to 3.16, so I don't think that we're looking at an issue with update_database.pl -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@biblibre.co | |m --- Comment #3 from Jonathan Druart <jonathan.druart@biblibre.com> --- Have you still the problem? If yes, please paste the return for the following mysql command: select * from message_transports; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We ran into the same problem: After updating from 3.12.09 to 3.18.5.1 the table message_transports is missing all entries for the HOLD notice, resulting in the checkbox missing from the interface. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We updated over 15 installations now and the problem only appeared once. It might depend on the version the database started with or something in configuration. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |normal --- Comment #6 from Jonathan Druart <jonathan.druart@biblibre.com> --- Ok, lowering the priority but let it open to try and get more information. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13171 --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Some instructions on how to fix this if you run into it: Check if there are entries for HOLD in the message_transports table: select * from message_transports If they are missing, run the following update: INSERT INTO message_transports (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code) VALUES (4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'); The checkbox should show up again. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org