[Qgis-user] OSM tiles layer not projected due to SQLite error

[Matthias Wirtz]

Hello,

looks like I had a mismatch between QGIS version and proj version.

I upgraded proj to version 7.2 and now the projection in QGIS is working
again.

--
Matthias Wirtz


-------- Forwarded Message --------
Subject: OSM tiles layer not projected due to SQLite error
Date: Sat, 28 Nov 2020 14:20:17 +0100
From: Matthias Wirtz <Matthias.Wirtz at gmx.net>
To: qgis-user at lists.osgeo.org

Hello,

I have an issue with my QGIS install on a opensuse leap 15.2 system with
QGIS 13.4.

When creating a new project with CRS EPSG:4326 and adding the OSM pixel
tiles the OSM map is not projected correctly. One prominent effect of
this is that e.g. Berlin is displayed on the latitude of around -33° and
not +52.5 as it should be.

In addition the following error is shown:

No transform available between EPSG:4326 and EPSG:3857

proj_create_operations: cannot build projectedCRS 3857: SQLite error on
SELECT extent.description, extent.south_lat, extent.north_lat,
extent.west_lon, extent.east_lon, scope.scope, (CASE WHEN scope.scope
LIKE '%large scale%' THEN 0 ELSE 1 END) AS score FROM usage JOIN extent
ON usage.extent_auth_name = extent.auth_name AND usage.extent_code =
extent.code JOIN scope ON usage.scope_auth_name = scope.auth_name AND
usage.scope_code = scope.code WHERE object_table_name = ? AND
object_auth_name = ? AND object_code = ? ORDER BY score,
usage.auth_name, usage.code: no such table: usage


Even when loading old projects the behavior regarding the OSM tiles
remains. As far as I remember these projects were made with the same
QGIS version 13.4 too.

My understanding is that the error message is the reason for the OSM
tiles not showing up correctly projected.

I'm not sure if this is a qgis problem or more related to an underlying
library. So it would be great if one could point me in the right direction.

Thx.

--
Matthias Wirtz, Mannheim, DE