Skip to content

Unable to load style from datasource database for non geometry layers. #66341

Description

@Iberlauf

What is the bug or the crash?

When I want to save and load a style for a non-geometry layer (MSSQL Server table), it saves the style to the layer_styles table, but it isn't shown as an option to choose for the Load Style command, nor does anything happen when I click the Load Default Style command. I am using QGIS 3.44.11 ltr.

Steps to reproduce the issue

Save the style both as a default style and a named style with the same name as the layer. When clicking both Load Style and Load Default Style, nothing happens.

Versions

QGIS version3.44.11-Solothurn
QGIS code revisionf8f5812197f
 
Libraries
Qt version5.15.13
Python version3.12.13
GDAL version3.13.0 — Iowa City
PROJ version9.8.1
EPSG Registry database versionv12.029 (2025-10-02)
GEOS version3.14.1-CAPI-1.20.5
SQLite version3.53.0
PDAL version2.10.0
PostgreSQL client version17.3
SpatiaLite version5.1.0
QWT version6.3.0
QScintilla2 version2.14.1
OS versionWindows 11 Version 2009
 
Active Python plugins
a00_qpip1.4.5
dxf_shp_loader0.1.1
FreehandRasterGeoreferencer0.8.3
GeoSpreadsheet1.0.7
kmltools3.2.4
maplibrary1.3
monokai1.0
monokaiprospectrum1.1
OpenTopography-DEM-Downloader4.1
pluginbuilder33.2.1
plugin_reloader0.22
processing_saga_nextgen1.1.0
qduckdb2.2.7
qgis2web4.1.4
quick_map_services1.3.1
viminacium_skice0.1
db_manager0.1.20
grassprovider2.12.99
MetaSearch0.3.6
processing2.12.99

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

No Duplicate of the Issue

  • I have verified that there are no existing issues raised related to my problem.

Additional context

No response

Metadata

Metadata

Assignees

Labels

BugEither a bug report, or a bug fix. Let's hope for the latter!MS SQL data provider

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions