[mapserver-users] Error using Spatial lite wit MS4W - MapServer 4 Windows - version 3.0.3

[Rahkonen Jukka (MML)]

Hi,

SpatiaLite is sometimes a bit tricky to debug because for example with the spatial index it is not enough that the index exists in the database file. There must also be support for using spatial indexes in the Spatialite binaries which users have on their computers. In case of MS4W that part of Spatialite is C:\ms4w\Apache\cgi-bin\spatialite.dll. That means that the same database file may work for some users and not for some others.

Make a new try with MS4W 3.2.3  and see if it works. I would say that updating just spatialite into your existing 3.0.3 version in not possible without rebuilding the whole stack. At least it would not be reliable.

It may be that you have found a bug in Mapserver. If the VirtualSpatialIndex module is not found it should ideally change the strategy and build query so that it does not try to use the spatial index.

-Jukka Rahkonen-




Lähettäjä: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta Rotenhan von, Wernher
Lähetetty: 17. tammikuuta 2018 12:10
Vastaanottaja: 'mapserver-users at lists.osgeo.org' <mapserver-users at lists.osgeo.org>
Aihe: [mapserver-users] Error using Spatial lite wit MS4W - MapServer 4 Windows - version 3.0.3

Hello List
 When I try to use this layer
Layer
Name Parcelles_SLS
   TYPE POLYGON
   CONNECTIONTYPE OGR
   CONNECTION "SLS_RPG_2017.sqlite"
   # DATA "parcelles_graphiques"

   DATA "select  GEOMETRY   from parcelles_graphiques where  OGC_FID < 1000"
....

I get this error :
msOGRFileNextShape(): OGR error. Unable to query table SpatialIndex for column definitions : no such module: VirtualSpatialIndex.

The db  can be used in Qgis and has a spatial index

And I don't find any help in the web for this error

Greetings from Gemany
Wernher


The information contained in this email is confidential. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, reproduction, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180117/5623e41c/attachment.htm>