[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

--- Comment #45 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Tomás Cohen Arazi from comment #41)
> 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.

I tried with both docker-compose.mysql8.0.yml and
docker-compose.mariadb_latest.yml, but cannot make it fails. Which version do
you have?

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