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

Craig Butosi craig.butosi at rcmusic.ca
Sat Jun 11 05:05:43 NZST 2016 

Hi Jonathan, all,

Thanks for confirming. I'm looking at the koha log file now and there are 2 files labeled as updatedatabase-error. Yes, something horrible happened during 3.22-->16.05. My fault for ignoring this immediately after the Web installer ran. Looks like write errors after updatedatabase.pl ran, duplicate columns warnings, etc.

File 1
https://www.dropbox.com/s/h72huzxa9m88hhk/updatedatabase_2016-06-06T135642_3.2206000_16.0500000.txt?dl=0

File2
https://www.dropbox.com/s/tybsmb8ytwtjyv3/updatedatabase-error_2016-06-06T135642_3.2206000_16.0500000.txt?dl=0


Would dropping koha db and then creating an empty sql db correct this, or should I remove our koha instance completely and do a fresh install? I'm dealing with an empty Koha instance, other than some jquery and css modifications. So, it's not a big deal to start fresh.

Recommendations? (Thank you for your time, btw!)

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

-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Jonathan Druart
Sent: June-10-16 7:49 AM
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)

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=b481823b29
>> 9d45ee94b0016389bb76e9&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.
_______________________________________________
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.

More information about the Koha mailing list