I have views stored in a spatialite database accessed via QGIS. The views were created by another person on a different computer. The geometry column is well registered in the table views_geometry_columns but when I add the view to the canvas with DB Manager It's seems to just be an attribute table without geometry. I've tried the classical SELECT UpdateLayerStatistics('view_name') but it doesn't change anything.
Any solution(s) ?