<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div>Hi Fabio,</div>
<div><br>
</div>
<div dir="auto" style="text-align: left;">I uploaded to the server the .qgs file, so no problem.</div>
<div dir="auto" style="text-align: left;"><br>
</div>
<div dir="auto" style="text-align: left;">Regarding the relative paths I created the same folder structure I have locally in the server.</div>
<div dir="auto" style="text-align: left;"><br>
</div>
<div dir="auto" style="text-align: left;">Should I set something in the project properties or in the config file edited by lizmap plugin?</div>
<div dir="auto" style="text-align: left;"><br>
</div>
<div dir="auto" style="text-align: left;">I'm using CSV files and one geopackage.</div>
<div dir="auto" style="text-align: left;"><br>
</div>
<div dir="auto" style="text-align: left;">Eugenio</div>
<div dir="auto" style="text-align: left;"><br>
</div>
<div dir="auto" style="text-align: left;"><br>
</div>
<div id="id-d7b2d685-d184-4ea6-ab0c-175588c6780f" class="ms-outlook-mobile-reference-message">
<div style="font-family: sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg"><strong>From:</strong> Fabio Pifferini <Fabio.Pifferini@masotti.ch><br>
<strong>Sent:</strong> Friday, 23 October 2020, 19:23<br>
<strong>To:</strong> Eugenio Trumpy; lizmap@lists.osgeo.org<br>
<strong>Subject:</strong> R: layers not available<br>
</div>
<br>
<meta content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Consolas}
@font-face
{font-family:Monaco}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New"}
span.PreformattatoHTMLCarattere
{font-family:Consolas}
p.p1, li.p1, div.p1
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.s1
{}
span.apple-converted-space
{}
span.StileMessaggioDiPostaElettronica23
{font-family:"Calibri",sans-serif;
color:windowtext}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:70.85pt 2.0cm 2.0cm 2.0cm}
div.WordSection1
{}
-->
</style>
<div class="WordSection1">
<p class="MsoNormal"><span style="">Hi Eugenio,</span></p>
<p class="MsoNormal"><span style=""> </span></p>
<p class="MsoNormal"><span lang="DE-CH" style="">The project file ist he compressed version *.qgz or the uncompressed *.qgs ?</span></p>
<p class="MsoNormal"><span lang="DE-CH" style="">Lizmap only work with *.qgs.</span></p>
<p class="MsoNormal"><span style=""> </span></p>
<p class="MsoNormal"><span lang="DE-CH" style="">The qgis project files (in proprieties), all the layer have to be related to relative path !</span></p>
<p class="MsoNormal"><span lang="DE-CH" style="">What kind of files you have fort he layers?</span></p>
<p class="MsoNormal"><span lang="DE-CH" style=""> </span></p>
<p class="MsoNormal"><span lang="DE-CH" style="">Fabio</span></p>
<p class="MsoNormal"><span lang="DE-CH" style=""> </span></p>
<p class="MsoNormal"><span lang="DE-CH" style=""> </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</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black">Hi all, </span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </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.</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:</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.</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </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 </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,</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.</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.</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </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,</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.</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></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.</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </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</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.</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt; color:black">I got not crucial log line:</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt; color:black"> </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"></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt; color:black"> </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?</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black">Cheers,</span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt; color:black">Eugenio</span></p>
</div>
<pre><span lang="DE-CH"> </span></pre>
<pre><span lang="DE-CH">-- </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></pre>
</div>
<pre>--
This email was Anti Virus checked by Astaro Security Gateway. http://www.sophos.com</pre>
<br>
</div>
</body>
</html>