Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)
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.
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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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.
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@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@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@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@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.
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... File2 https://www.dropbox.com/s/tybsmb8ytwtjyv3/updatedatabase-error_2016-06-06T13... 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@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: June-10-16 7:49 AM To: koha@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@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@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@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@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@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.
Your log file is scary :) It seems that you have done something wrong with your database. I'd say you used a DB created with the current version (16.05 or master) and executed all the updates since 3.23.00.000. But it's weird because the "Version" system preference should prevent this manipulation problem. So yes, if you do not care of your install, restart with a new one :) 2016-06-10 18:05 GMT+01:00 Craig Butosi <craig.butosi@rcmusic.ca>:
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...
File2 https://www.dropbox.com/s/tybsmb8ytwtjyv3/updatedatabase-error_2016-06-06T13...
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@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: June-10-16 7:49 AM To: koha@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@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@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@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@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@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.
participants (2)
-
Craig Butosi -
Jonathan Druart