Why The "UNIQUE constraint failed" on loading text files?

[tman2000]

Everything was working fine with my mod until I migrated the text folder to text/en_us, then updated the registries in the .modinfo file.

Now, it's telling me there's a UNIQUE constraint failed. It's also showing that the file is containing old text strings that I have updated and saved. I even rebooted my computer. What's the cause of this? Why did it suddenly start happening?

 

[The_goggles_do_nothing]

You might be loading the file twice. Check the -current, -persists, and always to see if it's duplicated.

 

[LilBudyWizer]

Just in general the key on the table you're updating doesn't allow duplicates. That's what the unique constraint is, a qualification on the key. You're either inserting when you should be updating or inserting the same key multiple times. As above loading the file twice or you cut & paste and missed changing the key when you did so.