Duplicate entry in select option

[blanco]

I have a select option were I try to add a new value with a specific id and title and getting this error message: 

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Håbo kommun-114' for key 'title'

The thing is that there are no other item in the list with that id nor title. It's a list of all the counties in sweden which has specific id numbers. There are 290 of them, and all of them gets imported except one, and that is Håbo kommun with the id number 0305. 

I can't even see anything in the database table fieldtype_options. there is no item with that id. What could be causing this? 

Thanks!

 

 

[wbmnfktr]

I played around with a fresh install of ProcessWire and tried to replicate your issue.

There are a few things I found:

1. the select/option ID needs to be unique (obviously)
2. the select/option value can be the same between different options
3. the select/option title needs to be unique as well

While this works:

1=0305|Håbo kommun 114 A
2=0305|Håbo kommun 114 B
3=0305|Håbo kommun 114 C

This doesn't:

1=0305|Håbo kommun 114
2=0306|Håbo kommun 114
3=0307|Håbo kommun 114

See the differences there?

So... the easiest explanation would be that there at least one other entry with the same title.

My testing setup looks like this:

 

If you like drop me a PM and send me the list of all counties you have and I'll test it here.

[a_dent]

@blanco could it be related to the Swedish characters? There should be one "Håbo kommun" and one "Habo kommun" in your list of Swedish municipalities. 

[blanco]

@wbmnfktr 

I have attached the complete list of all the entries. 

kommuner2.txt

@a_dent

I don't think so as that is not the only municipal with swedish characters ?

[edit] Dude, you are probably correct! There is a "Habo kommun" in the list, I didn't even think about that! I'm gonna try and add it with a slightly different name.