geodiff icon indicating copy to clipboard operation
geodiff copied to clipboard

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

Open tomasMizera opened this issue 4 years ago • 5 comments

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

tomasMizera avatar Jun 29 '21 14:06 tomasMizera

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?

wonder-sk avatar Jun 29 '21 14:06 wonder-sk

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"

image

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

tomasMizera avatar Aug 04 '21 08:08 tomasMizera

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

wonder-sk avatar Aug 04 '21 09:08 wonder-sk

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

tomasMizera avatar Aug 04 '21 09:08 tomasMizera

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

PeterPetrik avatar Sep 16 '21 05:09 PeterPetrik