[Qgis-user] Compiling messages Qgis 3.18.3

[Andrea Giudiceandrea]

Richard Duivenvoorde wrote
> During install QGIS tries to sync your local crs db (in sqlite) with a new
> list from ??? the installer, and SQlite complains about something (maybe
> that a crs already excists and you cannot overwrite it or so)? 

Hi all,
it seems to me there is a regression in
getOperationAndEllipsoidFromProjString which is called when
QgsCoordinateReferenceSystem::syncDatabase() is executed during install.

The reported errors refers to "NOT NULL constraint failed:
tbl_srs.ellipsoid_acronym" because the ellipsoid_acronym field in tbl_srs
should not be NULL.

The code made sure the string inserted in ellipsoid_acronym empty was empty
and not NULL, but a recent change in the code [1] has no longer respected
this need.

If my finding are correct, I'll submit a little fix to solve this issue.

Regards.

Andrea


[1]
https://github.com/qgis/QGIS/commit/9e0bf6df993a8548be3e21e274ee2857728e658d#diff-0eb6084517fa5891245c56de95f3c07dc2424ffc25b732059acce2bdcfb6c66fL2461-R2480
| https://github.com/qgis/QGIS/pull/40737



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html