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

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

Open
tomasMizera opened this issue Jun 29, 2021 · 5 comments
Open

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

tomasMizera opened this issue Jun 29, 2021 · 5 comments
Labels
bug Something isn't working

Comments

@tomasMizera
Copy link
Contributor

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 tomasMizera changed the title Error in Input logs Syntax error in Input logs Jun 29, 2021
@wonder-sk
Copy link
Contributor

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?

@PeterPetrik PeterPetrik added the bug Something isn't working label Jun 29, 2021
@tomasMizera
Copy link
Contributor Author

tomasMizera commented Aug 4, 2021

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.

@wonder-sk
Copy link
Contributor

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 #137

@tomasMizera
Copy link
Contributor Author

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

@PeterPetrik
Copy link
Contributor

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

@PeterPetrik PeterPetrik changed the title Syntax error in Input logs SQL statement error: near \")\": syntax error Sep 16, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants