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

Thu Dec 9 07:51:08 NZDT 2021

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
whelchel at pullman.com

-----Original Message-----
From: gveranis at dataly.gr <gveranis at dataly.gr> 
Sent: Tuesday, December 7, 2021 4:14 AM
To: 'David L. Whelchel' <dlwhelchel at outlook.com>
Cc: 'koha' <koha at 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 <dlwhelchel at outlook.com>
Sent: Monday, December 6, 2021 10:51 PM
To: David L. Whelchel <dlwhelchel at outlook.com>; gveranis at dataly.gr
Cc: koha <koha at 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 at pullman.com

-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of David L. Whelchel
Sent: Sunday, December 5, 2021 9:23 AM
To: gveranis at dataly.gr
Cc: koha <koha at 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 at pullman.com

-----Original Message-----
From: gveranis at dataly.gr <gveranis at dataly.gr>
Sent: Saturday, December 4, 2021 3:27 PM
To: David L. Whelchel <dlwhelchel at outlook.com>
Cc: koha <koha at lists.katipo.co.nz>; Jonathan Druart <jonathan.druart at 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 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%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 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%7C36f2a1704eb24c9acc3508d9b77d89
>> 63%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637742572080420911%7C
>> Unknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1
>> haWwiLCJXVCI6Mn0%3D%7C3000&sdata=buIaWAiC70hNFu3s0kBlKQ%2BU3LjWI5
>> pF%2BtBRzxqYK%2Bk%3D&reserved=0
>> Koha at 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 at 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 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%7C7aab34c58ade435c2a3c08d9b97b1ce8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637744760690594781%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=vUxF0QvMOFQ7xANHAhz7X%2BpX6XWPNhYdupQtoO7S758%3D&reserved=0