https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18990 Bug ID: 18990 Summary: Overdue Notices are not sending through SMS correctly Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Notices Assignee: nick@bywatersolutions.com Reporter: kelly@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org For SMS messages to be sent, the patron has to have a phone number to receive text messages and their carrier. When an enhanced message sends(advance notices, holds, checkin, checkouts) it takes the phone number and adds the appropriate carrier information to it. For the Over Notices, the SMS number is not getting attached to the carrier information, the email information is being used instead. Thus the patron is receiving an SMS overdue notice via their email address instead of through a text message. See below- an advanced notice of Item due sent via SMS uses the phone number, however, the overdue Notice uses the email address: select message_id, to_address, subject, message_transport_type as mtt from message_queue where message_transport_type='sms' and date(time_queued) = CURRENT_DATE limit 10; +------------+------------------------------------------------------+----------------------------+-----+ | message_id | to_address | subject | mtt | +------------+------------------------------------------------------+----------------------------+-----+ | 549913 | cabs@gmail.com@vtext.com@vtext.com@vtext.com | Overdue Notice | sms | | 551808 | llie.re@btx.gov@txt.att.net | Overdue Notice | sms | | 551811 | nbur5@tx.rr.com@tmomail.net | Overdue Notice | sms | | 551814 | jbeel@gmail.com@vtext.com | Overdue Notice | sms | | 551871 | 8172284361@tmomail.net | Advance Notice of Item Due | sms | | 551873 | 8172284361@tmomail.net | Advance Notice of Item Due | sms | | 551875 | 8172284361@tmomail.net | Advance Notice of Item Due | sms | | 551901 | 817-879-8111@txt.att.net | Advance Notice of Item Due | sms | | 551904 | 817-879-8111@txt.att.net | Advance Notice of Item Due | sms | | 551906 | 817-879-8111@txt.att.net | Advance Notice of Item Due | sms | +------------+------------------------------------------------------+----------------------------+-----+ -- You are receiving this mail because: You are watching all bug changes.