Bug #6146

Offline editing tool broken

Added by Giovanni Manghi 11 months ago. Updated about 15 hours ago.

Status:New Start Date:08/02/2012
Priority:Blocker Due date:
Assigned to:vinayan Parameswaran % Done:

100%

Category:C++ Plugins
Target version:Version 2.0.0
Platform: Patch supplied:Yes
Platform version: Affected version:master
Status info: Causes crash or corruption:No
Resolution:

Description

  • pick a postgis layer
  • put it in off-line mode
  • start editing
  • QGIS won't auto-increment the primary key
  • if no primary key is entered, when synchronizing PostGIS will throw an error saying that gid canoot be NULL
  • the user can manually enter the values for primary keys and synchronizing will work, but then when adding new features PostGIS will throw an error like "_Provider errors: PostGIS error while adding features: ERROR: duplicate key value violates unique constraint "teste_pkey"_"

A regression since 1.7.4? if someone can confirm please tag this as blocker.

History

Updated by Giovanni Manghi 9 months ago

  • Priority changed from High to Blocker

regression confirmed. who is the maintainer?

Updated by Giovanni Manghi 9 months ago

  • Subject changed from Offline editing tool broken(?) to Offline editing tool broken

Updated by Giovanni Manghi 3 months ago

  • Causes crash or corruption changed from No to Yes

tested again on qgis master on Ubuntu, it seg faults the program now when starts creating the SL file.

Updated by Giovanni Manghi 3 months ago

  • Causes crash or corruption changed from Yes to No

Giovanni Manghi wrote:

tested again on qgis master on Ubuntu, it seg faults the program now when starts creating the SL file.

it crashes qgis master also under Windows.

Updated by Giovanni Manghi 3 months ago

On qgis 1.8 on Windows it now returns a

"Could not open the spatialite database"

when trying to put off line some vector.

Updated by vinayan Parameswaran about 1 month ago

  • Assigned to set to vinayan Parameswaran

Updated by vinayan Parameswaran about 1 month ago

  • % Done changed from 0 to 100
  • Patch supplied changed from No to Yes

Updated by Giovanni Manghi 27 days ago

  • Status changed from New to Feedback

https://github.com/qgis/Quantum-GIS/pull/586

fixes it (Thanks Vinayan!)

but right now I can't compile the latest code as it gives an error, so closing this is pending later tests.

cheers!

Updated by vinayan Parameswaran 27 days ago

Giovanni,
Pull request was merged today..so you should be able to test master
cheers!

Updated by Giovanni Manghi 27 days ago

vinayan Parameswaran wrote:

Giovanni, Pull request was merged today..so you should be able to test master cheers!

yes, problem is that the latest code revision is not compiling for me right now, so I must wait for a new build for Ubuntu and/or Windows.

cheers!

Updated by Giovanni Manghi 19 days ago

Hi, I just tested https://github.com/qgis/Quantum-GIS/pull/586 on Windows/osgeo4w (will do also on Linux) and does not work.

What I see:

I add a PostGIS layer

click on "convert to offline project"

it is asked to save a SL DB and choose the postgis layer to put offline

when clicking "ok" the SL is created but...

the layer in the TOC remain the PostGIS one (it shold show also a "offline" in layer name, as it did in 1.7.4)

the SL DB is empty

the synchronize button is active, when clicked causes qgis to crash

Updated by Giovanni Manghi 18 days ago

Giovanni Manghi wrote:

Hi, I just tested https://github.com/qgis/Quantum-GIS/pull/586 on Windows/osgeo4w (will do also on Linux) and does not work.

What I see:

I add a PostGIS layer

click on "convert to offline project"

it is asked to save a SL DB and choose the postgis layer to put offline

when clicking "ok" the SL is created but...

the layer in the TOC remain the PostGIS one (it shold show also a "offline" in layer name, as it did in 1.7.4)

the SL DB is empty

the synchronize button is active, when clicked causes qgis to crash

on Linux it seems to work. There is always the (huge) issue (http://hub.qgis.org/issues/7550) when splitting geometries, that is broken with SL and PostGIS and affects obviously also the off-line tool.

Updated by Giovanni Manghi 18 days ago

  • Status changed from Feedback to New

Updated by vinayan Parameswaran 15 days ago

Hi Giovanni,
I have submitted a pull that addresses the issue in windows..
https://github.com/qgis/Quantum-GIS/pull/634

Updated by vinayan Parameswaran about 15 hours ago

Hi Giovanni,

got time to test this?

Also available in: Atom PDF