[Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067

[gveranis at dataly.gr]

Hi Jonathan,

My problematic records were something like that on table language_description

('Laoo','script','en','Laotisch',183)
('Laoo','script','en','Laotisch',184)

and the error was "ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do  
failed: Duplicate entry 'Laoo-script-en' for key 'uniq_lang' at  
/usr/share/koha/lib/C4/Installer.pm line 738"

I hope to help somehow.

Best regards,
George Veranis

Παραθέτοντας από Jonathan Druart <jonathan.druart at bugs.koha-community.org>:

> Hello David, George,
>
> Did you keep track of the problematic entries?
>
> Regards,
> Jonathan
>
> Le ven. 3 déc. 2021 à 09:53, <gveranis at dataly.gr> a écrit :
>>
>> Hi Dave,
>>
>> I had similar problem and I found that on the table   
>> "language_descriptions" was the problem , because on bug 15607 is  
>> trying to generate unique indexes and if you have a double value  
>> there you have a problem like that you described. You should remove  
>> the duplicate value and re-run your upgrade though web installer.
>> Also I suggest you to check for double values other language_* tables.
>>
>> Regards,
>> George Veranis
>> Dataly Tech
>> https://dataly.gr
>>
>> -----Original Message-----
>> From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of David L. Whelchel
>> Sent: Thursday, December 2, 2021 9:12 PM
>> To: koha (koha at lists.katipo.co.nz) <koha at lists.katipo.co.nz>
>> Subject: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]:  
>> Bug 15067
>>
>> Hi all,
>>
>> I have received this error when upgrading from 21.06.00.012  to  
>> 21.11. I do not see any information in the bug list or lists.
>>
>> ---
>> Updating database structure
>> Update errors :
>>
>> Upgrade to 21.06.00.012 [10:59:41]: Bug 15067 - Add missing languages
>> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed:  
>> Duplicate entry 'IN-region' for key 'uniq_lang' at  
>> /usr/share/koha/lib/C4/Installer.pm line 738
>> ----
>>
>> Any help would be appreciated.
>>
>> --Dave
>> -------------------------------------------------------------------------------
>> David L. Whelchel
>> 725 SE Derby Street
>> Pullman, WA 99163
>> whelchel at pullman.com
>>
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha