[Qgis-developer] Lizmap edit layer

[Mira Maric]

Hi. Same thing is when I save table in public schema or other schema.
When I run:
SELECT type FROM geometry_columns WHERE f_table_name = 'bus_stops' AND
f_table_schema = 'topology'

I get
Type character varying (30)
POINT


2014-09-19 20:40 GMT+00:00 Salvatore Larosa <lrssvtml at gmail.com>:
> 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