[Koha-bugs] [Bug 16702] Notice Triggers Issue: Delivery Mechanism Options Not Saving

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702

--- Comment #1 from Craig <bassplayer9 at 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.