[Koha-bugs] [Bug 22887] authorised_values is missing a unique constraint on category + authorised_value

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

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

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |tomascohen at gmail.com
           Keywords|                            |additional_work_needed

--- Comment #41 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Got this:

kohadev-koha at 156b126f55d3:/kohadevbox/koha$ perl
installer/data/mysql/updatedatabase.pl
Upgrade to 19.12.00.068 done [19:57:44]: Bug 21190 - Add prefs AuthFailureLog
and AuthSuccessLog
Upgrade to 19.12.00.069 done [19:57:44]: Bug 22784 - Add a new
suggestions.archived column
Upgrade to 19.12.00.070 done [19:57:44]: Bug 22774 - Limit purchase suggestion
in a specified time period
DBD::mysql::db selectall_arrayref failed: Non-grouping field 'c' is used in
HAVING clause [for Statement "
            SELECT category, authorised_value, COUNT(concat(category, ':',
authorised_value)) AS c
            FROM authorised_values
            GROUP BY category, authorised_value
            HAVING c > 1
        "] at installer/data/mysql/updatedatabase.pl line 21576.
Can't use an undefined value as an ARRAY reference at
installer/data/mysql/updatedatabase.pl line 21582.

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