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
248 stars 141 forks source link

Error with "form filter" tool on a GeoPackage #4374

Open katagen opened 2 months ago

katagen commented 2 months ago

What is the bug? (in English)

I have a projet which works perfectly, also the filter option. But in my log panel, when I use the filter, which works, I have this error: 2024-04-19 10:05:49 192.168.200.1 lizmapadmin Erreur dans la requête (no such function: GeomFromGPB ( SELECT AsGeoJSON(Extent(Transform(GeomFromGPB("geom"), 2056)), 8, 1) AS bbox FROM mamm WHERE 2>1 AND ( "Famille" IN ( 'Felidae' ) )))

What does it mean?

Steps to reproduce the issue

See above.

Versions, safeguards, check summary etc

Versions :

List of safeguards :
* Mode : normal * Allow parent folder : no * Prevent other drive : yes * Prevent PG service : no * Prevent PG Auth DB : yes * Force PG user&pass : yes * Prevent ECW : yes

Check Lizmap plugin

Operating system

Ubuntu 22.04

Browsers

Firefox, Chrome, Safari

Browsers version

LTR

Relevant log output

2024-04-19 10:05:49 192.168.200.1   lizmapadmin Erreur dans la requête (no such function: GeomFromGPB ( SELECT AsGeoJSON(Extent(Transform(GeomFromGPB("geom"), 2056)), 8, 1) AS bbox FROM mamm WHERE 2>1 AND ( "Famille" IN ( 'Felidae' ) )))
Gustry commented 2 months ago

Did you look on the internet ?

no such function: GeomFromGPB

Looks like linked to Spatialite/GPKG ? Is-it your case ?

katagen commented 2 months ago

I have seen that it is liked to geopackage, but what I don't understand it is why I have this error. In your documentation, it is specified that 'form filtering' wokrs with Geopackage. works So I have a Geopackage, with the layer "mamm" inside. The primary key is "fid". gpkg In the plugin, I set the form filtering like that: plugin On the webpage, I have the filter panel, which works, and the filtering is working (a bit slow). The filter panel with no filter selected: sans With only the insectivora order selected: avec So I don't understand the error...

arno974 commented 1 month ago

Did you install the php spatialite extension http://www.gaia-gis.it/gaia-sins/spatialite-cookbook-fr/html/php.html ?

katagen commented 1 month ago

I have install the package php-sqlite3... but it is said nowhere to change the php.ini file (not in Qgis server installation manual, or in Lizmap)?!?

And It seems to works... I just have the error message?!? And I use geopackage, not sqlite... or did I miss something?

Gustry commented 1 month ago

And It seems to works... I just have the error message?!?

What do you mean, does it work ? Geopackage is a subset of sqlite because a Geopackage file IS a sqlite file. A package php-sqlite3 won't be written in QGIS Server doc, QGIS is not using PHP. I see this package mentioned in the documentation https://docs.lizmap.com/current/en/install/linux.html

katagen commented 1 month ago

As you can see in the screenshots, the filtering is working... but I have the error message in the panle of Lizmap. The error message only appears when I use the "form filter" tool on geopackage layers

I have installed php-sqlite3. What I didn't do, is to edit the php.ini file, as mentioned here: https://www.gaia-gis.it/gaia-sins/spatialite-cookbook-fr/html/php.html

Cause in Lizmap documentation, it is for "editing" spatialite layers, which I don't use (only geopackage and PostGIS layers).