<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<blockquote type="cite">
<div class="msgHead" style="color: rgb(0, 0, 0); font-family:
helvetica, arial, sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-thickness: initial; text-decoration-style:
initial; text-decoration-color: initial;">
<p class="darkgray font13" style="font-size: 13px; color:
rgb(102, 102, 102);"><span class="sender pipe"
style="margin-right: 0.5em; border-right: 1px solid rgb(221,
221, 221); padding-right: 0.8em;"><a
href="https://www.mail-archive.com/search?l=qgis-user@lists.osgeo.org&q=from:%22APM%22"
rel="nofollow" style="color: rgb(102, 102, 102);
text-decoration: none;"><span itemprop="author"
itemscope="" itemtype="http://schema.org/Person"><span
itemprop="name">APM</span></span></a></span><span> </span><span
class="date"><a
href="https://www.mail-archive.com/search?l=qgis-user@lists.osgeo.org&q=date:20211213"
rel="nofollow" style="color: rgb(102, 102, 102);
text-decoration: none;">Mon, 13 Dec 2021 05:05:32 -0800</a></span></p>
</div>
<div itemprop="articleBody" class="msgBody" style="color: rgb(0,
0, 0); font-family: helvetica, arial, sans-serif; font-size:
14px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">
<pre style="font-family: courier, "courier new", monospace; font-size: 1em; white-space: pre-wrap; overflow-wrap: break-word; margin: 0em;">Dear List,
I compiled Qgis from github.</pre>
<pre style="font-family: courier, "courier new", monospace; font-size: 1em; white-space: pre-wrap; overflow-wrap: break-word; margin: 0px;">If I install the build with make install I got the message:
</pre>
<tt style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">Installing crssync ...
Could not execute: INSERT INTO tbl_srs(srs_id,<span> </span></tt><tt
style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated)<span> </span></tt><tt
style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">VALUES (63560,
'GSK-2011 / GSK 3GK zone 7','tmerc','tmerc','+proj=tmerc<span> </span></tt><tt
style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">+lat_0=0 +lon_0=21 +k=1
+x_0=7250000 +y_0=0 +ellps=GSK2011<span> </span></tt><tt
style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">+towgs84=0,0,0,0,0,0,0
+units=m +no_defs',520003560,'EPSG','21207',0,0)<span> </span></tt><tt
style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">[UNIQUE constraint
failed: tbl_srs.srs_id/UNIQUE constraint failed:<span> </span></tt><tt
style="margin: 0px; font-family: courier, "courier
new", monospace; font-size: 1em;">tbl_srs.srs_id]</tt></div>
</blockquote>
<br>
Hi Piet,<br>
this issue is similar to the one previously also reported by you
some months ago.<br>
<br>
It seems to me there is again an issue in the source code files
qgscoordinatereferencesystem.cpp and
qgscoordinatereferencesystem_legacy.h<br>
<br>
You should be able to fix the issue patching the lines 2357 and 2358
of src/core/proj/qgscoordinatereferencesystem.cpp<br>
<br>
from:<br>
<br>
int nextSrsId = 63560;<br>
int nextSrId = 520003560;<br>
<br>
<br>
to:<br>
<br>
int nextSrsId = 63561;<br>
int nextSrId = 520003561;<br>
<br>
<br>
<br>
and the last lines of
src/core/proj/qgscoordinatereferencesystem_legacy.h<br>
<br>
from:<br>
<br>
{"OGC:CRS83", "63559,520003559"},<br>
};<br>
<br>
<br>
to:<br>
<br>
{"OGC:CRS83", "63559,520003559"},<br>
{"EPSG:20904", "63560,520003560"},<br>
};<br>
<br>
<br>
<br>
Best regards.<br>
<br>
Andrea Giudiceandrea<br>
</body>
</html>