[QGIS-Developer] Could not execute: INSERT INTO tbl_sr during ninja install

[Paul N via QGIS-Developer]

Hi,
QGIS compilation successful with *build ninja* on windows 10. While trying
to install using *ninja install*, I am getting the following error message.
There are many rows like below, few of them are below which also have the
last line.

Could not execute: INSERT INTO tbl_srs(srs_id,
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated,srs_type)
VALUES (64078, 'Neptune (2015) / Ographic /
Mercator','merc','merc','+proj=merc +R_C +lat_0=0 +lon_0=0 +x_0=0 +y_0=0
+a=24764000 +b=24341000 +units=m
+no_defs',520004078,'IAU_2015','89991',0,0,'Projected') [UNIQUE constraint
failed: tbl_srs.srs_id/UNIQUE constraint failed: tbl_srs.srs_id]

Could not execute: INSERT INTO tbl_srs(srs_id,
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated,srs_type)
VALUES (64079, 'Neptune (2015) / Ocentric /
Mercator','merc','merc','+proj=merc +R_C +lat_0=0 +lon_0=0 +x_0=0 +y_0=0
+a=24764000 +b=24341000 +units=m
+no_defs',520004079,'IAU_2015','89992',0,0,'Projected') [UNIQUE constraint
failed: tbl_srs.srs_id/UNIQUE constraint failed: tbl_srs.srs_id]

Could not execute: INSERT INTO tbl_srs(srs_id,
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated,srs_type)
VALUES (64080, 'Charon (2015) - Sphere / Ocentric /
Mercator','merc','merc','+proj=merc +R_C +lat_0=0 +lon_0=0 +x_0=0 +y_0=0
+R=606000 +units=m +no_defs',520004080,'IAU_2015','90190',0,0,'Projected')
[UNIQUE constraint failed: tbl_srs.srs_id/UNIQUE constraint failed:
tbl_srs.srs_id]

Could not execute: INSERT INTO tbl_srs(srs_id,
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated,srs_type)
VALUES (64081, 'Gaspra (2015) - Sphere / Ocentric /
Mercator','merc','merc','+proj=merc +R_C +lat_0=0 +lon_0=0 +x_0=0 +y_0=0
+R=6100 +units=m
+no_defs',520004081,'IAU_2015','951101090',0,0,'Projected') [UNIQUE
constraint failed: tbl_srs.srs_id/UNIQUE constraint failed: tbl_srs.srs_id]

Could not execute: INSERT INTO tbl_srs(srs_id,
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated,srs_type)
VALUES (64082, 'Pluto (2015) - Sphere / Ocentric /
Mercator','merc','merc','+proj=merc +R_C +lat_0=0 +lon_0=0 +x_0=0 +y_0=0
+R=1188300 +units=m +no_defs',520004082,'IAU_2015','0',0,0,'Projected')
[UNIQUE constraint failed: tbl_srs.srs_id/UNIQUE constraint failed:
tbl_srs.srs_id]

*522 CRSs could not be updated.*

Any clue?
Regards
Paul N
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Could not execute: INSERT INTO tbl_sr during ninja install

[Andrea Giudiceandrea via QGIS-Developer]

Il 16/02/2024 14:11, Paul N via QGIS-Developer ha scritto:
Could not execute: INSERT INTO tbl_srs(srs_id, 
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated,srs_type) VALUES (64078, 'Neptune (2015) / Ographic / Mercator','merc','merc','+proj=merc +R_C +lat_0=0 +lon_0=0 +x_0=0 +y_0=0 +a=24764000 +b=24341000 +units=m +no_defs',520004078,'IAU_2015','89991',0,0,'Projected') [UNIQUE constraint failed: tbl_srs.srs_id/UNIQUE constraint failed: tbl_srs.srs_id]


Hi Paul N,
it looks like that issue happens from time to time. Anyway I suppose 
such issue may have been already fixed. See 
https://github.com/qgis/QGIS/pull/56317/commits/aa7317e4239e88252c3327bcccd27646062087aa


Which commit are have you build on?

Best regards.

Andrea
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer