[GeoNode-users] database update error
Eugenio Trumpy
frippe12573 at hotmail.com
Mon Jun 27 05:25:57 PDT 2016
Hi Simone,
thank you for your answer so far.
So my solution is to put the head of my git repo to the once that was working up to the last week, isn't it?
How can I re-set the git head to such version? I don't remember the code version.
Thanks
E.
________________________________
Da: Simone Dalmasso <simone.dalmasso at gmail.com>
Inviato: lunedì 27 giugno 2016 13.16
A: Eugenio Trumpy
Cc: geonode-users at lists.osgeo.org
Oggetto: Re: [GeoNode-users] database update error
Eugenio, sorry for the delay.
I did not have time to test it on postgres so my suggestion at the moment is to stick with the 2.4 stable release.
2016-06-23 11:22 GMT+02:00 Eugenio Trumpy <frippe12573 at hotmail.com<mailto:frippe12573 at hotmail.com>>:
Hi Simone,
django is at 1.8.7 version, is that correct for the master? how can I check the version of the data model?
However, from empty geonode db I run manage.py migrate auth:
System check identified some issues:
WARNINGS:
account.EmailConfirmation.created: (fields.W161) Fixed default value provided.
HINT: It seems you set a fixed date / time / datetime value as default for this field. This may not be what you want. If you want to have the current date as default, use `django.utils.timezone.now`
dialogos.Comment.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Operations to perform:
Apply all migrations: auth
Running migrations:
Rendering model states... DONE
Applying contenttypes.0001_initial... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0001_initial... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Traceback (most recent call last):
File "manage.py", line 29, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 226, in handle
emit_post_migrate_signal(created_models, self.verbosity, self.interactive, connection.alias)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/sql.py", line 280, in emit_post_migrate_signal
using=db)
File "/usr/local/lib/python2.7/dist-packages/django/dispatch/dispatcher.py", line 189, in send
response = receiver(signal=self, sender=sender, **named)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/sites/management.py", line 20, in create_default_site
if not Site.objects.using(using).exists():
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 586, in exists
return self.query.has_results(using=self.db)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 484, in has_results
return compiler.has_results()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 811, in has_results
return bool(self.execute_sql(SINGLE))
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 840, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "django_site" does not exist
LINE 1: SELECT (1) AS "a" FROM "django_site" LIMIT 1
then I run manage.py migrate sites:
System check identified some issues:
WARNINGS:
account.EmailConfirmation.created: (fields.W161) Fixed default value provided.
HINT: It seems you set a fixed date / time / datetime value as default for this field. This may not be what you want. If you want to have the current date as default, use `django.utils.timezone.now`
dialogos.Comment.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Operations to perform:
Apply all migrations: sites
Running migrations:
Rendering model states... DONE
Applying sites.0001_initial... OK
Traceback (most recent call last):
File "manage.py", line 29, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 226, in handle
emit_post_migrate_signal(created_models, self.verbosity, self.interactive, connection.alias)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/sql.py", line 280, in emit_post_migrate_signal
using=db)
File "/usr/local/lib/python2.7/dist-packages/django/dispatch/dispatcher.py", line 189, in send
response = receiver(signal=self, sender=sender, **named)
File "/usr/local/lib/python2.7/dist-packages/guardian/management/__init__.py", line 32, in create_anonymous_user
User.objects.get(pk=guardian_settings.ANONYMOUS_USER_ID)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 328, in get
num = len(clone)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 144, in __len__
self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 965, in _fetch_all
self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 238, in iterator
results = compiler.execute_sql()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 840, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "people_profile" does not exist
LINE 1: ...ofile"."zipcode", "people_profile"."country" FROM "people_pr...
then manage.py migrate people:
System check identified some issues:
WARNINGS:
account.EmailConfirmation.created: (fields.W161) Fixed default value provided.
HINT: It seems you set a fixed date / time / datetime value as default for this field. This may not be what you want. If you want to have the current date as default, use `django.utils.timezone.now`
dialogos.Comment.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Operations to perform:
Apply all migrations: people
Running migrations:
Rendering model states... DONE
Applying taggit.0001_initial... OK
Applying taggit.0002_auto_20150616_2121... OK
Applying people.0001_initial... OK
Applying people.0002_auto_20160623_0404... OK
Traceback (most recent call last):
File "manage.py", line 29, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 226, in handle
emit_post_migrate_signal(created_models, self.verbosity, self.interactive, connection.alias)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/sql.py", line 280, in emit_post_migrate_signal
using=db)
File "/usr/local/lib/python2.7/dist-packages/django/dispatch/dispatcher.py", line 189, in send
response = receiver(signal=self, sender=sender, **named)
File "/usr/local/lib/python2.7/dist-packages/guardian/management/__init__.py", line 39, in create_anonymous_user
user.save()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 734, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 771, in save_base
update_fields=update_fields, raw=raw, using=using)
File "/usr/local/lib/python2.7/dist-packages/django/dispatch/dispatcher.py", line 189, in send
response = receiver(signal=self, sender=sender, **named)
File "/usr/local/lib/python2.7/dist-packages/account/models.py", line 106, in user_post_save
Account.create(user=user)
File "/usr/local/lib/python2.7/dist-packages/account/models.py", line 63, in create
account.save()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 734, in save
force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 762, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 846, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 885, in _do_insert
using=using, raw=raw)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line 920, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 974, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "account_account" does not exist
LINE 1: INSERT INTO "account_account" ("user_id", "timezone", "langu...
then manage.py migrate:
System check identified some issues:
WARNINGS:
account.EmailConfirmation.created: (fields.W161) Fixed default value provided.
HINT: It seems you set a fixed date / time / datetime value as default for this field. This may not be what you want. If you want to have the current date as default, use `django.utils.timezone.now`
dialogos.Comment.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Operations to perform:
Synchronize unmigrated apps: tasks, dialogos, modeltranslation, django_extensions, djcelery, polymorphic, agon_ratings, gis, pinax_theme_bootstrap_account, django_forms_bootstrap, catalogue, humanize, geoserver, announcements, storages, user_messages, mptt, friendlytagloader, staticfiles, geoexplorer, sitemaps, proxy, account, pinax_theme_bootstrap, pagination, autocomplete_light, messages, leaflet, api, avatar, social, security
Apply all migrations: layers, documents, actstream, people, admin, guardian, sessions, sites, auth, tastypie, maps, contenttypes, base, upload, groups, services, taggit
Synchronizing apps without migrations:
Creating tables...
Creating table celery_taskmeta
Creating table celery_tasksetmeta
Creating table djcelery_intervalschedule
Creating table djcelery_crontabschedule
Creating table djcelery_periodictasks
Creating table djcelery_periodictask
Creating table djcelery_workerstate
Creating table djcelery_taskstate
Creating table account_account
Creating table account_signupcode
Creating table account_signupcodeextended
Creating table account_signupcoderesult
Creating table account_emailaddress
Creating table account_emailconfirmation
Creating table account_accountdeletion
Creating table avatar_avatar
Creating table dialogos_comment
Creating table agon_ratings_overallrating
Creating table agon_ratings_rating
Creating table announcements_announcement
Creating table announcements_dismissal
Creating table user_messages_thread
Creating table user_messages_userthread
Creating table user_messages_message
Running deferred SQL...
Installing custom SQL...
Running migrations:
Rendering model states... DONE
Applying actstream.0001_initial... OK
Applying admin.0001_initial... OK
Applying base.0001_initial... OK
Applying base.0002_topiccategory_fa_class... OK
Applying base.0003_auto_20160623_0404... OK
Applying documents.0001_initial... OK
Applying groups.0001_initial... OK
Applying guardian.0001_initial... OK
Applying layers.0001_initial... OK
Applying services.0001_initial... OK
Applying layers.0002_initial_step2... OK
Applying layers.0003_auto_20160623_0404... OK
Applying maps.0001_initial... OK
Applying services.0002_auto_20160623_0404... OK
Applying sessions.0001_initial... OK
Applying tastypie.0001_initial... OK
Applying upload.0001_initial... OK
Is that ok? How/can I restore the dump file of my previous DBs?
Thanks
Eugenio
________________________________
From: simone.dalmasso at gmail.com<mailto:simone.dalmasso at gmail.com>
Date: Thu, 23 Jun 2016 10:55:47 +0200
Subject: Re: [GeoNode-users] database update error
To: frippe12573 at hotmail.com<mailto:frippe12573 at hotmail.com>
CC: geonode-users at lists.osgeo.org<mailto:geonode-users at lists.osgeo.org>
Hi Eugenio,
beware that the data model and django version is changed in master. This issue happens when using postgres as db and not sqllite. At the moment the way to create the new db is by doing
manage.py migrate auth
manage.py migrate sites
manage.py migrate people
manage.py migrate
We will fix this in the future.
2016-06-23 10:27 GMT+02:00 Eugenio Trumpy <frippe12573 at hotmail.com<mailto:frippe12573 at hotmail.com>>:
Hi all,
today I was trying to update geonode from git (custom installation on ubuntu 14.04).
I made a backup of the data from geonode and geonode_data db, then I created new DBs,
and I run syncdb --noinput, but something seems not working:
System check identified some issues:
WARNINGS:
account.EmailConfirmation.created: (fields.W161) Fixed default value provided.
HINT: It seems you set a fixed date / time / datetime value as default for this field. This may not be what you want. If you want to have the current date as default, use `django.utils.timezone.now`
dialogos.Comment.ip_address: (fields.W900) IPAddressField has been deprecated. Support for it (except in historical migrations) will be removed in Django 1.9.
HINT: Use GenericIPAddressField instead.
Operations to perform:
Synchronize unmigrated apps: tasks, dialogos, modeltranslation, django_extensions, polymorphic, agon_ratings, gis, pinax_theme_bootstrap_account, django_forms_bootstrap, catalogue, humanize, geoserver, announcements, storages, user_messages, mptt, friendlytagloader, staticfiles, geoexplorer, sitemaps, proxy, account, pinax_theme_bootstrap, pagination, autocomplete_light, messages, leaflet, api, avatar, social, security
Apply all migrations: layers, documents, actstream, people, admin, guardian, sessions, djcelery, sites, auth, tastypie, maps, contenttypes, base, upload, groups, services, taggit
Synchronizing apps without migrations:
Creating tables...
Creating table account_account
Creating table account_signupcode
Creating table account_signupcodeextended
Creating table account_signupcoderesult
Creating table account_emailaddress
Creating table account_emailconfirmation
Creating table account_accountdeletion
Creating table avatar_avatar
Creating table dialogos_comment
Creating table agon_ratings_overallrating
Creating table agon_ratings_rating
Creating table announcements_announcement
Creating table announcements_dismissal
Creating table user_messages_thread
Creating table user_messages_userthread
Creating table user_messages_message
Running deferred SQL...
Traceback (most recent call last):
File "manage.py", line 29, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/syncdb.py", line 25, in handle
call_command("migrate", **options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 120, in call_command
return command.execute(*args, **defaults)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 179, in handle
created_models = self.sync_apps(connection, executor.loader.unmigrated_apps)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 318, in sync_apps
cursor.execute(statement)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 98, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/utils.py", line 62, in execute
return self.cursor.execute(sql)
django.db.utils.ProgrammingError: relation "people_profile" does not exist
Of course I performed the update of the dbs after run git pull on geonode dir.
Can you help me?
Eugenio
_______________________________________________
geonode-users mailing list
geonode-users at lists.osgeo.org<mailto:geonode-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/geonode-users
--
Simone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20160627/958b9ae5/attachment-0001.html>
More information about the geonode-users
mailing list