TotalNoobOnGIS
commented
3 years ago Somehow this is related to postgresql version
Original problem is happening when layer is stored in postgresql 13.3 and edit is started
I did copy the same table(layer) to another machine where i have postgresql 10.3 running. And then added that layer to the original qgis project.
Result: layer on pg 13.3: Add operation fails like described above layer on pg 10.3: Add operation is working perfectly
below browser log after adding a feature to layer which is in pg10.3
What is the bug?
After selecting postgis point layer for editing and pressing the "Add" button nothing halppens - connection/jelix error. layer coming from postgresql 13.3-2 and visible on the map as expected qgs-file contains pgsql credentials and layer test on qgis server passed
From the browser i can see that
And lizmap error log says: 2021-08-19 07:28:27 127.0.0.1 error 2021-08-19 07:28:27 [402] virhe yhteyden my_server_ip_addr aikana D:\webserver\lizmap\prod\release_3_4_4\lib\jelix\plugins\db\pgsql\pgsql.dbconnection.php 166
Steps to reproduce the issue
launch lizmap project postgis layers can be seen on the map, selecting a feature the popup is displayed with correct attributes select edit tool select postgis layer to be edited press Add-button progress indicator displayed - not able to add point to postgis layer
Lizmap version
3.4.4
QGIS desktop version
3.20-1
QGIS server version
3.20-1
Operating system
Windows Server 2016
Browsers
Firefox
Browsers version
Firefox 90.2
Relevant log output
No response