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.but...@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.dru...@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.but...@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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha