Closed Bug 1690978 Opened 8 months ago Closed 1 month ago

IntegrityError: new row for relation "base_locale" violates check constraint


(Webtools Graveyard :: Pontoon, defect, P2)


(Not tracked)



(Reporter: elforastero, Unassigned)




(1 file)

Attached file log.txt

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36

Steps to reproduce:

When syncing locales from a GH repo I got an IntegrityError. All translations disappeared from the Resources tab.

Hi elforastero, by default Pontoon uses en-US as the source locale, which looking at the logs you've also selected as the locale to translate into.

Could you please try to set up and sync a new project, without en-US?

If that's indeed the problem here, we should at least fail more gracefully and eventually make it possible to translate to en-US.

Flags: needinfo?(elforastero)
See Also: → 1598324

What do you mean by setting up a new project without en-US?

I already had a synched project with "English" and "Russian" locales. I changed some translations and pushed them to GH.

And then it just stopped working when I pressed "Sync" in project settings.

Flags: needinfo?(elforastero)
Duplicate of this bug: 1697650
Priority: -- → P2

Setting needinfo for mathjazz on comment 2, because it sounds like elforastero was looking for some clarification on setting up a new project without en-US.

Flags: needinfo?(m)

Thanks for the ping, mconley!

And sorry for the late response, elforastero! Your question fell through the cracks unintentionally. :/

Yes, it's possible that you set up a project with the English locale. But it will fail in some places, e.g. when you add new strings.

Flags: needinfo?(m)
Ever confirmed: true
*This bug has been moved to GitHub.*

*Please check it out on*
Closed: 1 month ago
Resolution: --- → MOVED
Product: Webtools → Webtools Graveyard
You need to log in before you can comment on or make changes to this bug.