I tried on a geopackage and found two things : - Geopackage also has a field length limit in the attributes table. Maybe it's well known...? - The style load and save problem doesn't occur on geopackage but only on our MSSQL database so far.
The style bug happens in the layer properties panel, in load style from the database. Restore default style works. From my python code, I think that the getStyleFromDatabase() has some bug with MSSQL db. Le jeu. 7 oct. 2021 à 17:37, Jésahel Benoist <[email protected]> a écrit : > Hello list, > > I had some strange behaviour when trying to load a layer's default style > from my DB in the properties panel, I got the error "Root <qgis> element > could not be found". > > I opened the layers_styles table directly with the attributes table and > discovered that the record's styleQML got truncated. > > The normal length of this field is 69Kb. Truncated is 32Kb. Impossible to > add characters in the table. And modifying style always give a truncated > size around 32Kb. > > Strangely, using the style panel to load and save by default works ! > > By exporting the layer_styles table in a kml file, I see that everything > is correctly stored in the DB. > > Btw, the python code I was using to load default style from db is also > broken... > > So I think there's some bug in one of the default style loading internal > functions and that the attributes table maximum editable field length is > around 32Kb. > > Am I missing something? > > Regards, > > Jésahel >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
