Re: [darktable-user] Cannot upgrade database
Hi Patrick, Thanks for your help. On Fri, 2020-08-14 at 12:48 -0400, Patrick Shanahan wrote: > * Tony Arnold < > tony.arn...@manchester.ac.uk > > [08-14-20 11:46]: > > I've not used DT for while and now when I try to run it I get asked > > if > > I want to upgrade the database, but this fails. > > > > Running DT from a terminal, I get the following messages: > > > > $ darktable > > [init] can't rename i to images > > [init] error in view empty_film_rolls: no such table: main.images > > [init] database `library.db' couldn't be upgraded from version 21 > > to > > 30. aborting > > ERROR : cannot open database > > > > I have DT version 3.2.1 installed. > > guessing here but perhaps someone more knowledgeable will responed. > > you have skipped several versions of dt? Yes. DT has updated from the Ubuntu repository but I hadn't rune the new versions so the databases didn't get updated/ > make a backup of your library.db > run >sqlite3 ./library.db "PRAGMA integrity_check" >sqlite3 ./library.db "VACUUM" > > and try again with the new library.db This made no difference at all! > else you might try to install an earlier version dt which is later > than > your previous version. > ie: previous was 2.6.x, install 3.0 > and try with your library before 3.2.1 I reverted my database to data.db-pre-3.0.1 and library.db-pre-3.0.1 and then installed dt 3.0.1 which was still available in the repos. This converted the database and ran successfully, however, 3.2.1 still failed when converting the databases. I then downloaded and built 3.0.2 which also ran against the 3.0.1 database, but I was not prompted for any database conversion. 3.2.1 still failed to convert the database, so I'm thinking there is another version between 3.0.2 and 3.2.1 but I cannot find one anywhere. Is there another version? And if so where can I download it from? Or any other ideas as to where to go from here? Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | Office 1, Kilburn Building | The University of Manchester | Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 0039 darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.or
Re: [darktable-user] Cannot upgrade database
* Tony Arnold [08-14-20 14:39]: > Hi Patrick, [...] > This converted the database and ran successfully, however, 3.2.1 still > failed when converting the databases. > > I then downloaded and built 3.0.2 which also ran against the 3.0.1 > database, but I was not prompted for any database conversion. > > 3.2.1 still failed to convert the database, so I'm thinking there is > another version between 3.0.2 and 3.2.1 but I cannot find one anywhere. > > Is there another version? And if so where can I download it from? > > Or any other ideas as to where to go from here? if you do not have a very large library.db, you could delete it (backup of course) and then import your images. All the pertinent data is contained within the accompanying xmp files. short of that, I do not have any idea. Just hope someone else chimes in. gud luk, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org
Re: [darktable-user] Cannot upgrade database
* Tony Arnold [08-14-20 11:46]: > I've not used DT for while and now when I try to run it I get asked if > I want to upgrade the database, but this fails. > > Running DT from a terminal, I get the following messages: > > $ darktable > [init] can't rename i to images > [init] error in view empty_film_rolls: no such table: main.images > [init] database `library.db' couldn't be upgraded from version 21 to > 30. aborting > ERROR : cannot open database > > I have DT version 3.2.1 installed. guessing here but perhaps someone more knowledgeable will responed. you have skipped several versions of dt? make a backup of your library.db run sqlite3 ./library.db "PRAGMA integrity_check" sqlite3 ./library.db "VACUUM" and try again with the new library.db else you might try to install an earlier version dt which is later than your previous version. ie: previous was 2.6.x, install 3.0 and try with your library before 3.2.1 gud luk, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org