The problem is the following. The styles are numbered after its rowid (table styles)
The styles items have a styleid referencing the style above. When a style is removed the rowid are non continuous, that is: sqlite> select rowid,* from styles; 1|red| 3|blue| 4|violet| The rowid is style referencing the proper items. But if the database is vacuumed, the those rowid are continuous and not referencing the proper style: sqlite> vacuum; sqlite> select rowid,* from styles; 1|red| 2|blue| 3|violet| I think it is a mistake to use the rowid as an index. In fact it is the only cases on dt where this is done. The proper solution would be to introduce an id into the styles table. Not sure how to handle this migration path though. Idea? -- Pascal Obry / Magny Les Hameaux (78) The best way to travel is by means of imagination http://v2p.fr.eu.org http://www.obry.net gpg --keyserver keys.gnupg.net --recv-key F949BD3B ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk _______________________________________________ darktable-devel mailing list darktable-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/darktable-devel
