search

AntonyCorbett / JWLMerge

Utility to merge jwlibrary backup files
MIT License
198 stars 33 forks source link

With Tags ticked file merge files fails to create #43

Closed IDSAU closed 3 years ago

IDSAU commented 3 years ago
  1. Exported from each device .jwlibrary backup
  2. Load JW Merge (great tool thanks)
  3. Drop in 3 files to merge 2021-04-14 (1) As shown in image when Tags is ticked, but no merge files is created.

2021-04-14 (2) As shown in image when Tags is not ticked, the merge files is created.

It seems to be an issue with my Tags, but unsure how I can fix this.

AntonyCorbett commented 3 years ago

@IDSAU First check that you are using the latest version of JwlMerge. If you are, please post the log file which is in Documents\JWLMerge\Logs

IDSAU commented 3 years ago

Thanks for reply log-20210414.txt

Latest Version JWLMerge 1.1.0.7

AntonyCorbett commented 3 years ago

I can see that there was an error merging the location data. Would it be possible to send me the backup files please? It would only be me who looks at them and I would delete them asap.

AntonyCorbett commented 3 years ago

@IDSAU Thanks for the files. Identified as a corruption in one of the source databases. The Location table contains 2 rows that violate one of the databases unique constraints. These must have been inserted before the constraint was added to the database in a JW Library upgrade.

AntonyCorbett commented 3 years ago

Fix is to perform a source validation check, stripping out "duplicate" Locations rows if needed.