Bug report #7881

WFS-T client on master cannot commit changes

Added by Giovanni Manghi over 6 years ago. Updated over 6 years ago.

Status:Closed
Priority:Severe/Regression
Assignee:-
Category:QGIS Server
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed
Crashes QGIS or corrupts data:No Copied to github as #:16755

Description

The "add features" button is always disabled in when editing a WFS-T layer on master. It works on QGIS 1.8.

Tested with both QGIS Server and TinyOWS server.

History

#1 Updated by Giovanni Manghi over 6 years ago

  • Subject changed from WFS-T client on master cannot add features to WFS-T client on master cannot commit changes

The "add feature" button is now active, but any try to commit an edit (on a wfs layer that in the server is a postgis layer) results in

Errors: ERROR: 1 feature(s) not added.

#2 Updated by Salvatore Larosa over 6 years ago

Confirmed here with the same error!

#3 Updated by Salvatore Larosa over 6 years ago

just tried on Lisboa and I got the same error !

my testcase is with http://lrssvt.ns0.it/cgi-bin/wfs_catasto/qgis_mapserv.fcgi?SERVICE=WFS&REQUEST=GetCapabilities
that may be used for your tests too.

delete and update operations work properly both master and 1.8.

#4 Updated by Giovanni Manghi over 6 years ago

Salvatore Larosa wrote:

just tried on Lisboa and I got the same error !

my testcase is with http://lrssvt.ns0.it/cgi-bin/wfs_catasto/qgis_mapserv.fcgi?SERVICE=WFS&REQUEST=GetCapabilities
that may be used for your tests too.

delete and update operations work properly both master and 1.8.

with

http://mapserver.uevora.pt/cgi-bin/qgis_mapserv.fcgi?map=/home/mapserver/wfs/test_wfs.qgs

it it fails also with update and delete (the layer is a polygon one, "evora_pg_wfst", and it has the right permissions).

#5 Updated by Giovanni Manghi over 6 years ago

delete and update operations work properly both master and 1.8.

I tested also 1.8, and now oddly it fails (all kind of edit operations) also in 1.8 (I'm sure that when I originally filed the ticket it worked).

#6 Updated by Giovanni Manghi over 6 years ago

update and delete now works, adding still does not.

#8 Updated by Salvatore Larosa over 6 years ago

I am not sure if this may be considered a WFS Client issue.
I think it is a QGIS Server issue. WFS-T created with QGIS Server and PostGIS layers
doesn't enable you to add new features while if WFS-T has been created with SHP layer everything works fine!

Do you think these are two different issues ?

#9 Updated by Giovanni Manghi over 6 years ago

  • Category changed from Web Services clients/WFS to QGIS Server

#10 Updated by Salvatore Larosa over 6 years ago

The point is:

------------------------------------------
Data Provider | Update | Insert | Delete
------------------------------------------
Spatialite    |  Yes   |  Yes   |  Yes
------------------------------------------
Shapefile     |  Yes   |  Yes   |  Yes
------------------------------------------
PostGIS       |  Yes   |  No    |  Yes
------------------------------------------

#11 Updated by Giovanni Manghi over 6 years ago

Salvatore Larosa wrote:

The point is:

[...]

I don't think that SL is supported at all by wfs-t, but not sure 100%

#12 Updated by Jürgen Fischer over 6 years ago

Salvatore Larosa wrote:

The point is:

[...]

does the user running the mapserver have r/w access to the sqlite database and the directory it's in?

#13 Updated by Salvatore Larosa over 6 years ago

Jürgen Fischer wrote:

does the user running the mapserver have r/w access to the sqlite database and the directory it's in?

Yes, the www-data user has rw access to the DB.

#14 Updated by Jürgen Fischer over 6 years ago

Salvatore Larosa wrote:

Jürgen Fischer wrote:

does the user running the mapserver have r/w access to the sqlite database and the directory it's in?

Yes, the www-data user has rw access to the DB.

And the directory?

#15 Updated by Salvatore Larosa over 6 years ago

Jürgen Fischer wrote:

Salvatore Larosa wrote:

Jürgen Fischer wrote:

does the user running the mapserver have r/w access to the sqlite database and the directory it's in?

Yes, the www-data user has rw access to the DB.

And the directory?

Sorry Jürgen for this, I updated the comment 10 with three Yes for Spatialite provider.
Directory was without write access for www-data.

#16 Updated by Jürgen Fischer over 6 years ago

  • Status changed from Open to Feedback

Did you try to add/update multilines/multipoints in postgis? That should be solved with 95874fe8b3

#17 Updated by Salvatore Larosa over 6 years ago

I just tried to add a multiline but it has not worked for me.

#18 Updated by Jürgen Fischer over 6 years ago

Salvatore Larosa wrote:

I just tried to add a multiline but it has not worked for me.

Try with 6d48f11e5 please.

#19 Updated by Salvatore Larosa over 6 years ago

Works, even with my testcase in comment 3.
I think this may be closed.

Thanks a lot!

#20 Updated by Giovanni Manghi over 6 years ago

  • Status changed from Feedback to Closed
  • Resolution set to fixed

Salvatore Larosa wrote:

Works, even with my testcase in comment 3.
I think this may be closed.

Thanks a lot!

I cannot compile until tomorrow, but hey, if it works... it works! :) Thanks Jurgen and Salvatore!

Also available in: Atom PDF