[GeoNode-users] "layers_uploadsession" does not exist

[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>:

> 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
> 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/72db081c/attachment.html>