6
Replies
Conversion failed wth the following error in
'pse-conversion-log_My Catalog PSE 11.txt'
'An error was encountered in the sqlite database: UNIQUE constraint failed: db_change_timestamp_table.change_id
conversion log: Conversion Failed'
I tried opening the catalog file in DB Browser for SQLite. Looking at the db_change_timestamp_table, there are no duplicate change_ids, so I'm not sure why this error would be happening.
By @patrickl27083915
Same error message here:
In that case, there was indeed a duplicate time stam in the database and the poster was able to remove it.
It might help if you could find the error jin the logs of the organizer as was reported by the other poster.
Also, a screenshot of the table like what I did would conferm the absence of duplicates.
Using the following statement
select *, count(*) duplicates
from db_change_timestamp_table
group by change_id
having duplicates > 1
There are no duplicate change_id records.
If you're talking about duplicate change_timestamp_table records with different change_ids, then yes those exist
select change_date_time, count(*) duplicates
from db_change_timestamp_table
group by change_date_time
having duplicates > 1
1) I have tried repairing and it says there is nothing to repair.
2) I tried putting the catalog db file in a new blank catalog folder, but this still gives the same unique change_id error
By @patrickl27083915
Hi Patrick,
I am not a sql expert like you, so I have different questions about your situation.
1 - I am assuming that the old catalog is still working in the old PSE version, and that it does not need to be 'repaired'
2 - The workaround I have suggested to create a new 'light' catalog db file may work as expected except for the impossibility to be converted (same error message) ?
We don't know the real source of the error message in your case or in the other conversation. It could be a programming error in the conversion module or an unexpected external config situation (hardware or software). Such errors are not likely to be recognized by 99% of the PSE users without an explicit error message; searching in the error log files is not common. Did you get an explicit message yourself?
Getting the attention of the Elements team requires that the bug be frequent enough and reproducible. Here it may be relatively frequent but hidden among the generic 'conversion failure' messages and anyway there is no clear suspicion between coding error or random config situation.
AdChoices