<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.Shkpostityyli17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Shkpostityyli18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FI" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:FI">Lähettäjä:</span></b><span style="mso-fareast-language:FI"> mapserver-users [mailto:mapserver-users-bounces@lists.osgeo.org]
<b>Puolesta </b>Rotenhan von, Wernher<br>
<b>Lähetetty:</b> 17. tammikuuta 2018 12:10<br>
<b>Vastaanottaja:</b> 'mapserver-users@lists.osgeo.org' <mapserver-users@lists.osgeo.org><br>
<b>Aihe:</b> [mapserver-users] Error using Spatial lite wit MS4W - MapServer 4 Windows - version 3.0.3<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">Hello List <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> When I try to use this layer <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR">Layer <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR">Name Parcelles_SLS<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR"> TYPE POLYGON<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR"> </span><span lang="EN-US">CONNECTIONTYPE OGR<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> CONNECTION "SLS_RPG_2017.sqlite"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR"> # DATA “parcelles_graphiques”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="FR"> DATA "select GEOMETRY from parcelles_graphiques where OGC_FID < 1000"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR">….<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="FR">I get this error : <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR">msOGRFileNextShape(): OGR error. </span><span lang="EN-US">Unable to query table SpatialIndex for column definitions : no such module: VirtualSpatialIndex.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The db can be used in Qgis and has a spatial index
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And I don’t find any help in the web for this error
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Greetings from Gemany<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:DE">Wernher<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:FI"><br>
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.
<o:p></o:p></span></p>
</div>
</body>
</html>