[Qgis-user] Fwd: Compiling messages Qgis 3.19.0
Richard Duivenvoorde
rdmailings at duif.net
Tue Jun 15 00:54:21 PDT 2021
Hi (as promissed):
Seeing (only) this one now during local compile/install :
Could not execute: INSERT INTO tbl_srs(srs_id, description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated) VALUES (63321, '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 +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_id/UNIQUE constraint failed: tbl_srs.srs_id]
1 CRSs could not be updated.
Others can confirm? (and eventually @Andrea: would this be fixable ;-) )
Regards,
Richard Duivenvoorde
On 6/13/21 2:30 PM, APM wrote:
> Dear List,
>
> after patching the files I see no messages anymore and the related CRS is visible in the CRS list!
>
> Have thanks!
>
> Kind regards
>
> Piet
>
>
>
> -------- Weitergeleitete Nachricht --------
> Betreff: Re: [Qgis-user] Compiling messages Qgis 3.18.3
> Datum: Fri, 11 Jun 2021 13:55:56 +0200
> Von: APM <apschwimmer at apmland.de>
> An: qgis-user at lists.osgeo.org
>
>
>
> Dear List,
>
> sorry, I give bad data.
>
> My compiled Qgis version is not 3.18.3, it's
>
> QGIS-Version
>
>
>
> 3.19.0-Master
>
>
>
> QGIS-Codeversion
>
>
>
> 2066fd6fb9 <https://github.com/qgis/QGIS/commit/2066fd6fb9>
>
> Kind regards
>
> Piet
>
> Am 11.06.21 um 09:24 schrieb APM:
>>
>> Hello Saulteau,
>>
>> I'm unsure, if I understand your information right.
>>
>> 1. Go to the issue that Andrea referenced at.... > ok
>>
>> 2. copy the patch link with the clipboard button.....
>>
>> I think this is the button on the right side beneath "Verified". If I press it in Firefox
>>
>> I have "4036e3d6ae71ffefc48a22295e338f59502949bb" in the browsers clipboard.
>>
>> So I copy and paste the file directly and stored it as 'srs-fix.diff':
>>
>> If I use the command
>>
>> patch -Np1 -i /home/user/tmp/srs-fix.diff
>>
>> I get the message:
>>
>> ---
>>
>> user at 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:
>>
>> ---
>>
>> Kind regards
>>
>> Piet
>>
>> ~/src/qgis/cpp/QGIS/src$ patch -Np1 -i /home/user/tmp/ 4036e3d6ae71ffefc48a22295e338f59502949bb.diff srs-fix.diff user at 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 --------------------------
>>
>> Am 11.06.21 um 04:00 schrieb Saulteau Don:
>>> The patch resolved almost all of them! It's left a single CRS that couldn't be:
>>>
>>> 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
>>> 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
>>> +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_
>>> id/UNIQUE constraint failed: tbl_srs.srs_id]
>>>
>>> 1 CRSs could not be updated.
>>>
>>> Tested on QGIS 3.18.3 and Arch Linux.
>>>
>>> To get the patch:
>>> 1.) Go to the issue that Andrea referenced at https://github.com/qgis/QGIS/pull/43671 <https://github.com/qgis/QGIS/pull/43671> and click the "commits" tab
>>> 2.) copy the patch link with the clipboard button and paste that into your browser
>>> 3.) add .diff to it like so,
>>> https://github.com/qgis/QGIS/commit/4036e3d6ae71ffefc48a22295e338f59502949bb.diff <https://github.com/qgis/QGIS/commit/4036e3d6ae71ffefc48a22295e338f59502949bb.diff>
>>>
>>> that's the patch file =) download it or put it in a notepad and save it.
>>>
>>> This particular patch is being applied to 'master' so it's important to Find & Replace the reference to the /proj/ folder.
>>> It's because the /proj folder doesn't exist in the 3.18.3 source package and the patch won't apply.
>>>
>>> Then, you can change directly into the qgis source folder after you extract it, apply the patch, then make, make install.
>>>
>>> cd <qgis src directory>
>>> patch -Np1 -i <path to patch>/srs-fix.diff
>>>
>>> is an example of applying the patch with the 'patch' utility
>>>
>>> saultdon
>>>
>>> On Thu, Jun 10, 2021 at 4:42 AM APM <apschwimmer at apmland.de <mailto:apschwimmer at apmland.de>> wrote:
>>>
>>> Dear Andrea,
>>>
>>>
>>> thank you for that!
>>>
>>>
>>> To be honest, I have no idea how to deal with a patch!
>>>
>>>
>>> Maybe you can give me a short advice?
>>>
>>>
>>>
>>> Kind regards
>>>
>>>
>>> Piet
>>>
>>>
>>> Am 10.06.21 um 13:35 schrieb Andrea Giudiceandrea:
>>> > APM wrote
>>> >> All blocks of the message contains
>>> >>
>>> >> "NOT NULL constraint failed:"
>>> > Hi Piet,
>>> > I've submitted a patch https://github.com/qgis/QGIS/pull/43671 <https://github.com/qgis/QGIS/pull/43671> which
>>> > hopefully fixes the issue.
>>> >
>>> > If you want, you could try if it works for you. In case, let me know.
>>> >
>>> > Regards.
>>> >
>>> > Andrea
>>> >
>>> >
>>> >
>>> > --
>>> > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html <http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html>
>>> > _______________________________________________
>>> > Qgis-user mailing list
>>> > Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>>> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>>> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>>>
>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
More information about the Qgis-user
mailing list