[Koha-bugs] [Bug 19516] New: can' t save changes on notices if letter is already created

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

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

            Bug ID: 19516
           Summary: can't save changes on notices if letter is already
                    created
 Change sponsored?: ---
           Product: Koha
           Version: 17.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Notices
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: hagud at orex.es
        QA Contact: testopia at bugs.koha-community.org

we have seen a problem modifying notices in koha 17.05.04, the issue is that
you can not modify notices if they're already created, when you try to modify
you get an error in plack as these one.

DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--email-ca-ES' for
key 'PRIMARY' [for Statement "
                    UPDATE letter
                    SET branchcode = ?, module = ?, name = ?, is_html = ?,
title = ?, content = ?, lang = ?
                    WHERE branchcode = ? AND module = ? AND code = ? AND
message_transport_type = ?
                "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line
302.
DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--sms-ca-ES' for
key 'PRIMARY' [for Statement "
                    UPDATE letter
                    SET branchcode = ?, module = ?, name = ?, is_html = ?,
title = ?, content = ?, lang = ?
                    WHERE branchcode = ? AND module = ? AND code = ? AND
message_transport_type = ?
                "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line
302.
DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--email-es-ES' for
key 'PRIMARY' [for Statement "
                    UPDATE letter
                    SET branchcode = ?, module = ?, name = ?, is_html = ?,
title = ?, content = ?, lang = ?
                    WHERE branchcode = ? AND module = ? AND code = ? AND
message_transport_type = ?
                "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line
302.
DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--sms-es-ES' for
key 'PRIMARY' [for Statement "
                    UPDATE letter
                    SET branchcode = ?, module = ?, name = ?, is_html = ?,
title = ?, content = ?, lang = ?
                    WHERE branchcode = ? AND module = ? AND code = ? AND
message_transport_type = ?
                "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line
302.
DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--email-default'
for key 'PRIMARY' [for Statement "
                    UPDATE letter
                    SET branchcode = ?, module = ?, name = ?, is_html = ?,
title = ?, content = ?, lang = ?
                    WHERE branchcode = ? AND module = ? AND code = ? AND
message_transport_type = ?
                "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line
302.
DBD::mysql::db do failed: Duplicate entry 'circulation-PREDUE--sms-default' for
key 'PRIMARY' [for Statement "
                    UPDATE letter
                    SET branchcode = ?, module = ?, name = ?, is_html = ?,
title = ?, content = ?, lang = ?
                    WHERE branchcode = ? AND module = ? AND code = ? AND
message_transport_type = ?
                "] at /usr/share/koha/intranet/cgi-bin/tools/letter.pl line
302.

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