[QGIS-Developer] Issues with CRS in QGIS master on Ubuntu 20.04

[Pedro Venâncio]

Hi all,

I'm testing QGIS master on Ubuntu 20.04, but I'm getting some errors and
issues with CRSs.

Master was installed from nightly repo https://qgis.org/ubuntu-nightly

GDAL 3.0.4 and PROJ 6.3.1 are from Ubuntu repos.

I use EPSG:3763 as default CRS.

When I start QGIS, I get this error:

No transform available between EPSG:3763 and Unknown CRS

No transform is available between EPSG:3763 - ETRS89 / Portugal TM06 and
Unknown CRS: GEOGCRS["unknown",DATUM["unknown",ELLIPSOID["GRS 1….
proj_create_operations: cannot build geodeticCRS 4326: SQLite error on
SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name,
prime_meridian_code, area_of_use_auth_name, area_of_use_code,
publication_date, deprecated FROM geodetic_datum WHERE auth_name = ? AND
code = ?: no such column: publication_date

Then I get several others, involving EPSG:4326, EPSG:3857 and Unknown CRS.

Another issue is that, apparently, QGIS does not recognize the prj file
from shapefiles, even if it was created by himself. For instance, this
sample shapefile
https://drive.google.com/uc?export=download&id=1e7WxgPoSeTx7RiZHIaxdX0kvL8UuOk9Z

was created by QGIS, but when I load it, I get it as Unknown CRS:

WKT
PROJCRS["Datum 73 / Modified Portuguese Grid",
    BASEGEOGCRS["Datum 73",
        DATUM["Datum 73",
            ELLIPSOID["International 1924",6378388,297,
                LENGTHUNIT["metre",1]],
            ID["EPSG",6274]],
        PRIMEM["Greenwich",0,
            ANGLEUNIT["Degree",0.0174532925199433]]],
    CONVERSION["unnamed",
        METHOD["Transverse Mercator",
            ID["EPSG",9807]],
        PARAMETER["Latitude of natural origin",39.6666666666667,
            ANGLEUNIT["Degree",0.0174532925199433],
            ID["EPSG",8801]],
        PARAMETER["Longitude of natural origin",-8.13190611111111,
            ANGLEUNIT["Degree",0.0174532925199433],
            ID["EPSG",8802]],
        PARAMETER["Scale factor at natural origin",1,
            SCALEUNIT["unity",1],
            ID["EPSG",8805]],
        PARAMETER["False easting",180.598,
            LENGTHUNIT["metre",1],
            ID["EPSG",8806]],
        PARAMETER["False northing",-86.99,
            LENGTHUNIT["metre",1],
            ID["EPSG",8807]]],
    CS[Cartesian,2],
        AXIS["(E)",east,
            ORDER[1],
            LENGTHUNIT["metre",1,
                ID["EPSG",9001]]],
        AXIS["(N)",north,
            ORDER[2],
            LENGTHUNIT["metre",1,
                ID["EPSG",9001]]]]
Proj4
+proj=tmerc +lat_0=39.6666666666667 +lon_0=-8.13190611111111 +k=1
+x_0=180.598 +y_0=-86.99 +ellps=intl +units=m +no_defs +type=crs
Extent
Extent not known


And if I try to load a Google Layer from QuickMapServices plugin, I get:

No transform available between EPSG:3857 and EPSG:3763
No transform is available between EPSG:3857 - WGS 84 / Pseudo-Mercator and
EPSG:3763 - ETRS89 / Portugal TM06.
proj_create_operations: cannot build projectedCRS 3857: cannot build
geodeticCRS 4326: SQLite error on SELECT name, ellipsoid_auth_name,
ellipsoid_code, prime_meridian_auth_name, prime_meridian_code,
area_of_use_auth_name, area_of_use_code, publication_date, deprecated FROM
geodetic_datum WHERE auth_name = ? AND code = ?: no such column:
publication_date

No transform available between EPSG:4326 and EPSG:3857
No transform is available between EPSG:4326 - WGS 84 and EPSG:3857 - WGS 84
/ Pseudo-Mercator.
proj_create_operations: cannot build projectedCRS 3857: cannot build
geodeticCRS 4326: SQLite error on SELECT name, ellipsoid_auth_name,
ellipsoid_code, prime_meridian_auth_name, prime_meridian_code,
area_of_use_auth_name, area_of_use_code, publication_date, deprecated FROM
geodetic_datum WHERE auth_name = ? AND code = ?: no such column:
publication_date


Can this be related with https://github.com/qgis/QGIS/issues/30569, or
seems more like a local problem?

Thank you very much.

Best regards,
Pedro
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200601/8b5033d1/attachment.html>