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 > > > ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
