<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Andrea,</p>
<p><br>
</p>
<p>I changed the files, all is o.k. now.</p>
<p>Is this o.k. as well, to report such errors or will they be fixed
anyway?</p>
<p><br>
</p>
<p>Kind regards</p>
<p><br>
</p>
<p>Piet<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 13.12.21 um 17:59 schrieb Andrea
Giudiceandrea:<br>
</div>
<blockquote type="cite"
cite="mid:bbf5e8f0-7177-066e-c66f-480636b969c0@libero.it">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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;" moz-do-not-send="true"><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;" moz-do-not-send="true">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>
</blockquote>
</body>
</html>