On Sat, 6 Nov 2021 at 18:23, Butch Carpenter <csc...@gmail.com> wrote:
> > On 11/6/21 12:27 PM, Patrick Shanahan wrote: > > * Butch Carpenter <csc...@gmail.com> <csc...@gmail.com> [11-06-21 12:12]: > > Here's what I get from the integrity check: > > sqlite3 ~/.config/darktable/library.db "PRAGMA integrity_check" > ok > > Then when I start darktable from a terminal and respond with "upgrade > database", here's the results: > > /usr/bin/darktable %U > [init] can't drop table images_old > [init] FOREIGN KEY constraint failed > [init] database `library.db' couldn't be upgraded from version 32 to 34. > aborting > ERROR : cannot open database > > My concern here would be the table 'images_old' and why it can't be dropped. I don't think such a table is normally present. I'd take a look at the db with a suitable sqlite browser and see if it's there and what the foreign key constraints are on it. Possibly try and drop the table manually (take a back up first!) Just a thought. Regards, Tony. > > ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org