<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 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.m6130465672422415469m8111834289112050387spelle
{mso-style-name:m_6130465672422415469m8111834289112050387spelle;}
span.m6130465672422415469spelle
{mso-style-name:m_6130465672422415469spelle;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";
mso-fareast-language:FR;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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="FR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN">Hello,<br>
<br>
On my server, I put Geonode 2.5. It was installed in March 2017.<br>
<br>
But my problem is not in the version, but an error in the Geonode code. When I add a new keyword in the documents, it wants to insert it with a depth to null. But this value must be not null in the database. And I also have the impression that the value of
the path is not calculated. Do you know where these actions are done? and what modification can I make?<br>
<br>
In addition, do you have the conceptual model of the data?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN">Mathieu PERDRIEAU</span><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Simone Dalmasso [mailto:simone.dalmasso@gmail.com]
<br>
<b>Envoyé :</b> mercredi 13 décembre 2017 09:02<br>
<b>À :</b> PERDRIEAU Mathieu<br>
<b>Cc :</b> geonode-devel@lists.osgeo.org; geonode-users-bounces@lists.osgeo.org<br>
<b>Objet :</b> Re: [GeoNode-devel] Integrity error<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">2.5 is not available. Do you have the 2.6? How did you install it?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">2017-12-12 13:48 GMT+01:00 PERDRIEAU Mathieu <<a href="mailto:Mathieu.PERDRIEAU@eau-loire-bretagne.fr" target="_blank">Mathieu.PERDRIEAU@eau-loire-bretagne.fr</a>>:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Hi ,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Escuse me, I made a typing error. My geonode run under version 2.5. It is stable?<br>
The error comes from the hierachialkeywords table, the depth value is null. I do not understand why.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Regards,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Mathieu PERDRIEAU</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Simone Dalmasso [mailto:<a href="mailto:simone.dalmasso@gmail.com" target="_blank">simone.dalmasso@gmail.com</a>]
<br>
<b>Envoyé :</b> mardi 12 décembre 2017 11:07<br>
<b>À :</b> PERDRIEAU Mathieu<br>
<b>Cc :</b> <a href="mailto:geonode-users@lists.osgeo.org" target="_blank">geonode-users@lists.osgeo.org</a><br>
<b>Objet :</b> Re: [GeoNode-devel] Integrity error</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi, geonode 2.9 (master) is considered unstable, the suggestion is to use the stable one 2.6 or maybe the 2.7 which is well shaped. We will check this for sure before the release.<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Regards<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">2017-12-12 9:20 GMT+01:00 PERDRIEAU Mathieu <<a href="mailto:Mathieu.PERDRIEAU@eau-loire-bretagne.fr" target="_blank">Mathieu.PERDRIEAU@eau-loire-bretagne.fr</a>>:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Hello all,<br>
<br>
Currently I am having a problem with GeoNode. I use geonode 2.9<br>
My issue is the following :<br>
When I want to add a new keyword to a document I get the following error: </span>
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN" style="color:red">ERROR: A NULL value violates the NOT NULL constraint in the depth column<br>
DETAIL: The failed line contains (71, TestDocumentV2, testdocumentv2_1,, null, 0)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN"><br>
This error only occurs with the documents, did you already meet it? Do you have a solution ?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Thank you
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN">Mathieu PERDRIEAU</span><o:p></o:p></p>
</div>
<div>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td valign="top" style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#1F497D"><img border="0" width="60" height="80" id="m_6130465672422415469_x005f_x0000_i1025" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/AELB-CAS3-Q.gif"></span><br>
<br>
<a href="http://www.facebook.com/pages/Agence-de-leau-Loire-Bretagne/309664692457628" target="_blank"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";text-decoration:none"><img border="0" width="20" height="20" id="m_6130465672422415469_x005f_x0000_i1026" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/Sing-image003-f.jpg" alt="Description : cid:261c336d-b2fa-429f-b771-cf2edf5f7e75"></span></a>
<a href="http://twitter.com/LoireBretagne" target="_blank"><span style="text-decoration:none"><img border="0" width="20" height="20" id="m_6130465672422415469_x005f_x0000_i1027" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/Sing-image004-t.gif" alt="Description : cid:image008.png@01CDF3D6.AF65D5D0"></span></a><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt 7.5pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0092BC">Agence de l'eau
<span class="m6130465672422415469m8111834289112050387spelle">Loire-Bretagne</span></span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0092BC"><br>
<a href="https://maps.google.com/?q=9+avenue+Buffon&entry=gmail&source=g">9 avenue Buffon</a> - CS 36339 - 45063 ORLEANS CEDEX 2<br>
Tél. : 02 38 51 73 73<br>
Etablissement public du ministère chargé du développement durable</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0092BC"><a href="http://www.eau-loire-bretagne.fr/" target="_blank"><span style="color:#0092BC;text-decoration:none">www.eau-loire-bretagne.fr
<br>
</span></a><br>
Pour un bon état des rivières, lacs, nappes et littoral, ensemble, prenons soin de l'eau !
</span></b><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><br>
_______________________________________________<br>
geonode-devel mailing list<br>
<a href="mailto:geonode-devel@lists.osgeo.org" target="_blank">geonode-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-devel" target="_blank">https://lists.osgeo.org/mailman/listinfo/geonode-devel</a><o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">--
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Simone <o:p></o:p></p>
</div>
</div>
</div>
<div>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td valign="top" style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<span style="font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#1F497D"><img border="0" width="60" height="80" id="_x0000_i1028" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/AELB-CAS3-Q.gif"></span><br>
<br>
<a href="http://www.facebook.com/pages/Agence-de-leau-Loire-Bretagne/309664692457628" target="_blank"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";text-decoration:none"><img border="0" width="20" height="20" id="_x0000_i1029" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/Sing-image003-f.jpg" alt="Description : cid:261c336d-b2fa-429f-b771-cf2edf5f7e75"></span></a>
<a href="http://twitter.com/LoireBretagne" target="_blank"><span style="text-decoration:none"><img border="0" width="20" height="20" id="_x0000_i1030" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/Sing-image004-t.gif" alt="Description : cid:image008.png@01CDF3D6.AF65D5D0"></span></a><o:p></o:p></p>
</td>
<td style="padding:.75pt .75pt .75pt 7.5pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0092BC">Agence de l'eau
<span class="m6130465672422415469spelle">Loire-Bretagne</span></span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0092BC"><br>
<a href="https://maps.google.com/?q=9+avenue+Buffon&entry=gmail&source=g">9 avenue Buffon</a> - CS 36339 - 45063 ORLEANS CEDEX 2<br>
Tél. : 02 38 51 73 73<br>
Etablissement public du ministère chargé du développement durable</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0092BC"><a href="http://www.eau-loire-bretagne.fr/" target="_blank"><span style="color:#0092BC;text-decoration:none">www.eau-loire-bretagne.fr
<br>
</span></a><br>
Pour un bon état des rivières, lacs, nappes et littoral, ensemble, prenons soin de l'eau !
</span></b><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<p class="MsoNormal">Simone <o:p></o:p></p>
</div>
</div>
</div>
<div class="Section1">
<table class="MsoNormalTable" border="0" cellpadding="0" style="mso-cellspacing:1.5pt;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt">
<tbody>
<tr style="mso-yfti-irow:0">
<td valign="top" align="center" style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:Tahoma;
color:#1F497D"><![if !vml]><img width="60" height="80" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/AELB-CAS3-Q.gif" v:shapes="_x0000_i1025"><![endif]><o:p></o:p></span>
<br>
<br>
<a href="http://www.facebook.com/pages/Agence-de-leau-Loire-Bretagne/309664692457628" target="_blank"><span style="font-size:10.0pt;font-family:Tahoma;text-decoration:
none;text-underline:none"><![if !vml]><img border="0" width="20" height="20" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/Sing-image003-f.jpg" alt="Description : cid:261c336d-b2fa-429f-b771-cf2edf5f7e75" v:shapes="Image_x0020_1"><![endif]></span></a><span style="mso-spacerun:yes">
</span><a href="http://twitter.com/LoireBretagne" target="_blank"><span style="text-decoration:none;text-underline:none"><![if !vml]><img border="0" width="20" height="20" src="http://www.eau-loire-bretagne.fr/images/image/internet/Images/signature/Sing-image004-t.gif" alt="Description : cid:image008.png@01CDF3D6.AF65D5D0" v:shapes="Image_x0020_2"><![endif]></span></a><b><o:p></o:p></b></p>
</td>
<td style="padding:.75pt .75pt .75pt 7.5pt">
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:Arial;
color:#0092BC">Agence de l'eau
<span class="SpellE">Loire-Bretagne</span></span></b><span style="font-size:9.0pt;font-family:Arial;color:#0092BC"><br>
9 avenue Buffon - CS 36339 - 45063 ORLEANS CEDEX 2<br>
Tél. : 02 38 51 73 73<br>
Etablissement public du ministère chargé du développement durable<o:p></o:p></span></p>
<p class="MsoNormal"><b style="mso-bidi-font-weight:normal"><span style="font-size:9.0pt;font-family:Arial;color:#0092BC"><a href="http://www.eau-loire-bretagne.fr/"><span style="color:#0092BC;
text-decoration:none;text-underline:none">www.eau-loire-bretagne.fr
<br>
</a><br>
Pour un bon état des rivières, lacs, nappes et littoral, ensemble, prenons soin de l'eau !
<br>
</span></span></b></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>