[Koha-bugs] [Bug 19259] Overdue rules do not save

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

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

Marc Véron <veron at veron.ch> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |veron at veron.ch

--- Comment #1 from Marc Véron <veron at veron.ch> ---
Confirmed.

In my tests it saves columns Delay, Letter and Restrict.
It does NOT save columns Email and Print (Phone and SMS not tested).

While saving I get the following in plack-error.log:

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha_kohadev`.`overduerules_transport_types`, CONSTRAINT
`overduerules_fk` FOREIGN KEY (`overduerules_id`) REFERENCES `old_overduerules`
(`overduerules_id`) ON DELETE CASCADE ON UPDATE CASCAD) [for Statement "
        INSERT INTO overduerules_transport_types(
            overduerules_id, letternumber, message_transport_type
        ) VALUES (
            (SELECT overduerules_id FROM overduerules WHERE branchcode = ? AND
categorycode = ?), ?, ?
        )
    " with ParamValues: 0='', 1='K', 2=1, 3="email"] at
/home/marc/koha/tools/overduerules.pl line 198.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.