<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello Saulteau,</p>
<p><br>
</p>
<p>I'm unsure, if I understand your information right.</p>
<p><br>
<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><br>
<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"><br>
</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"><br>
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">If
I use the command <br>
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif"><br>
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif">patch
-Np1 -i /home/user/tmp/srs-fix.diff<br>
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif"><br>
</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">---<br>
</font></font></p>
<p><font face="arial, sans-serif"><font face="arial, sans-serif"><br>
user@debian:~/src/qgis/cpp/QGIS/src$ patch -Np1 -i
/home/user/tmp/srs-fix.diff <br>
can't find file to patch at input line 5<br>
Perhaps you used the wrong -p or --strip option?<br>
The text leading up to this was:<br>
--------------------------<br>
|diff --git a/src/core/proj/qgscoordinatereferencesystem.cpp
b/src/core/proj/qgscoordinatereferencesystem.cpp<br>
|index 77c7081e455d..4cba529b89de 100644<br>
|--- a/src/core/proj/qgscoordinatereferencesystem.cpp<br>
|+++ b/src/core/proj/qgscoordinatereferencesystem.cpp<br>
--------------------------<br>
File to patch: <br>
</font></font></p>
<p>---<br>
</p>
<p><br>
</p>
<p>Kind regards</p>
<p><br>
</p>
<p>Piet<br>
</p>
<p><br>
</p>
<p>~/src/qgis/cpp/QGIS/src$ patch -Np1 -i /home/user/tmp/<br>
4036e3d6ae71ffefc48a22295e338f59502949bb.diff<br>
srs-fix.diff<br>
user@debian:~/src/qgis/cpp/QGIS/src$ patch -Np1 -i
/home/user/tmp/srs-fix.diff <br>
can't find file to patch at input line 5<br>
Perhaps you used the wrong -p or --strip option?<br>
The text leading up to this was:<br>
--------------------------<br>
|diff --git a/src/core/proj/qgscoordinatereferencesystem.cpp
b/src/core/proj/qgscoordinatereferencesystem.cpp<br>
|index 77c7081e455d..4cba529b89de 100644<br>
|--- a/src/core/proj/qgscoordinatereferencesystem.cpp<br>
|+++ b/src/core/proj/qgscoordinatereferencesystem.cpp<br>
--------------------------<br>
<br>
</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 11.06.21 um 04:00 schrieb Saulteau
Don:<br>
</div>
<blockquote type="cite"
cite="mid:CAJo0jfMqoaRDpQdgg_LwBtuYcFjPBZfjS7B5ZW7dshyfZ98k+A@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
> List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</body>
</html>