OOPS setting account as answer contact

[Diogo Matsubara]

OOPS-668E1595 shows that a DB constraint was triggered setting the answer contact for the ava-bzr project.

 2 IntegrityError: ERROR: duplicate key violates unique constraint "personlanguage_person_key" INSERT INTO PersonLanguage (person, language) VALUES (1537687, 119)

[Curtis Hovey (sinzui)]

This may relate to several EN variants set in the user's browser.

    HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.9,de-CH;q=0.8,de;q=0.6,de-DE;q=0.5,en-GB;q=0.4,en-us;q=0.3,en;q=0.1

en-US, en-us, and en are all EN in Launchpad.

utilities.geoip.RequestPreferredLanguages should use a set() instead of a list()
to ensure each language that is looked up by code is unique.

I'm setting this to confirmed because I think we can easily write a test to confirm this OOPS.

[Curtis Hovey (sinzui)]

The first and last items in the the example HTTP_ACCEPT_LANGUAG are the problem. RequestPreferredLanguages returns both as en. Switching to a set is a simple fix.

[Launchpad QA Bot (lpqabot)]

Fixed in stable r11549 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11549>.