On Thu, Dec 11, 2014 at 11:37 AM, Tobias Ellinghaus <[email protected]> wrote:
>
> Am Mittwoch, 10. Dezember 2014, 23:03:15 schrieb chris:
> > my version compiled from:
> > commit 5d36053f39d804ec393dc9bbf1774669a197e7ce
> > Date: Wed Dec 10 19:43:56 2014 +0300
> >
> > I receive a lot of errors of this kind:
> > sqlite3 error: /home/chris/opt/darktable/src/gui/presets.c:824, function
> > dt_gui_presets_popup_menu_show_internal(): no such column: format
> > sqlite3 error: /home/chris/opt/darktable/src/gui/presets.c:545, function
> > edit_preset(): no such column: format
> >
> > It seems tables changed.
> >
> > Before I used some commit from 1.5
> >
> > Shall I remove library.db and start from scratch with database?
>
> That looks strange. Could you do
>
> echo .schema presets | sqlite3 ~/.config/darktable/library.db
>
> and post the result?
$ echo .schema presets | sqlite3 ~/.config/darktable/library.db
CREATE TABLE presets (name varchar, description varchar, operation
varchar, op_params blob, enabled integer, model varchar, maker
varchar, lens varchar, iso_min real, iso_max real, exposure_min real,
exposure_max real, aperture_min real, aperture_max real,
focal_length_min real, focal_length_max real, writeprotect integer,
autoapply integer, filter integer, def integer, isldr integer,
blendop_params blob, op_version integer, blendop_version integer,
multi_priority integer, multi_name varchar(256));
>
>
> > Is it possible to export presets (e.g. from equalizer) and import them into
> > current version?
>
> That would be possible with some sqlite calls from the command line.
Any pointers how to achieve that.
I tried dumping data from previous library.db for clarity presets and
importing those into presets table in current library.db:
sqlite> INSERT INTO "presets"
VALUES('clarity','','atrous',X'0700000000000000CDCC4C3ECDCCCC3E9A99193FCDCC4C3F0000803F00000000CDCC4C3ECDCCCC3E9A99193FCDCC4C3F0000803F00000000CDCC4C3ECDCCCC3E9A99193FCDCC4C3F0000803F00000000CDCC4C3ECDCCCC3E9A99193FCDCC4C3F0000803F00000000CDCC4C3ECDCCCC3E9A99193FCDCC4C3F0000803F9A99193F9A99193F9A99193F9A99193F9A99193F9A99193FCDCC0C3FCDCC0C3FCDCC0C3FCDCC0C3FCDCC0C3FCDCC0C3F000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000',1,'%','%','%',0.0,51200.0,0.0,10000000.0,0.0,100000000.0,0.0,1000.0,1,0,0,0,0,X'00000000180000000000C842000000000000000000000000000000000000000000000000000000000000000000000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F00000000000000000000803F0000803F',1,7,0,'');
I started darktable and this inserted preset is not visible in
Equalizer (no presets there).
When I checked library.db afterwards this inserted preset was not
available in library.db anymore. I repeated inserting but it seems
with every darktable launch the new presets are gone.
Some presets were preserved between old and new version. (e.g. those
from Crop and Rotate plugin). In the dartktable though they are not
visible anyway (1.7.0 png file)
When running old version of dartktable they are there (only those that
are in the library.db -> 1.4rc1 png file)
thanks,
Chris
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Darktable-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/darktable-users
