[GeoNode-users] "layers_uploadsession" does not exist

[Christian Willmes]

Hi,

first it seemed to work fine, all layers are back and accessible, but I 
cant edit the metadata of existing layers vie the geonode webapp anymore.
The frontend dies and gives an "Internal Server Error".

The apache error messages look like:
[Thu Jul 09 09:50:53.648422 2015] [:error] [pid 2080:tid 
140415632357120] Internal Server Error: 
/layers/geonode:sealevels_10_150m/metadata
[Thu Jul 09 09:50:53.648484 2015] [:error] [pid 2080:tid 
140415632357120] Traceback (most recent call last):
[...]
[Thu Jul 09 09:50:53.648652 2015] [:error] [pid 2080:tid 
140415632357120] IOError: [Errno 13] Permission denied: 
u'/var/www/geonode/uploaded/thumbs/layer-d680d189-b46f-468e-8267-e8e5b497988c-thumb.png'
[Thu Jul 09 09:50:53.664269 2015] [:error] [pid 2080:tid 
140415632357120] [remote 134.95.150.136:14361] mod_wsgi (pid=2080): 
Exception occurred processing WSGI script 
'/var/www/geonode/wsgi/geonode.wsgi'.
[...]
[Thu Jul 09 09:50:53.665753 2015] [:error] [pid 2080:tid 
140415632357120] [remote 134.95.150.136:14361]   File 
"/usr/lib/python2.7/dist-packages/django/template/context.py", line 56, 
in __getitem__
[Thu Jul 09 09:50:53.665849 2015] [:error] [pid 2080:tid 
140415632357120] [remote 134.95.150.136:14361]     raise KeyError(key)
[Thu Jul 09 09:50:53.665872 2015] [:error] [pid 2080:tid 
140415632357120] [remote 134.95.150.136:14361] KeyError: 'request'


It is the same account name for the superuser.

Additionally all the Categories and Keywords are gone... (that's why I 
wanted to edit the metadata in the first place...)

Any hint on how I can fix this?

Thanks and regards,
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/20150709/8c3e38a6/attachment.html>