The output of the sqlite command is empty:
cribari@darwin3:~/temp2$ sqlite3 ~/.config/darktable/library.db
The program 'sqlite3' is currently not installed. You can install it by
typing:
sudo apt-get install sqlite3
cribari@darwin3:~/temp2$ sqlite3 ~/.config/darktable/library.db
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select imgid,operation from history where op_params is NULL;
sqlite>
It turns out that a large number (all?) of my XMP files have <rdf:li/> . I
did
cribari@darwin3:~/temp2$ find /media/cribari/FC-Ultra-2T/Pictures/ -name
"*.xmp" | xargs egrep '<rdf:li/>' > out.txt
The output file is available at
https://dl.dropboxusercontent.com/u/2171814/out.txt
What should I do next? Thanks a lot. Best, Francisco
On Tue, Jul 15, 2014 at 2:23 AM, Ulrich Pegelow <[email protected]
> wrote:
> Currently I can only speculate on the cause of the incorrect xmp files. My
> first guess would be a database corruption of library.db during the time
> when you edited the images.
>
> To check if your current library.db is affected you might try the
> following:
>
> sqlite3 ~/.config/darktable/library.db
> select imgid,operation from history where op_params is NULL;
>
> This should normally give an empty output. Anything else indicates
> problems.
>
> To find out which of your xmp's might be affected you could do the
> following:
>
> find . -name "*.xmp" | xargs egrep '<rdf:li/>'
>
> to find all occurences of <rdf:li/>. But then you need to manually check
> the ones that are reported because the <rdf:li/> is only a problem if it
> occurs in combinations like
>
>
> <darktable:history_params>
> <rdf:Seq>
> <rdf:li/>
> </rdf:Seq>
> </darktable:history_params>
>
> while in combination with <darktable:multi_name> it seems to be OK.
>
> Best wishes
>
> Ulrich
>
> Am 14.07.2014 22:14, schrieb Francisco Cribari:
>
> I have been running the unstable version of Darktable since I did a
>> fresh install of Ubuntu in this notebook (in late April). The photos in
>> that folder were produced and edited on May 25, 2014 (thus, after the
>> fresh install of Ubuntu). I believe I used whatever version of Darktable
>> (unstable, from Pascal's PPA) was available back then. I removed that
>> particular XMP file from the folder and tried to import the folder
>> again. Darktable crashed. It also crashed when I clicked in "map" and
>> tried to zoom in. Some of the photos in that folder (all JPG files
>> created using a Fujifilm X100S camera) were heavily edited. Will I lose
>> all edits I made? (BTW, I reported an issue:
>> http://www.darktable.org/redmine/issues/10015 .)
>>
>> Best, Francisco
>>
>>
>>
--
Francisco Cribari, email: [email protected] - "All theory, my friend, is
grey, but green is life's glad golden tree." --Goethe (Faust)
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Darktable-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/darktable-users
