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 <[email protected]> > An: [email protected] > > > > 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@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.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 <[email protected] >>> <mailto:[email protected]>> 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 >>> > [email protected] <mailto:[email protected]> >>> > 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 >>> [email protected] <mailto:[email protected]> >>> 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 >>> [email protected] >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
