Re: [Qgis-user] Fwd: Compiling messages Qgis 3.19.0

2021-06-16 Thread Andrea Giudiceandrea 
Andrea Giudiceandrea wrote
> https://github.com/qgis/QGIS/pull/43712 which has not yet been merged in
> master.

Both fixes are now in Master branch, so the upcoming QGIS 3.20 will not
suffer of the two issues.
Anyway the second fix was not backported to 3.16 branch.

Regards.

Andrea



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fwd: Compiling messages Qgis 3.19.0

2021-06-15 Thread Andrea Giudiceandrea 
Richard Duivenvoorde wrote
> 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.315820472 +gamma=53.130102361 +k=0.99984 +x_0=200
> +y_0=500 +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 ;-) )

Hi Richard,
this issue was already fixed (as confirmed by Saulteau and Piet) with
https://github.com/qgis/QGIS/pull/43694, thereafter superseded by
https://github.com/qgis/QGIS/pull/43712 which has not yet been merged in
master.

Bet regards.

Andrea



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fwd: Compiling messages Qgis 3.19.0

2021-06-15 Thread Richard Duivenvoorde 
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.315820472 +gamma=53.130102361 +k=0.99984 +x_0=200 
+y_0=500 +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 
> An:   qgis-user@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 
> 
> 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@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@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.315820472 +gamma=53.130102361 
>>> +k=0.99984
>>> +x_0=200 +y_0=500 +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 
>>>  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
>>>  
>>> 
>>>
>>> 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 di

[Qgis-user] Fwd: Compiling messages Qgis 3.19.0

2021-06-13 Thread APM 

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 
An: qgis-user@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 

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@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@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.315820472 +gamma=53.130102361 +k=0.99984
+x_0=200 +y_0=500 +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 
 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 



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 
patch -Np1 -i /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 > 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
 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

> __