Quote:
Originally Posted by ciscoswitch
Error: duplicate column name: uuid
|
Make a copy of your metadata.db and grab a copy of
SQLiteSpy and try to remove the uuid field. It looks like it's got that field in there, but thinks its an older version of Calibre (that perhaps didn't use that field) and is trying to add it in, but is failing. I've seen initialization code that tries to detect the version of Calibre, then modifies the database the first time it runs. Maybe the uuid field is added at some point as a version upgrade, it added the field, but failed to complete the upgrade and you are stuck halfway? Running now might try to add that field again? The SQL command would be
ALTER TABLE table_name
DROP COLUMN column_name
SQLiteSpy will tell you which table it's in (I think it's books) and the command above may let you drop it (Column name would be uuid). (Just a shot in the dark - Kovid would know if this has any chance of working). You could also check the code - search for uuid and ALTER TABLE commands.