[GeoNode-users] "layers_uploadsession" does not exist

[Christian Willmes]

Thanks, this was helpful. Anyway, I had to do an additional 'geonode 
updatelayers'. Without it no data would be shown...

Cheers,
Christian

Am 07.07.2015 um 15:49 schrieb Simone Dalmasso:
> Christian, in your case the backup preserver the old schema. Although 
> since the difference in the new schema is a single column being added, 
> you can use the "geonode syncdb --no-initial-data"  before loading 
> back the backup. The syncdb will create the new schema and the backup 
> should load leaving the new column blank. The --no-initial-data will 
> make sure that syncdb only creates the schema without loading any 
> fixture.
>
> Hope this helps.
>
> 2015-07-07 14:48 GMT+02:00 Christian Willmes 
> <christian.willmes at googlemail.com 
> <mailto:christian.willmes at googlemail.com>>:
>
>     Hi,
>
>     following up on this thread:
>     https://github.com/GeoNode/geonode/issues/2046
>
>     I did the sugested steps, but the upload problem persits. No
>     wonder, because in which step should the 'layers_uploadsession'
>     session be created?
>
>     The erreor inthe apache log looks like:
>     [Tue Jul 07 07:39:11.377817 2015] [:error] [pid 22673:tid
>     139958275774208] column "context" of relation
>     "layers_uploadsession" does not exist
>     [Tue Jul 07 07:39:11.377877 2015] [:error] [pid 22673:tid
>     139958275774208] LINE 1: ...e", "user_id", "processed", "error",
>     "traceback", "context")...
>     [Tue Jul 07 07:39:11.377884 2015] [:error] [pid 22673:tid
>     139958275774208] ^
>     [Tue Jul 07 07:39:11.377898 2015] [:error] [pid 22673:tid
>     139958275774208] Traceback (most recent call last):
>     [Tue Jul 07 07:39:11.377904 2015] [:error] [pid 22673:tid
>     139958275774208]   File
>     "/usr/local/lib/python2.7/dist-packages/geonode/layers/views.py"
>     [....]
>
>
>     I did exactly the following (from
>     http://docs.geonode.org/en/master/tutorials/admin/backup/index.html):
>
>     sudo -u postgres -i pg_dump -c -Fc geonode > geonodedb.backup
>
>
>     sudo service apache2 stop
>     sudo /etc/init.d/tomcat7 stop
>
>     sudo service postgresql start
>     sudo -u postgres -i "psql -c 'drop database geonode;'"
>     sudo -u postgres -i "psql -c 'create database geonode;'"
>     sudo -u postgres -s "pg_restore -Fc -d geonode
>     /path/to/geonodedb.backup"
>
>     sudo service apache2 start
>     sudo /etc/init.d/tomcat7 start
>
>     ----
>
>     How can I solve this problem?
>
>     Best regards,
>     Christian
>
>     _______________________________________________
>     geonode-users mailing list
>     geonode-users at lists.osgeo.org <mailto:geonode-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users
>
>
>
>
> -- 
> Simone

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150707/3611ca54/attachment.html>