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

Reply via email to