SQL statement error: near \")\": syntax error

MerginMaps / geodiff

Library for handling diffs for geospatial data

https://merginmaps.com

MIT License

146 stars 16 forks source link

SQL statement error: near \")\": syntax error #134

Open tomasMizera opened 3 years ago

tomasMizera commented 3 years ago

There is an error in Input logs coming from GEODIFF: GEODIFF error: SQL statement error: near \")\": syntax error\n"

Probably issue with escaping. It is printed every time one goes from map to projects list

wonder-sk commented 3 years ago

Could you please check backtrace where is it coming from? Just wondering if it is geodiff issue or input issue. Which version of geodiff by the way?

tomasMizera commented 3 years ago

Finally found a project that causes this issue. It is tomas/SlovakiaTrees. If this project is not downloaded, I can not see that log.

When I try to open local changes of the project, I only see:

"GEODIFF error: SQL statement error: near \")\": syntax error\n"
"GEODIFF error: SQL statement error: near \")\": syntax error\n"
"MerginProjectStatusModel: Diff summary JSON for /home/.../projects/SlovakiaTrees in layers.gpkg has an error.\n"

can not see local changes. Maybe it is just some project misconfiguration, project opens normally in Input.

wonder-sk commented 3 years ago

Cool - can you please share the project with me? I would have a look why geodiff is failing there... my suspicion is that it could be this bug https://github.com/lutraconsulting/geodiff/issues/137

tomasMizera commented 3 years ago

The project is public tomas/SlovakiaTrees https://public.cloudmergin.com/projects/tomas/SlovakiaTrees/tree

PeterPetrik commented 2 years ago

@wonder-sk is it fixed now with #137 merged?