<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi all,<br><br>today I controlled my geonode home page. It seemed to work fine, since the home page<br>showed 15 layers and 5 maps. However if I click on layers, any layers appears in the list.<br>The same happens form maps and documents.<br><br>I tried to launch updatelayers with any result.<br>The I re-sync the DB and updatelayers, but no results, only an error:<br><br>python manage.py updatelayers<br>Not enabling BingMaps base layer as a BING_API_KEY is not defined in local_settings.py file.<br>Stopping process because --ignore-errors was not set and an error was found.<br>Traceback (most recent call last):<br> File "manage.py", line 28, in <module><br> execute_from_command_line(sys.argv)<br> File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 399, in execute_from_command_line<br> utility.execute()<br> File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 392, in execute<br> self.fetch_command(subcommand).run_from_argv(self.argv)<br> File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 242, in run_from_argv<br> self.execute(*args, **options.__dict__)<br> File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 285, in execute<br> output = self.handle(*args, **options)<br> File "/dati/geonode/geonode/geoserver/management/commands/updatelayers.py", line 108, in handle<br> remove_deleted=remove_deleted)<br> File "/dati/geonode/geonode/geoserver/helpers.py", line 458, in gs_slurp<br> "bbox_y1": Decimal(resource.latlon_bbox[3])<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 154, in get_or_create<br> return self.get_queryset().get_or_create(**kwargs)<br> File "/usr/local/lib/python2.7/dist-packages/modeltranslation/manager.py", line 341, in get_or_create<br> return super(MultilingualQuerySet, self).get_or_create(**kwargs)<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 376, in get_or_create<br> return self.get(**lookup), False<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 304, in get<br> num = len(clone)<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 77, in __len__<br> self._fetch_all()<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 857, in _fetch_all<br> self._result_cache = list(self.iterator())<br> File "/usr/local/lib/python2.7/dist-packages/polymorphic/query.py", line 264, in iterator<br> for o in base_iter:<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 220, in iterator<br> for row in compiler.results_iter():<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 713, in results_iter<br> for rows in self.execute_sql(MULTI):<br> File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 786, in execute_sql<br> cursor.execute(sql, params)<br> File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 69, in execute<br> return super(CursorDebugWrapper, self).execute(sql, params)<br> File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute<br> return self.cursor.execute(sql, params)<br> File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 99, in __exit__<br> six.reraise(dj_exc_type, dj_exc_value, traceback)<br> File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 53, in execute<br> return self.cursor.execute(sql, params)<br>Exception: ('Failed to process reg2001_s_wgs84utm33', ProgrammingError('column base_resourcebase.metadata_uploaded_preserve does not exist\nLINE 1: ...ometry", "base_resourcebase"."metadata_uploaded", "base_reso...\n ^\n',))<br><br>Afterwords I updated also the geonode code from git, re-sync DB and updatelayer, but again the same error.<br>I checked the DB, the maps and layer are correctly described in the rows.<br><br>I think it is a connection problem between geonode and postgresql/postgis. Isn't it? If yes, how can I solve?<br><br>Thanks in advance<br><br>Eugenio <br> </div></body>
</html>