<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=utf-8">
<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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Monaco;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Preformattato HTML Carattere";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.PreformattatoHTMLCarattere
{mso-style-name:"Preformattato HTML Carattere";
mso-style-priority:99;
mso-style-link:"Preformattato HTML";
font-family:Consolas;}
p.p1, li.p1, div.p1
{mso-style-name:p1;
margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.StileMessaggioDiPostaElettronica23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 2.0cm 2.0cm;}
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="IT-CH" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi Eugenio,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">The project file ist he compressed version *.qgz or the uncompressed *.qgs ?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Lizmap only work with *.qgs.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">The qgis project files (in proprieties), all the layer have to be related to relative path !<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">What kind of files you have fort he layers?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Fabio<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><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 lang="IT">Da:</span></b><span lang="IT"> Lizmap <lizmap-bounces@lists.osgeo.org>
<b>Per conto di </b>Eugenio Trumpy<br>
<b>Inviato:</b> venerdì, 23 ottobre 2020 18:50<br>
<b>A:</b> lizmap@lists.osgeo.org<br>
<b>Oggetto:</b> [Lizmap] layers not available<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">Hi all, <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">I'm starting with lizmap 3.3.11 + qgisserver > 3.0 on an ubuntu server 18.04.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">I have already installed and positively checked Qgis server:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">I'm able to visualise the demo world3.qgs in the client browser.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">To start with lizmap I installed the demo repository named 'Montpellier'. I'm able to see <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">the lizmap web client starting page, but if I chose Montpellier demo map,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">I'm only able to see the base map, but not the layers.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">I checked the grants on the different folders, all of the are owned by www-data.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Then I even started a project from scratch, so I created a project on QGIS,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">and I used the lizmap plugin to get the config file.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">So <span style="background:white">
I created the new repository from the lizmap admin pannel and afterword</span><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">I transfered layers (3 vector layers), the config and project file (even the thumbnail) on the server.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">Again I'm able to see the the lizmap webgis interface including the base maps (which I can switch<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">from the frontend) but not the 3 layers.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I got not crucial log line:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<p class="p1" style="background-color:rgba(0, 0, 0, 0.85)"><span class="s1"><span style="font-size:7.5pt;font-family:"Monaco",serif;color:#F2F2F2">SQLite3::query(): Unable to prepare statement: 1, no such table: lizmap_search</span></span><span class="apple-converted-space"><span style="font-size:7.5pt;font-family:"Monaco",serif;color:#F2F2F2">
</span></span><span class="s1"><span style="font-size:7.5pt;font-family:"Monaco",serif;color:#F2F2F2">/var/www/html/lizmap-web-client-3.3.11/lib/jelix/plugins/db/sqlite3/sqlite3.dbconnection.php</span></span><span class="apple-converted-space"><span style="font-size:7.5pt;font-family:"Monaco",serif;color:#F2F2F2">
</span></span><span class="s1"><span style="font-size:7.5pt;font-family:"Monaco",serif;color:#F2F2F2">112</span></span><span style="font-size:7.5pt;font-family:"Monaco",serif;color:#F2F2F2"><o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">Have you got any hint for me?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">Cheers,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;color:black">Eugenio<o:p></o:p></span></p>
</div>
<pre><span lang="DE-CH"><o:p> </o:p></span></pre>
<pre><span lang="DE-CH">-- <o:p></o:p></span></pre>
<pre><span lang="DE-CH">This email was Anti Virus checked by Astaro Security Gateway. </span><a href="http://www.sophos.com">http://www.sophos.com</a><o:p></o:p></pre>
</div>
</body>
</html>
<pre>
--
This email was Anti Virus checked by Astaro Security Gateway. http://www.sophos.com</pre>