[Qgis-developer] Lizmap edit layer

Salvatore Larosa lrssvtml at gmail.com
Fri Sep 19 13:40:10 PDT 2014


Hi,

On Fri, Sep 19, 2014 at 9:15 PM, Mira Maric <mmmxxxm at gmail.com> wrote:
> Hi. I am using lizmap web client form editing layer bus_stops.
> Bus_stops layer is in Postgis database. I am import it to the database
> from the shapefile with SPIT plugin.

Which QGIS and LizMapWC versions ?

>
> When I try to edit layer with lizmap webclient I get next message:
>
> An error occured for : 'SELECT *, ST_AsText() AS astext FROM
> "topology"."bus_stops" WHERE ST_Intersects(
> ST_MakeEnvelope(429253.865738,5407067.308823,429265.809023,5407079.252109,
> 3857 ), ST_Transform(, 3857 ) )', the message:invalid query (ERROR:
> syntax error at or near ","

What the following query returns?:
SELECT type FROM geometry_columns WHERE f_table_name = 'bus_stops' AND
f_table_schema = 'topology'

Why the "bus_stops" table is into the topology schema? I would
recommend you to use a different schema

Regards,
-SL

-- 
Salvatore Larosa
linkedIn: http://linkedin.com/in/larosasalvatore
twitter: @lrssvt
skype: s.larosa
IRC: lrssvt on freenode


More information about the Qgis-developer mailing list