Summary: | Notice Triggers Issue: Delivery Mechanism Options Not Saving | ||
---|---|---|---|
Product: | Koha | Reporter: | Craig <bassplayer9> |
Component: | Notices | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
Severity: | blocker | ||
Priority: | P5 - low | CC: | brokenmoon7177, liz |
Version: | 16.05 | ||
Hardware: | PC | ||
OS: | Linux | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
Description
Craig
2016-06-09 15:00:27 UTC
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. 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. This issue can be fixed using mysql hack by renaming overduerules table to old_overduerules then change back to overduerules. 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). |