<div dir="ltr">I figured out that there is an extra column on the tables of the "problematic" database:<div><br></div><div>gdb_geomattr_data bytea,<br></div><div><br></div><div>It seems like that Geotools don't support the bytea data type (<span style="color:rgb(68,68,68);font-family:Roboto,Helvetica,Arial,sans-serif;font-size:13px"><a href="https://goo.gl/4Rf7XG">https://goo.gl/4Rf7XG</a>)</span></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 23, 2017 at 1:50 PM, Dimitris Karakostis <span dir="ltr"><<a href="mailto:karakostis.dimitris@gmail.com" target="_blank">karakostis.dimitris@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello all, <div><br></div><div>I've been getting some errors when I try to edit values of some layers with geoexplorer or when I try to change the style. All of the layers, which give this error belong to a specific geoserver store, which is connected to a postgresql DB. All the other layers (belonging to other store and postgresql DB) can be edited without any errors. </div><div><br></div><div>This is the error when I try to change styles:</div><div><br></div><div><div>Uncaught TypeError: Cannot read property 'afterEdit' of null</div><div> at L.afterRuleChange (GeoExplorer.js:1)</div><div> at L.saveRule (GeoExplorer.js:1)</div><div> at h.Event.fire (ext-all.js:7)</div><div> at L.fireEvent (ext-all.js:7)</div><div> at L.change (GeoExplorer.js:1)</div><div> at h.Event.fire (ext-all.js:7)</div><div> at L.fireEvent (ext-all.js:7)</div><div> at L.change (GeoExplorer.js:1)</div><div> at h.Event.fire (ext-all.js:7)</div><div> at L.fireEvent (ext-all.js:7)</div></div><div><br></div><div>And this the error when I try to create/edit data:</div><div><br></div><div><div>ext-all.js:7 Uncaught TypeError: Cannot read property 'render' of undefined</div><div> at Object.create (ext-all.js:7)</div><div> at L.<anonymous> (GeoExplorer.js:1)</div><div> at Ext.util.MixedCollection.each (ext-all.js:7)</div><div> at constructor.each (ext-all.js:7)</div><div> at L.initComponent (GeoExplorer.js:1)</div><div> at L.Ext.Component [as constructor] (ext-all.js:7)</div><div> at L [as constructor] (ext-base.js:7)</div><div> at L [as constructor] (ext-base.js:7)</div><div> at L [as constructor] (ext-base.js:7)</div><div> at L [as constructor] (ext-base.js:7)</div></div><div><br></div><div><br></div><div>I digged in the source code of geoexplorer and it seems like that a variable called "store" (gxt specific) is empty. </div><div><br></div><div>This is what I have tried till now:</div><div>1) reinstall django-geoexplorer (also other version) and see if the problem persists - It does</div><div>2) check if its related with permissions of users in database level (nope)</div><div>3) recreate the layers and run updatelayers function (when doing this then some of the layers can be styled but the edit data functionality doesn't work)</div><div>4) try with latest geonode version (it doesn't work either)</div><div><br></div><div>We have another instance of this data in another server and when I connect to it, everything works fine. This made me thing that perhaps its a DB version related issue.</div><div>And in fact the versions of the two DBs are different:</div><div><br></div><div>Working fine version:</div><div><div>PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit"</div><div>"POSTGIS="2.0.6" GEOS="3.4.2-CAPI-1.8.2 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.0.6" need upgrade) TOPOLOGY (topology procs from "2.0.6" need upgrade) RASTER (raster pr (...)"</div></div><div><br></div><div><br></div><div>Not working version:</div><div><div>"PostgreSQL 9.4.5, compiled by Visual C++ build 1800, 64-bit"</div><div>"POSTGIS="2.2.3 r15172" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.1.1, released 2016/07/07" LIBXML="2.7.8" LIBJSON="0.12" RASTER"</div></div><div><br></div><div>Anyone has seen similar behavior?</div><div><br></div><div>Thanks</div><span class="HOEnZb"><font color="#888888"><div>Dimitris</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div> </div><div><br></div><div><br></div><div><br></div><div><br></div></font></span></div>
</blockquote></div><br></div>