Re: [darktable-user] Darktable will not convert database after upgrade to 3.6.1
On Sat, 6 Nov 2021 at 18:23, Butch Carpenter wrote: > > On 11/6/21 12:27 PM, Patrick Shanahan wrote: > > * Butch Carpenter [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
Re: [darktable-user] Change of email address
Hi, Thanks to everyone who helped me with my question. Unsubscribing my old address and subscribing the new one was the way to go. I found this odd as other mailling lists, mainly ones based on mailman, have a web interface where you can change your subscribed address and I was expecting to see the same for the darktable list. You live and learn! 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.org
Re: [darktable-user] Change of email address
Hi Patrick, That's fine but none of these options show how to change my email address. I get no response from the help address. Regards, Tony. On Thu, 2021-09-09 at 11:29 -0400, Patrick Shanahan wrote: > * Tony Arnold < > tony.arn...@manchester.ac.uk > > [09-09-21 11:27]: > > Does anyone know how to change my email address on this list? Do I > > have to unsubscribe and subscribe with the new address? > > in the email header: > List-Post: darktable-user@lists.darktable.org > > > List-Help: darktable-user+h...@lists.darktable.org > > > List-Subscribe: darktable-user+subscr...@lists.darktable.org > > > List-Unsubscribe: darktable-user+unsubscr...@lists.darktable.org > > > List-Owner: darktable-user+ow...@lists.darktable.org > > > List-Id: darktable user's mailing list < > darktable-user@lists.darktable.org > > > > > -- 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
[darktable-user] Change of email address
Does anyone know how to change my email address on this list? Do I have to unsubscribe and subscribe with the new address? 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] [SOLVED] Cannot upgrade database
On Fri, 2020-08-14 at 15:10 -0400, Patrick Shanahan wrote: > * Tony Arnold < > tony.arn...@manchester.ac.uk > > [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. > I decided to re-import all my images as there didn't seem to be a more elegant solution available. The re-import all went very smoothly and I now have a working DT system. Thanks for the advice Patrick. 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
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
[darktable-user] Fwd: Cannot upgrade database
Odd. I sent the message below over three and a half hours ago but I've still not seen it back in my mailbox. Is this list moderated or does the send not see their own message? Trying again to see what happens. Regards, Tony. Forwarded Message > From: Tony Arnold > To: darktable-user@lists.darktable.org > Subject: Cannot upgrade database > Date: Fri, 14 Aug 2020 10:12:55 +0100 > > 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. > > Any suggestions on how to resolve this? > > 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 > -- 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
[darktable-user] Cannot upgrade database
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. Any suggestions on how to resolve this? 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] darktable 3.0.0 released
Hi Pascal, Fantastic to see such a major release. I'm looking forward to it being available from Pascal's (the other Pascal!) PPA repository for Ubuntu. Regards, Tony. On Tue, 2019-12-24 at 09:08 +0100, Pascal Obry wrote: Hello! We are proud to announce the release of the 3.0 feature release. It is a very important major release with a redesign of many parts. It also brings many new features that have been missing for long time. This new release has more than 3000 modifications since last 2.6.0 release. Just impressive! It is also an important release as new developers have shined in and proposed some amazing features. It is good to see darktable developer's team growing. Thanks a lot to everyone involved! A full description of the release is there: <https://github.com/darktable-org/darktable/releases/tag/release-3.0.0> https://github.com/darktable-org/darktable/releases/tag/release-3.0.0 The Windows and MacOS binaries are already available. The documentation will come a bit later. Enjoy the release and hope everyone will have nice end of year holidays. Best wishes, -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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
[darktable-user] DT 2.6.2 on Cosmic
I saw an announcement of the release of DT 2.6.2 a while ago, but it's not in the PPA for Ubuntu Cosmic yet. Any idea when it might appear? Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] Darktable on a 4K display
René, Does the integrated graphics card support 4K screens fully? Regards,Tony. On Wed, 2018-02-07 at 13:36 +0100, René Seindal wrote: > Hi > > Does anybody use darktable on a 4K display? > > I have tried, and it crashes a lot. Running it from a terminal just > gives the message "Killed". > > The kernel log states that it is an out-of-memory situation. > > It is not a very new computer. Its an Intel NUC with an i5 cpu with > integrated graphics, and 8Gb of ram. > > I've tried to monitor ram usage using top while darktable is > working, > but it never goes over 10% with lots of memory still available. > > There must be some sudden spike in memory allocation that causes the > kernel to run out of memory, that I cannot see using top. > > It almost certainly happens in the pixel pipeline, either when > rendering > a photo for display, or during export. > > If I switch the display to normal FHD 1920x1080 resolution, there are > no > crashes. > -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | Desk 51, Office 2, Kilburn Building | The University of Manchester | Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 0039 signature.asc Description: This is a digitally signed message part smime.p7s Description: S/MIME cryptographic signature
Re: [darktable-user] Red lines and oversized text after Ubuntu 17.04 upgrade
Tobias, On Fri, 2017-04-14 at 16:47 +0200, Tobias Ellinghaus wrote: > Am Freitag, 14. April 2017, 13:15:27 CEST schrieb Tony Arnold: > > [...] > > > I could wait for Pascal to produce a new package, but was hoping > > there > > was a fix I could apply myself. > > Try putting the attached file into ~/.config/darktable/. That's fixed it. Back to the way it was! Many thanks. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] Red lines and oversized text after Ubuntu 17.04 upgrade
Tobias, On Fri, 2017-04-14 at 14:58 +0200, Tobias Ellinghaus wrote: > Am Freitag, 14. April 2017, 09:27:59 CEST schrieb Tony Arnold: > > I've just upgraded to Ubuntu 17.04 and Darktable's borders are now > > thick red > > lines and the text and icons are far too large. > > > > Running Darktable 2.2.4 from the PPA. > > > > Looks like a css issue. Is there a way to fix this? > > You either have a customized CSS file that needs to be updated, or > you are > using darktable built for an older version of Ubuntu. My guess is the > latter, > please check your PPA setting and adapt it to the new Ubuntu version. I've not customised the CSS and there doesn't seem to be a packaged version of Darktable for Ubuntu 17.04 (zesty) yet. Latest is for 16.10 (yakkety). I'm looking here: http://ppa.launchpad.net/pmjdebruijn/darktable-release/ubuntu/dists/ I could wait for Pascal to produce a new package, but was hoping there was a fix I could apply myself. I could also try the development version? Not sure if that fixes the problem. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] image filename and directory
On Thu, 2017-04-13 at 20:59 +, Tony Arnold wrote: > On Thu, 2017-04-13 at 12:32 -0700, darkta...@911networks.com wrote: > > DT 2.2.4 > > > > I'm looking for a full list of the images with their current > > directory. > > > > Looking at library.db, I have found: > > > > images > filename > > > > is the directory in: film_rolls > folders? > > > > and the link: film_rolls.id = images.film_id? > > > > Is there a schema 'floating around' with the various links? > > Yes, the field images.film_id relates to film_rolls.id. With > suitable > select and join functions in SQL, you could get a complete list. The following SQL statement should get you what you want. Run this against 'library.db' select folder,filename from film_rolls,images where images.film_id=film_rolls.id order by folder; HTH. Regards, Tony. > -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] image filename and directory
On Thu, 2017-04-13 at 12:32 -0700, darkta...@911networks.com wrote: > DT 2.2.4 > > I'm looking for a full list of the images with their current > directory. > > Looking at library.db, I have found: > > images > filename > > is the directory in: film_rolls > folders? > > and the link: film_rolls.id = images.film_id? > > Is there a schema 'floating around' with the various links? Yes, the field images.film_id relates to film_rolls.id. With suitable select and join functions in SQL, you could get a complete list. I've not seen a relationship diagram, but one may well exist. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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
[darktable-user] Manual in EPUB format
Is there an EPUB (or other ebook format) version of the darktable manual available? Or how might I go about creating such a version? I ask, as every now and again I take a look at Calibre to organise documents. It can handle PDF docs, but I think EPUB or some such may be better suited. Any help greatly appreciated as always. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] Printer calibration
Pascal, On Sun, 2017-01-22 at 17:49 +0100, Pascal Obry wrote: > Le dimanche 22 janvier 2017 à 16:35 +0000, Tony Arnold a écrit : > > Has anyone on this list had any success creating a colour profile > > for > > their printer using the 'Device Colour Profiles' in System Setting > > with a Color Munki Photo device? > > Not sure what you are refering to with 'Device Colour Profiles' On Ubuntu in 'System Settings' in the Hardware section there is an option called 'Device Colour Profiles' which can be used to select a suitable profile for a screen or printer. It also has a 'Calibrate option that becomes available when you plug in a suitable device. I've used this with a ColorHug to profile my screen. It also seems to support the Color Munki Photo, but it either doesn't work or I'm not using it properly. > but I > have created printer profile with a color munki, see: > > http://pobry.blogspot.fr/2013/06/creating-icc-profile-on- > gnulinux.html Thanks. I'll take a closer look at this. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] Stitching(combine) two images
Michael, On Sat, 2016-12-31 at 18:19 -0500, Michael wrote: > Darktable is awesome for panoramas. I've even done a couple of > panoramas of inside rooms. Did you mean Darktable, or Hugin above? Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] Stitching(combine) two images
Sudhir, On Sat, 2016-12-31 at 21:18 +0530, Sudhir Reddy wrote: > Hi All, > > Can I stitch more than two images in darktable? > Do you mean just place two (or more) images side by side? Then, no. If you are trying to create a panorama from several images, then you could consider 'hugin'. From DT, you will need to export the images in TIFF format and then import them into 'hugin' to produce the panorama. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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
[darktable-user] Darktable for Yakkety?
Just wondering what the time scale is for a Ubuntu Yakkety repository for Darktable? This is curiosity mostly as the Xenial version seems to be working fine. Regards, Tony. -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, 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] Re: Film rolls
Owen, On Mon, 2016-06-20 at 10:40 -0500, Owen Mays wrote: > I apologize if this is a dumb question (I've never used Lightroom), > but how is using tags different from a "virtual collection"? You can > even create nested tags, so you could have a category called "my > virtual collections" and then tags below that. I've not used LR either. All I know about it iswhat a friend of mine tells me! And we've had quite a few long discussions comparing LR and DT. One possibility, IIRC, is that you may be able to have a different set of changes on the same image that is in more than one collection. But I'm not really sure. Regards, Tony. On Mon, Jun 20, 2016 at 10:35 AM, Tony Arnold <tony.arn...@manchester.ac.uk> wrote: On Mon, 2016-06-20 at 08:16 -0700, darkta...@911networks.com wrote: On Mon, 20 Jun 2016 16:23:41 +0200 Christian Mandel <c.man...@gmx.net> wrote: This topic is discussed frequently, one of the last threads was “Film roll vs folder” starting on 2015-11-16. Film rolls are related to file system paths, each film roll will hold a subset of images of a folder. Therefore, you would need a copy (or link) of the image in several folders, and even then, the edit history would not be the same. One could argue about other methods for collections, but I guess at the moment tags is probably the closest you will get. I did see that and I asked because P. Shanahan said: A "film roll" is a *collection* of images whereas a folder is a directory, a storage structure. but from everything else, they look to be the same. What I'm trying to do is: 1. Collections 2. Virtual copies but each belonging to different collection It sounds like you want a similar feature to 'virtual collections' in LightRoom where you can add images arbitrarily to a user created collection. In my experience, DT does not support this functionality. I get round this by using tags, where the tag is your 'virtual collection'. You can use the 'collect images' panel on the left hand side to select all images with a given tag. Virtual collections would be a really useful feature in DT, but looking at the database structure I can imagine it's a fair amount of work to implement, and that's assuming the developers want to do so! Regards, Tony. -- Tony Arnold | IT Security Analyst | University of Manchester | IT Services | T: +44 (0) 161 275 6093 | M: +44 (0) 773 330 0039 | E: tony. arn...@manchester.ac.uk ___ _ darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscribe@lists.darktabl e.or -- Tony Arnold | IT Security Analyst | University of Manchester | IT Services | T: +44 (0) 161 275 6093 | M: +44 (0) 773 330 0039 | E: tony.arn...@manchester.ac.uk darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.or
