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:[email protected]] Puolesta Rotenhan von, Wernher Lähetetty: 17. tammikuuta 2018 12:10 Vastaanottaja: '[email protected]' <[email protected]> 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.
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
