* 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) -- (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]
