0.7.2->0.26.4 shotwell DB upgrade fails: Db.vala:308: upgrade_database: adding comment column to VideoTable
Submitted by Spike
Link to original bug (#790469)
Description
After OS upgrade from Ubuntu 10.04.4 LTS to Lubuntu 16.04 LTS including shotwell upgrade from 0.7.2 to 0.26.4 shotwell startup fails. shotwell.log contains:
main.vala:385: Shotwell Photo Manager 0.26.4 (5bd7d9a7) Db.vala:71: Upgrading database from schema version 8 to 20 Db.vala:308: upgrade_database: adding comment column to VideoTable
An earlier attempt to debug same photo.db with 0.26.3 shows:
ERROR:/build/shotwell-acRo6P/shotwell-0.26.3/src/db/DatabaseTable.vala:341:database_table_add_column: assertion failed: (res == Sqlite.OK)
Viewing shotwell database with DB browser for SQLite shows only EventTable, PhotoTable, TagTable, and VersionTable--no VideoTable.
Creating a fresh shotwell 0.26.4 database includes several more tables including VideoTable. ie it seems shotwell upgrade program assumes VideoTable already exists.
Version: 0.26.x
Resolution: RESOLVED FIXED