[GeoNode-users] database update error
Simone Dalmasso
simone.dalmasso at gmail.com
Mon Jun 27 05:39:38 PDT 2016
you can use the git branch 2.4.x. git checkout is the command.
2016-06-27 14:25 GMT+02:00 Eugenio Trumpy <frippe12573 at hotmail.com>:
> 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>:
>
>> 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
>> Date: Thu, 23 Jun 2016 10:55:47 +0200
>> Subject: Re: [GeoNode-users] database update error
>> To: frippe12573 at hotmail.com
>> CC: 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>:
>>
>> 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
>> http://lists.osgeo.org/mailman/listinfo/geonode-users
>>
>>
>>
>>
>
>
> --
> Simone
>
--
Simone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20160627/71d17019/attachment-0001.html>
More information about the geonode-users
mailing list