[Bug 16702] New: Notice Triggers Issue: Delivery Mechanism Options Not Saving
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702 Bug ID: 16702 Summary: Notice Triggers Issue: Delivery Mechanism Options Not Saving Change sponsored?: --- Product: Koha Version: 16.05 Hardware: PC OS: Linux Status: NEW Severity: blocker Priority: P5 - low Component: Notices Assignee: koha-bugs@lists.koha-community.org Reporter: bassplayer9@hotmail.com QA Contact: testopia@bugs.koha-community.org Problem with Notice & Status Triggers (Tools › Notice triggers) When attempting to save my notice trigger configuration after (1) setting a delay integer, (2) selecting an overdue notice template, and (3) then choosing a delivery type (Email, SMS, etc.), the configuration saves but without the any of the delivery method types saving/sticking - they reset to an unchecked status. I do get a "changes saved" confirmation overall, but my delivery mechanism selections disappear for Email, Print, and SMS after clicking the "Save Changes" button. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702 --- Comment #1 from Craig <bassplayer9@hotmail.com> --- As follow-up to the initial bug report...
From intranet-error.log:
=======BEGIN LOG ENTRY======= [Thu Jun 09 13:38:06.017496 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 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 13:38:06.017674 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 2016] overduerules.pl: INSERT INTO overduerules_transport_types(, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl [Thu Jun 09 13:38:06.017788 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 2016] overduerules.pl: overduerules_id, letternumber, message_transport_type, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl [Thu Jun 09 13:38:06.017854 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 2016] overduerules.pl: ) VALUES (, referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl [Thu Jun 09 13:38:06.018004 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 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 13:38:06.018095 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 2016] overduerules.pl: ), referer: https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl [Thu Jun 09 13:38:06.018279 2016] [cgi:error] [pid 14102] [client 174.113.255.196:54329] AH01215: [Thu Jun 9 13:38:06 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 =======END LOG ENTRY======= Haven't the foggiest what this means specifically. My gut tells me that sql is searching for data or a table that isn't currently there, and cannot write. Though I am very unsure. Have no idea why this would happen. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702 Craig <bassplayer9@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #2 from Craig <bassplayer9@hotmail.com> --- This was the result of a corrupted SQL schema. Perhaps from incorrectly upgrading from 3.22 to 16.05 by restoring an sql dump from 3.22 into 16.05. I haven't been able to reproduce the transport option save failure on a fresh install of 16.05. Everything looks good here. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702 Yakub <brokenmoon7177@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |brokenmoon7177@gmail.com --- Comment #3 from Yakub <brokenmoon7177@gmail.com> --- This issue can be fixed using mysql hack by renaming overduerules table to old_overduerules then change back to overduerules. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702 Liz Rea <liz@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |liz@catalyst.net.nz --- Comment #4 from Liz Rea <liz@catalyst.net.nz> --- I ended up fixing this by dropping the overduerules and overduerules_transport_types tables (there were hardly any entries anyway) and recreating them from the schema of the version I was running (in this case, 17.05). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org