[Koha-bugs] [Bug 18686] New: TalkingTech_itiva_outbound.pl fails with Illegal mix of collations

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

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

            Bug ID: 18686
           Summary: TalkingTech_itiva_outbound.pl fails with Illegal mix
                    of collations
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: gmcharlt at gmail.com
          Reporter: larry at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

In the big bug fix to clean up UTF8 (bug 11944), the default collation was set
to utf8_unicode_ci. However on sites that predate that change, the overduerules
table may still use utf8_general_ci. This leads to the following error when
running the cronjob TalkingTech_itiva_outbound.pl:

DBD::mysql::st execute failed: Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
[for Statement "SELECT borrowers.borrowernumber, borrowers.cardnumber,
borrowers.title as patron_title, borrowers.firstname, borrowers.surname,
.... [snip] ....
"] at /usr/share/koha/bin/cronjobs/thirdparty/TalkingTech_itiva_outbound.pl
line 230.

The problem is fixed manually by altering table overduerules and changing its
collate setting. However, perhaps there should be a fix in updatedatabase.pl to
change the collate if the table is still using the old value.

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