PlaceTable Error 11 malformed
Relatively new user of RM (8.1.2), built a ton of my tree previously on FamilySearch, found a Python script to scrape a GEDCOM, imported into RM8 a month ago. Tools and knowledge here has helped me clean up the ugly data from the import. Now I'm onto cleaning Places. The PlaceClean tool in RM8 is helpful, but due to so many issues, I thought it would be best to start with some SQL.
I have many instances of "USA" and "United States of America", and I want to consolidate/standardize on just "United States". I'm not a SQL expert, so some Google-foo has led me to this:
UPDATE PlaceTable SET Name = REPLACE(Name, ', USA', ', United States') WHERE PlaceType = 0;
Unfortunately, it fails to execute and results in SQLite3 Error 11 - database disk image is malformed. Note that running RM8's database tools (Test Integrity, Rebuild Indexes, Clean Phantom) all execute fine with no reported errors. Based on the info at https://sqlitetoolsforrootsmagic.com/corrupt-database-recovery/ I did a Drag-and-Drop to a new database, which resulted in significantly different database statistics (600 less (3%) places, 30k more (30%) Citations). After DNDing to a new file, executing the same command results in the same error. Yes, I have RMNOCASE installed in SQLiteSpy. I have not yet moved onto the next database recovery steps (again, RM8 seems to continue to function properly).
Any additional help would be appreciated,
Chad
Well, thanks to Tom H who replied on FB... running REINDEX; and then the above query worked perfectly. And, I also learned there's a RM Search and Replace. Whoops.