Hi George, Thank you, here is the dump of the table. I did remove items in separate tests including trying to remove specific problematic entries like the Arab Script below and then all the entries. It seams that there is an index somewhere that needs to be rebuilt. I am proficient in some parts of Koha but not all and see my weakness here in this one!!
subtag type lang description id opac i en OPAC 1 opac i fr OPAC 2 intranet i en Staff Client 3 intranet i fr ???? 4 prog t en Prog 5 prog t fr Prog 6 ar language ar لعربية 7 ar language en Arabic 8 ar language fr Arabe 9 hy language hy Հայերեն 10 hy language en Armenian 11 hy language fr Armenian 12 bg language bg Български 13 bg language en Bulgarian 14 bg language fr Bulgare 15 zh language zh 中文 16 zh language en Chinese 17 zh language fr Chinois 18 cs language cs Čeština 19 cs language en Czech 20 cs language fr Tchèque 21 da language da Dansk 22 da language en Danish 23 da language fr Danois 24 nl language nl Nederlands 25 nl language en Dutch 26 nl language fr Néerlandais 27 en language en English 28 en language fr Anglais 29 fi language fi Suomi 30 fi language en Finnish 31 fr language en French 32 fr language fr Français 33 lo language lo ພາສາລາວ 34 lo language en Lao 35 de language de Deutsch 36 de language en German 37 de language fr Allemand 38 el language el Ελληνικά 39 el language en Greek, Modern [1453- ] 40 el language fr Grec Moderne (Après 1453) 41 he language he עִבְרִית 42 he language en Hebrew 43 he language fr Hébreu 44 hi language hi हिन्दी 45 hi language en Hindi 46 hi language fr Hindi 47 hu language hu Magyar 48 hu language en Hungarian 49 hu language fr Hongrois 50 id language id Bahasa Indonesia 51 id language en Indonesian 52 id language fr Indonésien 53 it language it Italiano 54 it language en Italian 55 it language fr Italien 56 ja language ja 日本語 57 ja language en Japanese 58 ja language fr Japonais 59 ko language ko 한국어 60 ko language en Korean 61 ko language fr Coréen 62 la language la Latina 63 la language en Latin 64 la language fr Latin 65 gl language gl Galego 66 gl language en Galician 67 nb language nb Norsk bokmål 68 nb language en Norwegian bokmål 69 nb language fr Norvégien bokmål 70 fa language fa فارسى 71 fa language en Persian 72 fa language fr Persan 73 pl language pl Polski 74 pl language en Polish 75 pl language fr Polonais 76 pt language pt Português 77 pt language en Portuguese 78 pt language fr Portugais 79 ro language ro Română 80 ro language en Romanian 81 ro language fr Roumain 82 ru language ru Русский 83 ru language en Russian 84 ru language fr Russe 85 sr language sr Cрпски 86 sr language en Serbian 87 es language es Español 88 es language en Spanish 89 es language fr Espagnol 90 sv language sv Svenska 91 sv language en Swedish 92 sv language fr Suédois 93 tet language tet Tetun 94 tet language en Tetum 95 th language th ภาษาไทย 96 th language en Thai 97 th language fr Thaï 98 tr language tr Türkçe 99 tr language en Turkish 100 tr language fr Turc 101 uk language uk Українська 102 uk language en Ukrainian 103 uk language fr Ukrainien 104 ur language en Urdu 105 ur language ur اردو 106 Arab script Arab العربية 107 Arab script en Arabic 108 Arab script fr Arabic 109 Cyrl script Cyrl Кирилица 110 Cyrl script en Cyrillic 111 Cyrl script fr Cyrillic 112 Grek script Grek Ελληνικό αλφάβητο 113 Grek script en Greek 114 Grek script fr Greek 115 Hans script Hans 简体字 116 Hans script en Han (Simplified variant) 117 Hans script fr Han (Simplified variant) 118 Hant script Hant 繁體字 119 Hant script en Han (Traditional variant) 120 Hebr script Hebr אָלֶף־בֵּית עִבְרִי 121 Hebr script en Hebrew 122 Laoo script lo Lao 123 Laoo script en Lao 124 CA region en Canada 125 DK region dk Danmark 126 FR region fr France 127 FR region en France 128 NZ region en New Zealand 129 GB region en United Kingdom 130 US region en United States 131 nn language nb Norsk nynorsk 132 nn language nn Norsk nynorsk 133 nn language en Norwegian nynorsk 134 nn language fr Norvégien nynorsk 135 ar language de Arabisch 136 hy language de Armenisch 137 bg language de Bulgarisch 138 zh language de Chinesisch 139 cs language de Tschechisch 140 da language de Dänisch 141 nl language de Niederländisch 142 en language de Englisch 143 fi language de Finnisch 144 fr language de Französisch 145 lo language fr Laotien 146 lo language de Laotisch 147 el language de Griechisch (Modern 1453-) 148 he language de Hebräisch 149 hi language de Hindi 150 hu language de Ungarisch 151 id language de Indonesisch 152 it language de Italienisch 153 ja language de Japanisch 154 ko language de Koreanisch 155 la language de Latein 156 gl language fr Galicien 157 gl language de Galizisch 158 nb language de Norwegisch bokmål 159 nn language de Norwegisch nynorsk 160 fa language de Persisch 161 pl language de Polnisch 162 pt language de Portugiesisch 163 ro language de Rumänisch 164 ru language de Russisch 165 sr language fr Serbe 166 sr language de Serbisch 167 es language de Spanisch 168 sv language de Schwedisch 169 tet language fr Tétoum 170 tet language de Tetum 171 th language de Thailändisch 172 tr language de Türkisch 173 uk language de Ukrainisch 174 ur language fr Ourdou 175 ur language de Urdu 176 ca language es Catalán 177 ca language en Catalan 178 ca language fr Catalan 179 ca language ca Català 180 ca language de Katalanisch 181 hr language hr Hrvatski 182 hr language en Croatian 183 hr language fr Croate 184 hr language de Kroatisch 185 am language am አማርኛ 186 am language en Amharic 187 az language az Azərbaycan dili 188 az language en Azerbaijani 189 be language be Беларуская мова 190 be language en Byelorussian 191 bn language bn বাংলা 192 bn language en Bengali 193 eu language eu Euskera 194 eu language en Basque 195 fo language fo Føroyskt 196 fo language en Faroese 197 is language is Íslenska 198 is language en Icelandic 199 kn language kn ಕನ್ನಡ 200 kn language en Kannada 201 km language km ភាសាខ្មែរ 202 km language en Khmer 203 ku language ku کوردی 204 ku language en Kurdish 205 ku language fr Kurde 206 ku language de Kurdisch 207 ku language es Kurdo 208 mi language mi Te Reo Māori 209 mi language en Maori 210 mn language mn Mонгол 211 mn language en Mongolian 212 mr language mr मराठी 213 mr language en Marathi 214 ms language ms Bahasa melayu 215 ms language en Malay 216 ne language ne नेपाली 217 ne language en Nepali 218 pbr language pbr Ekipangwa 219 pbr language en Pangwa 220 prs language prs درى 221 prs language en Dari 222 rw language rw Ikinyarwanda 223 rw language en Kinyarwanda 224 sd language sd سنڌي 225 sd language en Sindhi 226 sk language sk Slovenčina 227 sk language en Slovak 228 sl language sl Slovenščina 229 sl language en Slovene 230 sq language sq Shqip 231 sq language en Albanian 232 sw language sw Kiswahili 233 sw language en Swahili 234 ta language ta தமிழ் 235 ta language en Tamil 236 tl language tl Tagalog 237 tl language en Tagalog 238 vi language vi Tiếng Việt 239 vi language en Vietnamese 240 Armn script Armn Հայոց այբուբեն 241 Armn script en Armenian 242 Ethi script Ethi ግዕዝ 243 Ethi script en Ethiopic 244 Jpan script Jpan 漢字 245 Jpan script en Japanese 246 Knda script Knda ಕನ್ನಡ ಲಿಪಿ 247 Knda script en Kannada 248 Kore script Kore 한글 249 Kore script en Korean 250 AL region en Albania 251 AL region sq Shqipërisë 252 AZ region en Azerbaijan 253 AZ region az Azərbaycan 254 BE region en Belgium 255 BE region nl België 256 BR region en Brazil 257 BR region pt Brasil 258 BY region en Belarus 259 BY region be Беларусь 260 CA region fr Canada 261 CH region en Switzerland 262 CH region de Schweiz 263 CN region en China 264 CN region zh 中国 265 CZ region en Czech Republic 266 CZ region cs Česká republika 267 DE region en Germany 268 DE region de Deutschland 269 DK region en Denmark 270 ES region en Spain 271 ES region es España 272 FI region en Finland 273 FI region fi Suomi 274 FO region en Faroe Islands 275 FO region fo Føroyar 276 GR region en Greece 277 GR region el Ελλάδα 278 HR region en Croatia 279 HR region hr Hrvatska 280 HU region en Hungary 281 HU region hu Magyarország 282 ID region en Indonesia 283 ID region id Indonesia 284 IS region en Iceland 285 IS region is Ísland 286 IT region en Italy 287 IT region it Italia 288 JP region en Japan 289 JP region ja 日本 290 KE region en Kenya 291 KE region rw Kenya 292 KH region en Cambodia 293 KH region km កម្ពុជា 294 KP region en North Korea 295 KP region ko 조선민주주의인민공화국 296 LK region en Sri Lanka 297 LK region ta இலங்கை 298 MY region en Malaysia 299 MY region ms Malaysia 300 NE region en Niger 301 NE region ne Niger 302 NL region en Netherlands 303 NL region nl Nederland 304 NO region en Norway 305 NO region ne Noreg 306 NO region nn Noreg 307 PH region en Philippines 308 PH region tl Pilipinas 309 PK region en Pakistan 310 PK region sd پاكستان 311 PL region en Poland 312 PL region pl Polska 313 PT region en Portugal 314 PT region pt Portugal 315 RO region en Romania 316 RO region ro România 317 RU region en Russia 318 RU region ru Россия 319 RW region en Rwanda 320 RW region rw Rwanda 321 SE region en Sweden 322 SE region sv Sverige 323 SI region en Slovenia 324 SI region sl Slovenija 325 SK region en Slovakia 326 SK region sk Slovensko 327 TH region en Thailand 328 TH region th ประเทศไทย 329 TR region en Turkey 330 TR region tr Türkiye 331 TW region en Taiwan 332 TW region zh 台灣 333 UA region en Ukraine 334 UA region uk Україна 335 VN region en Vietnam 336 VN region vi Việt Nam 337 ka language ka ქართული 338 ka language en Georgian 339 ka language fr Géorgien 340 ka language de Georgisch 341 ka language es Georgiano 342 IN region en India 343 IN region bn ভারত 344 IN region en India 345 IN region bn ভারত 346 vi language de Vietnamesisch 347 --Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelc...@pullman.com -----Original Message----- From: gvera...@dataly.gr <gvera...@dataly.gr> Sent: Tuesday, December 7, 2021 4:14 AM To: 'David L. Whelchel' <dlwhelc...@outlook.com> 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 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 <dlwhelc...@outlook.com> Sent: Monday, December 6, 2021 10:51 PM To: David L. Whelchel <dlwhelc...@outlook.com>; gvera...@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 whelc...@pullman.com -----Original Message----- From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of David L. Whelchel Sent: Sunday, December 5, 2021 9:23 AM To: gvera...@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 whelc...@pullman.com -----Original Message----- From: gvera...@dataly.gr <gvera...@dataly.gr> Sent: Saturday, December 4, 2021 3:27 PM To: David L. Whelchel <dlwhelc...@outlook.com> Cc: koha <koha@lists.katipo.co.nz>; Jonathan Druart <jonathan.dru...@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" <dlwhelc...@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 > whelc...@pullman.com > > -----Original Message----- > From: Jonathan Druart <jonathan.dru...@bugs.koha-community.org> > Sent: Friday, December 3, 2021 2:22 AM > To: gvera...@dataly.gr > Cc: David L. Whelchel <dlwhelc...@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, <gvera...@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-boun...@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 >> whelc...@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-community.org%2F&data=04%7C01%7C%7C7aab34c58ade435c2a3c08d9b97b1ce8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637744760690594781%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=S1wNuLEsQuoJjd8S8KsaWt3XTii2DET7sK5RSvvp2cE%3D&reserved=0 Koha@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%7C7aab34c58ade435c2a3c08d9b97b1ce8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637744760690594781%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=vUxF0QvMOFQ7xANHAhz7X%2BpX6XWPNhYdupQtoO7S758%3D&reserved=0 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha