[Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)

Fri Jun 10 23:49:07 NZST 2016

You have something (very) wrong with your schema.
A foreign key is refering to an old_overduerules table. But there is
no such table in Koha.
If you have a look at the DB entry 3.23.00.007 (updatedatabase.pl) you
will find a reference to this table.
You certainly got a sql error when updating, any chances to find it?

2016-06-09 17:16 GMT+01:00 Craig Butosi <craig.butosi at rcmusic.ca>:
> Hi Jonathan,
>
> Bingo. I think the following is the issue. Found it in intranet-error.log:
>
> =========================================================
> [Thu Jun 09 11:17:43.711438 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`overduerules_transport_types`, CONSTRAINT `overduerules_transport_types_ibfk_1` FOREIGN KEY (`overduerules_id`) REFERENCES `old_overduerules` (`overduerules_id`) ON DELETE CASC) [for Statement ", referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711521 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:         INSERT INTO overduerules_transport_types(, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711577 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:             overduerules_id, letternumber, message_transport_type, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711604 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:         ) VALUES (, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711674 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:             (SELECT overduerules_id FROM overduerules WHERE branchcode = ? AND categorycode = ?), ?, ?, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711697 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:         ), referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711762 2016] [cgi:error] [pid 2943] [client 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:     " with ParamValues: 0="MAIN", 1='BOR', 2=1, 3="email"] at /usr/share/koha/intranet/cgi-bin/tools/overduerules.pl line 200., referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> =========================================================
>
>
> I wonder if this might have something to do with upgrading to 3.22-->16.05 on my end.
>
> Any ideas?
>
> C
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West Toronto, ON  M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
>
> ________________________________________
> From: Jonathan Druart [jonathan.druart at bugs.koha-community.org]
> Sent: Thursday, June 09, 2016 11:50 AM
> To: Craig Butosi
> Cc: koha
> Subject: Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)
>
> Hi Craig,
> It seems to work for me (dev install on master).
> Could you check the logs file and check if it's clear or not?
> If everything looks ok in the logs, could you try on a sandbox to make
> sure it's a bug?
> Regards,
> Jonathan
>
> 2016-06-09 14:49 GMT+01:00 Craig Butosi <craig.butosi at rcmusic.ca>:
>> Hi all,
>>
>> Update:
>>
>> Problem with Notice & Status Triggers (Tools › Notice triggers)
>>
>> I just discovered that when I attempt to save my notice trigger configuration after (1) setting a delay integer, (2) selecting an overdue notice template, and then choosing a delivery type (Email, SMS, etc.), the configuration saves but without the any of the delivery method types saving - they reset to an unchecked status. I do get a "changes saved" confirmation overall, but my selections disappear for Email, Print, and SMS after clicking the Save Changes button.
>>
>> The only column that does stick is Restrict.
>>
>> I think this might be why my overdue notices aren't sending. Anyone experience this? Does anyone know how to correct this?
>>
>> Many thanks!
>>
>> C
>>
>> Craig Butosi, MA, MLIS, B Mus (Hons.)
>> LIBRARY SERVICES MANAGER
>> the royal conservatory
>> TELUS Centre for Performance and Learning
>> 273 Bloor Street West Toronto, ON  M5S 1W2
>> 416.408.2824 x338
>> www.rcmusic.ca<https://webmail.rcmusic.ca/owa/redir.aspx?C=b481823b299d45ee94b0016389bb76e9&URL=http%3a%2f%2fwww.rcmusic.ca%2f>
>> ________________________________
>> From: Craig Butosi
>> Sent: Wednesday, June 08, 2016 2:24 PM
>> To: koha
>> Subject: Koha 16.05 - Manually send overdue notices from command-line?
>>
>> Hi all,
>>
>> Koha 16.05
>> Ubuntu 14.04 LTS
>> Package install
>>
>> After one properly sets up overdue notices (i.e., correct HTML markup in ODUE notice, triggers set, enhanced messaging enabled, MTA installed, patron categories set to receive overdue notices, etc.), can you manually compile and push out overdue notices from the command-line? I’ve successfully tested the Advanced Notice, Password Reset, Hold Placed, Check-out and Check-in notices this way; however, I can’t seem to push out overdue notices no matter what I do. (Nor for that matter do I receive overdue notices at all despite crons being set, etc.).
>>
>> Command-line Method:
>>
>> # export PERL5LIB=/usr/share/koha/lib
>> # export KOHA_CONF=/etc/koha/sites/library/koha-conf.xml
>> #/usr/share/koha/bin/cronjobs/overdue_notices.pl
>> #/usr/share/koha/bin/cronjobs/process_message_queue.pl
>>
>> I’m just wondering if a Koha overdue setting is preventing the manual method from succeeding. Or, if it’s more likely something else that’s preventing OD notices from being pushed out.
>>
>> Thanks all!
>>
>> C
>>
>>
>>
>> Craig Butosi, MA, MLIS, B Mus (Hons.)
>> LIBRARY SERVICES MANAGER
>> the royal conservatory
>> TELUS Centre for Performance and Learning
>> 273 Bloor Street West
>> Toronto, ON M5S 1W2
>> 416.408.2824 x338
>> www.rcmusic.ca<http://www.rcmusic.ca/>
>>
>>
>>
>> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.