I have a set of styles stored in a spatialite db with QGIS 2.18, the
layer_styles table looks like this:
Adding a layer in QGIS 2.18 loads the style set as default (waters light blue, categorized):
Using the same spatialite db and loading the same layer in QGIS 3.2 does not load the default style defined in the db:
Trying to Style | Load Style | Database Styles Manager... results in an Error 'Error loading styles. The query was logged':
I noticed that when saving a style to spatialite database from QGIS 3.2 the
f_table_catalog column is empty, but deleting the values from the above
layer_styles table doesn't have any effect (same behavior, same error).
Even when saving the styles to spatialite db from QGIS 3 with option set 'Use as default style for this layer', the default style is not loaded when adding the layer, after all the above mentioned error does not occur and I am able to load the style manually (even if the style is not recognized as related to layer that just saved it...).
Am I missing some drastic changes in QGIS 3 style management, and ist there a way to continue using my QGIS 2.18 spatialite dbs with the correct styles in QGIS 3?