* Butch Carpenter <[email protected]> [11-06-21 14:25]: > > On 11/6/21 12:27 PM, Patrick Shanahan wrote: > > * Butch Carpenter <[email protected]> [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 > >> > >> On 11/6/21 10:01 AM, Patrick Shanahan wrote: > >>> sqlite3 ~/.config/darktable/library.db "PRAGMA integrity_check" > > 1. normally when one asks asks a question "on list", the conversation > > should continue on the list as others may be interested or may have better > > answers to the question. I have cc'd this to the list. > > > > 2. did you do the VACUUM step > > > > 3. why start darktable with "%U"? > > > > 4. are there still instances of darktable running (ERROR : cannot open > > database) > > ps aux | grep darktable > > ps aux | library.db > > > > if either show an existing instance, kill that instance (darktable > > first) > > 1. Sorry about the last reply. I accidentally hit Reply instead of > Reply All. > > 2. I did the Vacuum step with no change. > > 3. The install created a Menu item with that command to launch darktable. > > 4. Both processes were running. I killed them in the order you recommended. > > I still get > > /usr/bin/darktable > [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
what are the permissions on your db ls -la /home/<user>/.config/darktable/library.db do you have a great number of photos in your library? do you save the xmp files along side your images? you might remove the library.db and reimport your images, if you have the xmp files, they contain your editing history. -- (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]
