* Cecil Carpenter <[email protected]> [11-06-21 00:17]: > I use the darktable ppa ubuntuhandbook1/darktable. After the latest > update to 3.6.1, when I start darktabke, I get a block that says the > following: > > the database schema has to be upgraded for > > /home/butch/.config/darktable/library.db > > this might take a long time in case of a large database > > do you want to proceed or quit now to do a backup > > There are two options: (1) close darktable (2) upgrade database > > I choose option 2 and nothing happens. > > When I run the command to start darktable in a terminal, I get the > following: > > /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 > > I have never done anything to the database other thsn to use darktable. > Can someone tell me what is going on here (I understand foreign key > constraints, but , as I said esarlier, I have never modified the > database manually ) and how to fix this so I can use darktable again?
backup your library.db then issue the following sqlite3 ~/.config/darktable/library.db "PRAGMA integrity_check" if you find a problem, then issue sqlite3 ~/.config/darktable/library.db "VACUUM" if that/those do not help, post results from the PRAGMA check here for others to see. gudluk -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode What sort of day was it? A day like all days, filled with those events that alter and illuminate our times... all things are as they were then, but were you there? ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
