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

[gveranis at dataly.gr]

Hi David,

After you empty or delete the duplicate records , do you try to  
continue the upgrade ?
Either from web installer or cli ?

George
Παραθέτοντας από "David L. Whelchel" <dlwhelchel at outlook.com>:

> Hi Jonathan and George,
>
> I went through the language tables and removed any apparent  
> duplications. I also emptied out the language_descriptions table  
> with no success. Thanks Jonathan for opening the bug ticket.  
> Fortunately my system is for internal institutional use and I can be  
> patient.
>
> I appreciate the quick response and help from this group!!!
>
> --Dave
> -------------------------------------------------------------------------------
> David L. Whelchel
> 725 SE Derby Street
> Pullman, WA 99163
> whelchel at pullman.com
>
> -----Original Message-----
> From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
> Sent: Friday, December 3, 2021 2:22 AM
> To: gveranis at dataly.gr
> Cc: David L. Whelchel <dlwhelchel at outlook.com>; koha  
> <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Error in step - Upgrade to 21.06.00.012  
> [10:59:41]: Bug 15067
>
> 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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdataly.gr%2F&data=04%7C01%7C%7C6346ea2f184f4fd2be1a08d9b646d0de%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637741237538679905%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=1E7REuldCdrH42CCaCgBhjqjXZ7sZfkwenXK1UWhGIs%3D&reserved=0
>>
>> -----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   
>> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=04%7C01%7C%7C6346ea2f184f4fd2be1a08d9b646d0de%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637741237538679905%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9md02Raw3hMt5g7N0zGXPsjC9fVMPRxMzIWFehLnmKI%3D&reserved=0  
>> Koha at lists.katipo.co.nz
>> Unsubscribe:  
>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7C%7C6346ea2f184f4fd2be1a08d9b646d0de%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637741237538679905%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=IQcqS7JgTRLpzeL8ek6BMKcGF5nb9A5bp0nuGfH5l1U%3D&reserved=0
>>
>> _______________________________________________
>>
>> Koha mailing list   
>> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=04%7C01%7C%7C6346ea2f184f4fd2be1a08d9b646d0de%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637741237538679905%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9md02Raw3hMt5g7N0zGXPsjC9fVMPRxMzIWFehLnmKI%3D&reserved=0
>> Koha at lists.katipo.co.nz
>> Unsubscribe:  
>> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7C%7C6346ea2f184f4fd2be1a08d9b646d0de%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637741237538679905%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=IQcqS7JgTRLpzeL8ek6BMKcGF5nb9A5bp0nuGfH5l1U%3D&reserved=0