search

3liz / lizmap-web-client

Transfer a QGIS project on a server, Lizmap is providing the web interface to browse it
https://www.lizmap.com
Mozilla Public License 2.0
257 stars 143 forks source link

[Bug]: German Umlaut #3153

Closed PeterZamudio closed 2 years ago

PeterZamudio commented 2 years ago

What is the bug?

Hello In Usergroups and rights I created a new group called Friedhof Schüpfheim. I then saw that the ü was wrongly displayed in the list. Friedhof Schüpfheim (friedhof_sch�pfheim)

I tried to delete it and it is not possible. It says group deleted but it's still there.

To test is I created a group Entlebuch and deleted it again. This worked fine.

Is there any way I can delete the group?

Thank you for your help

Peter

Steps to reproduce the issue

In Usergroups and rights I created a new group called Friedhof Schüpfheim. I then saw that the ü was wrongly displayed in the list. Friedhof Schüpfheim (friedhof_sch�pfheim)

I tried to delete it and it is not possible. It says group deleted but it's still there.

To test is I created a group Entlebuch and deleted it again. This worked fine.

Versions

QGIS 3.10 Lizmaps 3.5

Check Lizmap plugin

QGIS server version, only if the section above doesn't mention the QGIS Server version

3.10

Operating system

Windows 10

Browsers

Firefox

Browsers version

Firefox 103.0.1

Relevant log output

No response

PeterZamudio commented 2 years ago

Hello Laurentj

Thank you for taking on the problem. I hope there will be a solution as the problem is still there for me and all German speaking people, and others with special symbols.

Best regards Peter

laurentj commented 2 years ago

Hi @PeterZamudio : I did some tests and I don't reproduce the issue.

Gustry commented 2 years ago

@PeterZamudio Please right click on your server in the Lizmap QGIS desktop plugin and then choose "Copy versions in your clipboard", like it was mention in the ticket template.

PeterZamudio commented 2 years ago

Thank you for getting back to me.

Versions :

I am not sure where the Lizmaps saves the configuration data. Is there somewhere I can look? The QGIS projects are saved in Postgres on the server where the QGIS Servers is running too. The Server is a Windows Server. That is where Lizmaps is running too with Apache

Here you see the 3rd line is empty due to the error: LizmapConfiguration

Here you can see the group with the faulty name in the 2nd group LizmapUserGroup

Gustry commented 2 years ago

QGIS Server and plugins unknown status because the login provided is not an administrator

You should try to provide an administrator login, it would provide more information next time. As it's written in the plugin.

I am not sure where the Lizmaps saves the configuration data. Is there somewhere I can look?

https://docs.lizmap.com/current/fr/install/linux.html#postgresql

look at [jdb:jauth] if you are using SQLite or PG.

The QGIS projects are saved in Postgres on the server where the QGIS Servers is running too.

Maybe, but Lizmap is not using these projects. Lizmap needs QGS file based projects.

laurentj commented 2 years ago

Do you know the version of PHP?

PeterZamudio commented 2 years ago

@Gustry: I will try and do as you say.

@laurentj: The PHP is PHP74 running on Apache24

Thank you both

PeterZamudio commented 2 years ago

Hello all

I have solved the problem on my own. I found out that Lizmap saves the user data in a SQLite database. I opened the database with DB Browser for SQLite and found the table with the error. I deleted the line with the error. Checked in the Administration and the error was gone in the user groups and rights.

After checking I can say everything is working OK now.

I will make sure I don't use and German special letters from now on.

Thank you for trying to help. For me the problem is now solved. We can close this issue.

Gustry commented 2 years ago

I will make sure I don't use and German special letters from now on.

I think we tried to insert, but we couldn't, no ? Maybe one day, you or us will forget about this hack. So better to fix it if you can reproduce the issue ! Let's close as we couldn't test on our side.