Hi David, I would like to help you, but please can you send some of your records / rows from the table where you find the duplicates ? Also after the erases from the problematic records etc. you said that do you try to continue the upgrade but with the same error ? if yes then we should check also for other tables in my opinion, if you can provide an sql to reproduce it somehow ( without records, authorities or members ) would be useful to find out what happened. George -----Original Message----- From: David L. Whelchel <dlwhelchel@outlook.com> Sent: Monday, December 6, 2021 10:51 PM To: David L. Whelchel <dlwhelchel@outlook.com>; gveranis@dataly.gr Cc: koha <koha@lists.katipo.co.nz> Subject: RE: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067 Hi,, Is there any update on this problem. I will need to roll back if not with the need to add more than 100 volumes back in. Thanks --Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel@pullman.com -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of David L. Whelchel Sent: Sunday, December 5, 2021 9:23 AM To: gveranis@dataly.gr Cc: koha <koha@lists.katipo.co.nz> Subject: Re: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067 Good morning George, Yes I did try both the web installer and the cli. I received the same error message. Thanks for your help. --Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel@pullman.com -----Original Message----- From: gveranis@dataly.gr <gveranis@dataly.gr> Sent: Saturday, December 4, 2021 3:27 PM To: David L. Whelchel <dlwhelchel@outlook.com> Cc: koha <koha@lists.katipo.co.nz>; Jonathan Druart <jonathan.druart@bugs.koha-community.org> Subject: Re: [Koha] Error in step - Upgrade to 21.06.00.012 [10:59:41]: Bug 15067 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@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@pullman.com
-----Original Message----- From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Sent: Friday, December 3, 2021 2:22 AM To: gveranis@dataly.gr Cc: David L. Whelchel <dlwhelchel@outlook.com>; koha <koha@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@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%2Fdata ly.gr%2F&data=04%7C01%7C%7C36f2a1704eb24c9acc3508d9b77d8963%7C84d f9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637742572080420911%7CUnknown% 7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJ XVCI6Mn0%3D%7C3000&sdata=JAxGc4YARq4U%2Fmd0sZkcA2dJSfPzDwwzRdj60t 0%2BeUM%3D&reserved=0
-----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of David L. Whelchel Sent: Thursday, December 2, 2021 9:12 PM To: koha (koha@lists.katipo.co.nz) <koha@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@pullman.com
_______________________________________________
Koha mailing list https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha- community.org%2F&data=04%7C01%7C%7C36f2a1704eb24c9acc3508d9b77d89 63%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637742572080420911%7C Unknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1 haWwiLCJXVCI6Mn0%3D%7C3000&sdata=buIaWAiC70hNFu3s0kBlKQ%2BU3LjWI5 pF%2BtBRzxqYK%2Bk%3D&reserved=0 Koha@lists.katipo.co.nz Unsubscribe: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist s.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7C%7C36f2 a1704eb24c9acc3508d9b77d8963%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7 C0%7C637742572080420911%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiL CJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ZAFCfA tVl69ihAIUsqgpkrhp7rzSgB5UwmWD5YkSgJk%3D&reserved=0
_______________________________________________
Koha mailing list https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha- community.org%2F&data=04%7C01%7C%7C36f2a1704eb24c9acc3508d9b77d89 63%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637742572080420911%7C Unknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1 haWwiLCJXVCI6Mn0%3D%7C3000&sdata=buIaWAiC70hNFu3s0kBlKQ%2BU3LjWI5 pF%2BtBRzxqYK%2Bk%3D&reserved=0 Koha@lists.katipo.co.nz Unsubscribe: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist s.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7C%7C36f2 a1704eb24c9acc3508d9b77d8963%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7 C0%7C637742572080420911%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiL CJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ZAFCfA tVl69ihAIUsqgpkrhp7rzSgB5UwmWD5YkSgJk%3D&reserved=0
_______________________________________________ Koha mailing list https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-communi... Koha@lists.katipo.co.nz Unsubscribe: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katip...