<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'>Ok, <br><br>that could be a solution.<br>However if I wanted to use the dev version can I use the db backup?<br><br>So the tasks would be: 1- dump DBs 2-update geonode and DBs 3-restore data in the DBs 4- syncdb and updatelayers<br><br>Is that correct?<br><br>E.<br><br><div><hr id="stopSpelling">From: simone.dalmasso@gmail.com<br>Date: Thu, 3 Dec 2015 16:03:22 +0100<br>Subject: Re: [GeoNode-users] geonode no maps and layer<br>To: frippe12573@hotmail.com<br>CC: geonode-users@lists.osgeo.org<br><br><div dir="ltr">Hi Eugenio,<div><br></div><div>I think that you pulled from master, but on master we introduced new developments that involve metadata change. If you can't migrate the db by your own I suggest you to revert to the 2.4.0 tag.</div></div><div class="ecxgmail_extra"><br><div class="ecxgmail_quote">2015-12-03 15:48 GMT+01:00 Eugenio Trumpy <span dir="ltr"><<a href="mailto:frippe12573@hotmail.com" target="_blank">frippe12573@hotmail.com</a>></span>:<br><blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex;">
<div><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<span class="ecxHOEnZb"><font color="#888888"><br><br>Eugenio <br> </font></span></div></div>
<br>_______________________________________________<br>
geonode-users mailing list<br>
<a href="mailto:geonode-users@lists.osgeo.org">geonode-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/geonode-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/geonode-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="ecxgmail_signature">Simone </div>
</div></div> </div></body>
</html>