<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style="font-family: Calibri, Verdana, Arial, sans-serif; font-size: 11pt;"><div>Sorry it isn't a problem of mapserver.<br></div><div>There is only a problem with permission of public schema. <br></div><div><br></div><div>All the best, </div><div>R</div><div><br></div><br><div data-zbluepencil-ignore="true" id="Zm-_Id_-Sgn"><pre class="moz-signature"><br></pre><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Eng. Roberto Marzocchi,</span></span></i></span><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> PhD</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">CTO - Chief Technology Officer</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Gter srl (Unige spin-off)</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Via Ruffini 9R - 16128 Genova </span></span></i></span><br></div><div><a target="_blank" href="http://P.IVA/CF"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">P.IVA/CF</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> 01998770992 </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">ph: 010-</span></span></i><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">0899150</span></span></i></span><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> - mob: 349-8786575 </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">E-mail: </span></span></i></span><a target="_blank" href="mailto:roberto.marzocchi@gter.it"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">roberto.marzocchi@gter.it</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><a target="_blank" href="http://www.gter.it"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.gter.it</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">-- </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Gter social </span></span></i></span><br></div><div><a target="_blank" href="http://www.twitter.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.twitter.com/Gteronline</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> - </span></span></i></span><a target="_blank" href="http://www.facebook.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.facebook.com/Gteronline</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><a target="_blank" href="http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">----------------------------------------------------------------- </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Please consider the environment before printing this email!</span></span><span class="font" style="font-family:Calibri, Verdana, Arial, sans-serif, sans-serif"> </span></i><br></span></div><div><span class="colour" style="color:rgb(153, 153, 153)"><br></span></div></div><br><div data-zbluepencil-ignore="true" style="" class="zmail_extra"><br><div id="Zm-_Id_-Sgn1">---- Attivato gio, 26 mar 2020 21:56:49 +0100 <b>Roberto Marzocchi <roberto.marzocchi@gter.it></b> ha scritto ----<br></div><br><blockquote style="border-left: 1px solid rgb(204, 204, 204); padding-left: 6px; margin: 0px 0px 0px 5px;"><div><div style="font-family: Calibri, Verdana, Arial, sans-serif;font-size: 11.0pt;"><div>On the server log this is the error:<br></div><div><br></div><div>2020-03-26 21:43:32.939 CET [27786] user@dbname STATEMENT: SELECT postgis_version() <br></div><div>2020-03-26 21:43:34.185 CET [28060] user@dbname ERROR: function postgis_version() does not exist at character 8<br></div><div>2020-03-26 21:43:34.185 CET [28060] user@dbname HINT: No function matches the given name and argument types. You might need to add explicit type casts.<br></div><br><div><pre class="x_916091180moz-signature"><br></pre><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Eng. Roberto Marzocchi,</span></span></i></span><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> PhD</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">CTO - Chief Technology Officer</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Gter srl (Unige spin-off)</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Via Ruffini 9R - 16128 Genova </span></span></i></span><br></div><div><a href="http://P.IVA/CF" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">P.IVA/CF</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> 01998770992 </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">ph: 010-</span></span></i><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">0899150</span></span></i></span><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> - mob: 349-8786575 </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">E-mail: </span></span></i></span><a href="mailto:roberto.marzocchi@gter.it" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">roberto.marzocchi@gter.it</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><a href="http://www.gter.it" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.gter.it</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">-- </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Gter social </span></span></i></span><br></div><div><a href="http://www.twitter.com/Gteronline" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.twitter.com/Gteronline</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> - </span></span></i></span><a href="http://www.facebook.com/Gteronline" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.facebook.com/Gteronline</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><a href="http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis" target="_blank"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">----------------------------------------------------------------- </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Please consider the environment before printing this email!</span></span><span class="font" style="font-family:Calibri, Verdana, Arial, sans-serif, sans-serif"> </span></i><br></span></div><div><span class="colour" style="color:rgb(153, 153, 153)"><br></span></div></div><br><div class="x_916091180zmail_extra"><br><div>---- Attivato gio, 26 mar 2020 21:47:02 +0100 <b>Roberto Marzocchi <<a target="_blank" href="mailto:roberto.marzocchi@gter.it">roberto.marzocchi@gter.it</a>></b> ha scritto ----<br></div><br><div><br></div></div><div><br></div></div><br></div><blockquote style="border-left: 1.0px solid rgb(204,204,204);padding-left: 6.0px;margin: 0.0px 0.0px 0.0px 5.0px;"><div><div style="font-family: Calibri, Verdana, Arial, sans-serif;font-size: 11.0pt;"><div>I have a mapserver 7.0.7 installed on a Ubuntu server 18.04.<br></div><div><br></div><div>I have updated to PostGIS v. 3.0.0 and for some layers I encountered the following error: <br></div><div><br></div><div><?xml version='1.0' encoding="UTF-8" standalone="no" ?><br></div><div><!DOCTYPE ServiceExceptionReport SYSTEM "<a target="_blank" href="http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd</a>"><br></div><div><ServiceExceptionReport version="1.1.1"><br></div><div><ServiceException><br></div><div>msDrawMap(): Image handling error. Failed to draw layer named 'M_vel_10'.<br></div><div>msPostGISRetrieveVersion(): Query error. Error executing SQL. check server logs.<br></div><div></ServiceException><br></div><div></ServiceExceptionReport><br></div><div><br></div><div>Anyone have suggestion?<br></div><div><br></div><div>Thanks in advanced,<br></div><div>R <br></div><div id=""><pre class="x_-1647074912moz-signature"><br></pre><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Eng. Roberto Marzocchi,</span></span></i></span><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> PhD</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">CTO - Chief Technology Officer</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Gter srl (Unige spin-off)</span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Via Ruffini 9R - 16128 Genova </span></span></i></span><br></div><div><a target="_blank" href="http://P.IVA/CF"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">P.IVA/CF</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> 01998770992 </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">ph: 010-</span></span></i><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">0899150</span></span></i></span><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> - mob: 349-8786575 </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">E-mail: </span></span></i></span><a target="_blank" href="mailto:roberto.marzocchi@gter.it"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">roberto.marzocchi@gter.it</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><a target="_blank" href="http://www.gter.it"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.gter.it</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">-- </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Gter social </span></span></i></span><br></div><div><a target="_blank" href="http://www.twitter.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.twitter.com/Gteronline</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> - </span></span></i></span><a target="_blank" href="http://www.facebook.com/Gteronline"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.facebook.com/Gteronline</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><a target="_blank" href="http://www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis"><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">www.linkedin.com/company/gter-srl-innovazione-in-geomatica-gnss-e-gis</span></span></i></span></a><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px"> </span></span></i></span><br></div><div><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">----------------------------------------------------------------- </span></span></i></span><br></div><div><span class="colour" style="color:rgb(153, 153, 153)"><i><span class="font" style="font-family:verdana, sans-serif"><span class="size" style="font-size:10.6667px">Please consider the environment before printing this email!</span></span><span class="font" style="font-family:Calibri, Verdana, Arial, sans-serif, sans-serif"> </span></i><br></span></div><div><span class="colour" style="color:rgb(153, 153, 153)"><br></span></div></div><br><div><br></div></div><br></div></blockquote></blockquote></div><div><br></div></div><br></body></html>