[GeoNode-devel] Unable to edit data and style layers from specific geoserver store

[Dimitris Karakostis]

I figured out that there is an extra column on the tables of the
"problematic" database:

gdb_geomattr_data bytea,

It seems like that Geotools don't support the bytea data type (
https://goo.gl/4Rf7XG)


On Thu, Nov 23, 2017 at 1:50 PM, Dimitris Karakostis <
karakostis.dimitris at gmail.com> wrote:

> Hello all,
>
> 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.
>
> This is the error when I try to change styles:
>
> Uncaught TypeError: Cannot read property 'afterEdit' of null
>     at L.afterRuleChange (GeoExplorer.js:1)
>     at L.saveRule (GeoExplorer.js:1)
>     at h.Event.fire (ext-all.js:7)
>     at L.fireEvent (ext-all.js:7)
>     at L.change (GeoExplorer.js:1)
>     at h.Event.fire (ext-all.js:7)
>     at L.fireEvent (ext-all.js:7)
>     at L.change (GeoExplorer.js:1)
>     at h.Event.fire (ext-all.js:7)
>     at L.fireEvent (ext-all.js:7)
>
> And this the error when I try to create/edit data:
>
> ext-all.js:7 Uncaught TypeError: Cannot read property 'render' of undefined
>     at Object.create (ext-all.js:7)
>     at L.<anonymous> (GeoExplorer.js:1)
>     at Ext.util.MixedCollection.each (ext-all.js:7)
>     at constructor.each (ext-all.js:7)
>     at L.initComponent (GeoExplorer.js:1)
>     at L.Ext.Component [as constructor] (ext-all.js:7)
>     at L [as constructor] (ext-base.js:7)
>     at L [as constructor] (ext-base.js:7)
>     at L [as constructor] (ext-base.js:7)
>     at L [as constructor] (ext-base.js:7)
>
>
> I digged in the source code of geoexplorer and it seems like that a
> variable called "store" (gxt specific) is empty.
>
> This is what I have tried till now:
> 1) reinstall django-geoexplorer (also other version) and see if the
> problem persists - It does
> 2) check if its related with permissions of users in database level (nope)
> 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)
> 4) try with latest geonode version (it doesn't work either)
>
> 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.
> And in fact the versions of the two DBs are different:
>
> Working fine version:
> PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit"
> "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 (...)"
>
>
> Not working version:
> "PostgreSQL 9.4.5, compiled by Visual C++ build 1800, 64-bit"
> "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"
>
> Anyone has seen similar behavior?
>
> Thanks
> Dimitris
>
>
>
>
>
>
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20171124/859b94cd/attachment.html>