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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

bugzilla-daemon
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: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]

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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 19516] can't save changes on notices if letter is already created

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

Stefan Berndtsson <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from Stefan Berndtsson <[hidden email]> ---
Created attachment 69086
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=69086&action=edit
Fix condition when updating an existing letter with language support turned on

There is a missing condition for "lang" in the UPDATE line in letter.pl.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/