Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Edit in attribute table fails on ArcGIS REST Server if double quotion marks or backslash are involved. Regression #55946

Closed
2 tasks done
bru500 opened this issue Jan 23, 2024 · 0 comments · Fixed by #56492
Closed
2 tasks done
Labels
ArcGIS feature server data provider Bug Either a bug report, or a bug fix. Let's hope for the latter! Regression Something which used to work, but doesn't anymore

Comments

@bru500
Copy link

bru500 commented Jan 23, 2024

What is the bug or the crash?

I have an annual task, where I update data on ArcGIS Online directly with QGIS (ArcGIS feature server data provider).
A year ago, I realised, that edits of text attributes failed silently, if the characters "+" or "&" were involved. I filled Issues #51509 which was fixed by #51636.
Now in QGIS 3.28.12 "+" and "&" work finde, but now " (double quote mark) fail silently. In QGIS 3.28.2 quote marks worked well. Also '' (backslash) fail silently. In ArcGIS Online I'm able to enter and save '' (a backslash).
I guess the fix #51636 solved the bug for some characters but introduced this regression. I dont' know if '' (backslash) ever worked.
', . - ; : ä ö ü è é à [ ] { } ~ ^ ` + * ç % & / ( ) = ? <>' all work fine.

Steps to reproduce the issue

  1. Crate an empty Feature Service with a text field in ArcGIS Online and publish it to public. Allow public editing.
    
  2. Create a connection from QGIS to ArcGIS Online via ArcGIS REST Servers.
    
  3. Add the Feature Service from ArcGIS Online to an empty QGIS map .
    
  4. Add an new Feature and save. That should work.
    
  5. Edit the text field of the added feature in the attribute table. Enter a " (double quote mark).
    
  6. Leave edit mode and save the edits.
    
  7. Reload the attribute table
    
  8. The edit was not saved
    

Versions

QGIS version 3.28.13-Firenze QGIS code revision 3b4db4f
Qt version 5.15.3
Python version 3.9.5
GDAL/OGR version 3.8.0
PROJ version 9.3.0
EPSG Registry database version v10.094 (2023-08-08)
GEOS version 3.12.1-CAPI-1.18.1
SQLite version 3.41.1
PDAL version 2.6.0
PostgreSQL client version unknown
SpatiaLite version 5.1.0
QWT version 6.1.6
QScintilla2 version 2.13.4
OS version Windows 10 Version 2009
       
Active Python plugins
linking_relation_editor v1.2.0
QgisModelBaker v7.5.2
grassprovider 2.12.99
menu_from_project v2.0.8
MetaSearch 0.3.6
processing 2.12.99
qfieldsync v4.5.0
sagaprovider 2.12.99
slyr 6.2.1
swiss_locator 2.0.6

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

Additional context

No response

@bru500 bru500 added the Bug Either a bug report, or a bug fix. Let's hope for the latter! label Jan 23, 2024
@bru500 bru500 changed the title Edit in attribute table fails on ArcGIS REST Server if double quotion marks are involved. Regression Edit in attribute table fails on ArcGIS REST Server if double quotion marks or backslash are involved. Regression Jan 23, 2024
@agiudiceandrea agiudiceandrea added ArcGIS feature server data provider Regression Something which used to work, but doesn't anymore labels Jan 23, 2024
nyalldawson added a commit to nyalldawson/QGIS that referenced this issue Feb 23, 2024
Seems these characters must be escaped before encoding

Fixes qgis#55946
nyalldawson added a commit that referenced this issue Feb 24, 2024
Seems these characters must be escaped before encoding

Fixes #55946
qgis-bot pushed a commit that referenced this issue Feb 24, 2024
Seems these characters must be escaped before encoding

Fixes #55946
qgis-bot pushed a commit that referenced this issue Feb 24, 2024
Seems these characters must be escaped before encoding

Fixes #55946
nirvn pushed a commit that referenced this issue Feb 25, 2024
Seems these characters must be escaped before encoding

Fixes #55946
qgis-bot pushed a commit that referenced this issue Feb 26, 2024
Seems these characters must be escaped before encoding

Fixes #55946
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
ArcGIS feature server data provider Bug Either a bug report, or a bug fix. Let's hope for the latter! Regression Something which used to work, but doesn't anymore
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants