<div dir="ltr">The two patches in that diff eliminate the last srs error for 3.18.3.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 11, 2021 at 4:56 AM APM <<a href="mailto:apschwimmer@apmland.de">apschwimmer@apmland.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Dear List,</p>
<p>
</p>
<p>
</p>
<p>sorry, I give bad data.</p>
<p>
</p>
<p>My compiled Qgis version is not 3.18.3, it's
</p>
<p>
</p>
<table style="margin:0px" width="100%" cellspacing="2" cellpadding="0" border="0" align="center">
<tbody>
<tr>
<td>
<p style="margin:0px;text-indent:0px">QGIS-Version</p>
</td>
<td>
<p style="margin:0px;text-indent:0px">3.19.0-Master</p>
</td>
<td>
<p style="margin:0px;text-indent:0px">QGIS-Codeversion</p>
</td>
<td>
<p style="margin:0px;text-indent:0px"><a href="https://github.com/qgis/QGIS/commit/2066fd6fb9" target="_blank"><span style="text-decoration:underline;color:rgb(0,0,255)">2066fd6fb9</span></a></p>
</td>
</tr>
</tbody>
</table>
<p></p>
<p>
</p>
<p>Kind regards</p>
<p>
</p>
<p>Piet
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<div>Am 11.06.21 um 09:24 schrieb APM:<br>
</div>
<blockquote type="cite">
<p>Hello Saulteau,</p>
<p>
</p>
<p>I'm unsure, if I understand your information right.</p>
<p>
<font face="arial, sans-serif"> </font></p>
<p><font face="arial, sans-serif">1. Go to the issue that Andrea
referenced at....  > ok</font></p>
<p>
<font face="arial, sans-serif"><font face="arial, sans-serif">2.
copy the patch link with the clipboard button.....</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">I
think this is the button on the right side beneath "Verified".
If I press it  in Firefox</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">I
have "4036e3d6ae71ffefc48a22295e338f59502949bb" in the
browsers clipboard.</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">So
I copy and paste the file directly and stored it as </font></font><font face="arial, sans-serif"><font face="arial, sans-serif"><font face="arial, sans-serif"><font face="arial, sans-serif">'srs-fix.diff'</font></font>:</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">If
I use the command
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">patch
-Np1 -i /home/user/tmp/srs-fix.diff
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">I
get the message:</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">---
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">
user@debian:~/src/qgis/cpp/QGIS/src$ patch -Np1 -i
/home/user/tmp/srs-fix.diff
can't find file to patch at input line 5
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/src/core/proj/qgscoordinatereferencesystem.cpp
b/src/core/proj/qgscoordinatereferencesystem.cpp
|index 77c7081e455d..4cba529b89de 100644
|--- a/src/core/proj/qgscoordinatereferencesystem.cpp
|+++ b/src/core/proj/qgscoordinatereferencesystem.cpp
--------------------------
File to patch:
</font></font></p>
<p>---
</p>
<p>
</p>
<p>Kind regards</p>
<p>
</p>
<p>Piet
</p>
<p>
</p>
<p>~/src/qgis/cpp/QGIS/src$ patch -Np1 -i /home/user/tmp/
4036e3d6ae71ffefc48a22295e338f59502949bb.diff
srs-fix.diff
user@debian:~/src/qgis/cpp/QGIS/src$ patch -Np1 -i
/home/user/tmp/srs-fix.diff
can't find file to patch at input line 5
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/src/core/proj/qgscoordinatereferencesystem.cpp
b/src/core/proj/qgscoordinatereferencesystem.cpp
|index 77c7081e455d..4cba529b89de 100644
|--- a/src/core/proj/qgscoordinatereferencesystem.cpp
|+++ b/src/core/proj/qgscoordinatereferencesystem.cpp
--------------------------
</p>
<p>
</p>
<p>
</p>
<div>Am 11.06.21 um 04:00 schrieb Saulteau
Don:<br>
</div>
<blockquote type="cite">
<div dir="ltr">The patch resolved almost all of them! It's left
a single CRS that couldn't be:
<div><br>
</div>
<div><span style="font-family:monospace"><span style="color:rgb(0,0,0)">Could not execute: INSERT INTO
tbl_srs(srs_id,
description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated)
VALUES (63</span><br>
321, 'Timbalai 1948 / RSO Sarawak LSD
(m)','omerc','omerc','+proj=omerc +no_uoff +lat_0=4
+lonc=115 +alpha=53.3158204722222 +gamma=53.1301023611111
+k=0.99984 <br>
+x_0=2000000 +y_0=5000000 +ellps=evrstSS
+towgs84=-679,669,-48,0,0,0,0 +units=m
+no_defs',520003321,'EPSG','29874',0,0) [UNIQUE constraint
failed: tbl_srs.srs_<br>
id/UNIQUE constraint failed: tbl_srs.srs_id] <br>
<br>
1 CRSs could not be updated.<br>
</span></div>
<div><span style="font-family:monospace"><br>
</span></div>
<div><font face="arial, sans-serif">Tested on QGIS 3.18.3 and
Arch Linux.</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif">To get the patch:</font></div>
<div><font face="arial, sans-serif">1.) Go to the issue that
Andrea referenced at <a href="https://github.com/qgis/QGIS/pull/43671" target="_blank">https://github.com/qgis/QGIS/pull/43671</a>
and click the "commits" tab</font></div>
<div><font face="arial, sans-serif">2.) copy the patch link
with the clipboard button and paste that into your browser</font></div>
<div><font face="arial, sans-serif">3.) add .diff to it like
so,</font></div>
<div><font face="arial, sans-serif"><a href="https://github.com/qgis/QGIS/commit/4036e3d6ae71ffefc48a22295e338f59502949bb.diff" target="_blank">https://github.com/qgis/QGIS/commit/4036e3d6ae71ffefc48a22295e338f59502949bb.diff</a><br>
</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif">that's the patch file =)
download it or put it in a notepad and save it.</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div><font face="arial, sans-serif">This particular patch is
being applied to 'master' so it's important to Find &
Replace the reference to the /proj/ folder.</font></div>
<div><font face="arial, sans-serif">It's because the /proj
folder doesn't exist in the 3.18.3 source package and the
patch won't apply.</font></div>
<div><font face="arial, sans-serif"><br>
</font></div>
<div>Then, you can change directly into the qgis source folder
after you extract it, apply the patch, then make, make
install.</div>
<div><span style="font-family:monospace"><br>
</span></div>
<div><span style="font-family:monospace">cd <qgis src
directory></span></div>
<div><span style="font-family:monospace"><span style="color:rgb(0,0,0)">patch -Np1 -i <path to
patch>/srs-fix.diff</span><br>
</span></div>
<div><span style="font-family:monospace"><span style="color:rgb(0,0,0)"><br>
</span></span></div>
<div><span style="font-family:monospace"><span style="color:rgb(0,0,0)">is an example of applying the
patch with the 'patch' utility</span></span></div>
<div><span style="font-family:monospace"><br>
</span></div>
<div><span style="font-family:monospace">saultdon</span></div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jun 10, 2021 at 4:42
AM APM <<a href="mailto:apschwimmer@apmland.de" target="_blank">apschwimmer@apmland.de</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Dear Andrea,<br>
<br>
<br>
thank you for that!<br>
<br>
<br>
To be honest, I have no idea how to deal with a patch!<br>
<br>
<br>
Maybe you can give me a short advice?<br>
<br>
<br>
<br>
Kind regards<br>
<br>
<br>
Piet<br>
<br>
<br>
Am 10.06.21 um 13:35 schrieb Andrea Giudiceandrea:<br>
> APM wrote<br>
>> All blocks of the message contains<br>
>><br>
>> "NOT NULL constraint failed:"<br>
> Hi Piet,<br>
> I've submitted a patch <a href="https://github.com/qgis/QGIS/pull/43671" rel="noreferrer" target="_blank">https://github.com/qgis/QGIS/pull/43671</a>
which<br>
> hopefully fixes the issue.<br>
><br>
> If you want, you could try if it works for you. In
case, let me know.<br>
><br>
> Regards.<br>
><br>
> Andrea<br>
><br>
><br>
><br>
> --<br>
> Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html</a><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote></div>