Re: [Qgis-user] Problens in atribute tables (bug?)
Hi Frederico,
It would be very useful if you can isolate the problem.
You can enable logging for all Postgresql queries. Edit you
postgresql.conf file and change log_statement = 'all'. Restart
Postgresql. Open the log to see what is going on.
Duplicate you table on another schema or database and play with it.
I've created a new table, with an additional x and y columns for the
labels and I did some editing. I've set the label positioning to x and y.
CREATE TABLE public.cemiterio (
fid serial NOT NULL,
nome varchar(100) NULL,
x numeric(10) NULL,
y numeric(10) NULL,
wkb_geometry geometry(Point, 3857),
CONSTRAINT cemiterio_pkey PRIMARY KEY (fid)
);
Everything went fine. When changing the directly the attribute table, I
get just one single update. For example:
2018-11-17 23:13:15.263 WET [29639] geobox@geotuga LOG: statement: BEGIN
2018-11-17 23:13:15.263 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "x"=-1923181 WHERE "fid"=3
2018-11-17 23:13:15.263 WET [29639] geobox@geotuga LOG: statement: COMMIT
2018-11-17 23:13:15.275 WET [29537] geobox@geotuga LOG: statement:
BEGIN READ ONLY
2018-11-17 23:13:15.275 WET [29537] geobox@geotuga LOG: statement:
DECLARE qgis_38 BINARY CURSOR FOR SELECT
st_asbinary("wkb_geometry",'NDR'),"fid","nome"::text,"x"::text,"y"::text
FROM "public"."cemiterio" WHERE "wkb_geometry" &&
st_makeenvelope(-1921084.8524324435275048,3785638.23111640242859721,-1736633.8711264121811837,3881349.90870131878182292,3857)
2018-11-17 23:13:15.276 WET [29537] geobox@geotuga LOG: statement:
FETCH FORWARD 2000 FROM qgis_38
2018-11-17 23:13:15.276 WET [29537] geobox@geotuga LOG: statement:
CLOSE qgis_38
2018-11-17 23:13:15.276 WET [29537] geobox@geotuga LOG: statement: COMMIT
When updating using the field calculator, I get all the updates:
2018-11-17 23:12:30.085 WET [29639] geobox@geotuga LOG: statement: BEGIN
2018-11-17 23:12:30.086 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "y"=3900084.04311737 WHERE "fid"=1
2018-11-17 23:12:30.086 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "y"=3875154.0323308 WHERE "fid"=2
2018-11-17 23:12:30.087 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "y"=3850565.52854132 WHERE "fid"=3
2018-11-17 23:12:30.088 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "y"=3852551.36467331 WHERE "fid"=4
2018-11-17 23:12:30.088 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "y"=3832291.8228186 WHERE "fid"=5
2018-11-17 23:12:30.089 WET [29639] geobox@geotuga LOG: statement:
UPDATE "public"."cemiterio" SET "y"=3819588.03812478 WHERE "fid"=6
2018-11-17 23:12:30.089 WET [29639] geobox@geotuga LOG: statement: COMMIT
I've use expressions to update x and y columns, like:
"x" + 100
or
$x - 50
You hit some issue probably, but it would be great if you could identify it.
I did the tests with QGIS 2.18.17 against Postgresql 10.
If you need further help, just ask.
Regards,
Jorge
> POSTGIS. A few days ago our team observed some strange problens
> updating data in atribute tables.
>
> It is hard to explains, because we couldn't isolate the process and the
> error until now.
>
> Basicly, wen we are updating data, using field calculator, manualy at
> the tables or using label placement by X and Y registred in table, QGIS
> send an update to the POSTGRES with a random value in a random column.
>
> We discovered the error when an 'F' was updated in a Integer column,
> when the user tried to save the edition, QGIS has returned a mensage
> with the error and, since that day, we are very apreensive because we
> dont know the damage in our database.
>
> Since this is random, I did'nt try to send a bug report and haven't
> found a ticket that describe something like that.
>
> Its is a very atipical situation. We use QGIS since 1.8(Lisboa) and this
> has never hapened with us.
>
> We are using 2.18.12 with POSTGRES 9.4 - POSTGIS 2.2.3
>
> Has somebody experiencied sometihng like that?
> Could anyone help us, please?
>
> Best regards
>
> --
>
> Fred
>
> ___
> 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
>
J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
___
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-it-user] Condivisiones esperienza Geopack
Confermo, molto più comodo l'utilizzo dal DBmanager - Dott. For. Ludovico Frate, PhD -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
Re: [QGIS-it-user] QGIS 3.4.1 e master
Ciao, confermo. Apro il progetto, modifico il layout eliminando alcuni campi, salvo il layout, salvo il progetto. riapro il progetto e ritrovo tutti e 6 i campi. Saluti, Ludovico - Dott. For. Ludovico Frate, PhD -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
Re: [QGIS-it-user] QGIS 3.4.1 e master
Ciao, Totò! Ho aperto il tuo progetto con la 3.4.1 e si vede così: https://drive.google.com/file/d/1Q-quj3EfIMb4iYda23KMHaAlumKFLbCD/view?usp=sharing Non posso provare con la versione 3.5. perché non funziona da qualche giorno a causa di questo errore: https://drive.google.com/file/d/1TrBrAFlIAwtX5fyZPrelDBheVkXj3YPL/view?usp=sharing :-(( Saluti,Gabriela Da: Totò A: qgis-it-user@lists.osgeo.org Inviato: Sabato 17 Novembre 2018 18:49 Oggetto: [QGIS-it-user] QGIS 3.4.1 e master salve lista, molto probabilmente ho acchiappato un altro bug. Allego dati e progetto. Ho realizzato un semplice atlas con un layout banale: una mappa e relativa tabella attributi dell'atlas. La tabella attributi ha 6 campi, ma nel layout configuro la tabella per visualizzare solo i primi due campi. Il bug, fastidiosissimo, ripresenta tutte i campi all successiva apertura del progetto. Ho salvato il progetto con atlas e tabella con soli due campi, aprite il progetto e ditemi se trovate la tabella con tutti i campi visibili. dati e progetto 3.4.1 https://mega.nz/#!hJ4jHKBR!6P1_xRh6TKq1g9FfKA-vWIspzTmoQCfsS0zWEpvDWuU saluti - https://pigrecoinfinito.wordpress.com/ -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
[QGIS-it-user] QGIS 3.4.1 e master
salve lista, molto probabilmente ho acchiappato un altro bug. Allego dati e progetto. Ho realizzato un semplice atlas con un layout banale: una mappa e relativa tabella attributi dell'atlas. La tabella attributi ha 6 campi, ma nel layout configuro la tabella per visualizzare solo i primi due campi. Il bug, fastidiosissimo, ripresenta tutte i campi all successiva apertura del progetto. Ho salvato il progetto con atlas e tabella con soli due campi, aprite il progetto e ditemi se trovate la tabella con tutti i campi visibili. dati e progetto 3.4.1 https://mega.nz/#!hJ4jHKBR!6P1_xRh6TKq1g9FfKA-vWIspzTmoQCfsS0zWEpvDWuU saluti - https://pigrecoinfinito.wordpress.com/ -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html ___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
[Qgis-user] Geo package export/open problems
Hi, I'm having trouble exporting a shapefile as a geo file... according to the log it is written successfully, but when QGIS tries to open it and add to the map it finds that it is invalid. I've checked the geometry of the features and they are all reported to be valid. **Update - seems to work fine when exporting to a test file in my home directory. I've got owner and group access rights to the paths below which are on a CIFS share, so perhaps it is something in the filename which is illegal?** Messages: 2018-11-17T14:53:55 CRITICALInvalid Data Source : /home/samw/Restricted/Projects/S001 New Anglesey/04 GIS + Models/4.2 Working/4.2.1 Datasets/Boundaries/20170517 Construction Zones Geopack/20170517_Construction_Zones.gpkg|layername=20170517_Construction_Zones is not a valid or recognized data source. 2018-11-17T14:53:55 SUCCESSLayer Exported : Successfully saved vector layer to /home/samw/Restricted/Projects/S001 New Anglesey/04 GIS + Models/4.2 Working/4.2.1 Datasets/Boundaries/20170517 Construction Zones Geopack/20170517_Construction_Zones.gpkg OGR log: 2018-11-17T14:53:55 WARNINGCannot open /home/samw/Restricted/Projects/S001 New Anglesey/04 GIS + Models/4.2 Working/4.2.1 Datasets/Boundaries/20170517 Construction Zones Geopack/20170517_Construction_Zones.gpkg.() I'm using 3.4.1 on Ubuntu 18.04: QGIS version: 3.4.1-Madeira QGIS code revision: 383851c Compiled against Qt: 5.9.5 Running against Qt: 5.9.5 Compiled against GDAL/OGR: 2.2.3 Running against GDAL/OGR: 2.2.3 Compiled against GEOS: 3.6.2-CAPI-1.10.2 Running against GEOS: 3.6.2-CAPI-1.10.2 4d2925d6 PostgreSQL Client Version: 10.3 (Ubuntu 10.3-1) SpatiaLite Version: 4.3.0a QWT Version: 6.1.3 QScintilla2 Version: 2.10.2 PROJ.4 Version: 493 Kind regards, Sam. ___ 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] MetaSearch error on launch with clean install
Thanks for the info. What version of QGIS are you using? On which platform? On Fri, Nov 16, 2018 at 6:53 PM knussear wrote: > > Hi All just installed 3.4 on a clean machine. On launch I'm getting the error > > Couldn't load plugin 'MetaSearch' due to an error when calling its > classFactory() method > > Any idea how to fix this? > > THX > > > > -- > 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 ___ 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-it-user] Fwd: [Qgis-community-team] [Qgis-psc] Translating "The question of the Month" survey?
Sì tratta di tradurre il modulo della domanda del mese. I dettagli vanno visti. Grazie Totò! Il 16 novembre 2018 21:39:02 CET, "Totò" ha scritto: >pcav wrote >> C'è qualcuno interessato? > >Presente. >Ma non ho ben capito cosa fare. > >saluti > > > >- >https://pigrecoinfinito.wordpress.com/ >-- >Sent from: >http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html >___ >QGIS-it-user mailing list >QGIS-it-user@lists.osgeo.org >https://lists.osgeo.org/mailman/listinfo/qgis-it-user -- Sorry for being short___ QGIS-it-user mailing list QGIS-it-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/qgis-it-user
Re: [Qgis-user] Plugin development - pyrcc4
since time you can create code to load image or compile UI files dynamically... try to generate a sample code with latest plugin builder and you'll have a sample code where this happen. Luigi Pirelli ** * LinkedIn: https://www.linkedin.com/in/luigipirelli * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli * GitHub: https://github.com/luipir * Mastering QGIS 2nd Edition: * https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition * Hire me: http://goo.gl/BYRQKg ** On Fri, 16 Nov 2018 at 17:59, Frederick Powers wrote: > Greetings, > > Are there any alternatives to using pyrcc4 for compiling resource files > that do not require command line access? > > This is on Windows with QGIS 2.18. > > Thanks > ___ > 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 ___ 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
