[GeoNode-users] database update error
Farhan
farhanmoazzam at gmail.com
Tue Jun 28 01:15:24 PDT 2016
Anyone tell me that how to unsubscribe this email from geonode. As it's now
irritating me.
On Tue, Jun 28, 2016 at 12:52 PM, Simone Dalmasso <simone.dalmasso at gmail.com
> wrote:
> hm, nope.
>
> try a pip install -e geonode maybe you miss something
>
> 2016-06-28 9:42 GMT+02:00 Eugenio Trumpy <frippe12573 at hotmail.com>:
>
>> Hi Simone,
>>
>>
>> Django seems to be already at 1.6.11 version
>>
>>
>> Any other hints?
>>
>>
>> E.
>>
>>
>> ------------------------------
>> *Da:* Simone Dalmasso <simone.dalmasso at gmail.com>
>> *Inviato:* lunedì 27 giugno 2016 17.56
>> *A:* Eugenio Trumpy
>> *Cc:* geonode-users at lists.osgeo.org
>> *Oggetto:* Re: [GeoNode-users] database update error
>>
>> It's likely to be the django version. Django on 2.4 has to be 1.6.11
>>
>> 2016-06-27 16:40 GMT+02:00 Eugenio Trumpy <frippe12573 at hotmail.com>:
>>
>>> Hi Simone,
>>>
>>>
>>> I forgot I had both the dbs backups and /geonode (the once I had before
>>> the git pull) saved.
>>>
>>> So I restore the old /geonode (I removed all the new geonode dir
>>> obtained with the git pull) and restored the DBs dumps.
>>>
>>>
>>> Everything seems to be working, I see the right number of the layers and
>>> maps, groups, people...
>>>
>>> However, clicking on layer I have an empty page (no layers available).
>>>
>>> So I run python manage.py updatelayers, but I get:
>>>
>>>
>>> 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 399, in execute_from_command_line
>>> utility.execute()
>>> File
>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
>>> line 392, in execute
>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>> File
>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
>>> line 272, in fetch_command
>>> klass = load_command_class(app_name, subcommand)
>>> File
>>> "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py",
>>> line 75, in load_command_class
>>> module = import_module('%s.management.commands.%s' % (app_name,
>>> name))
>>> File
>>> "/usr/local/lib/python2.7/dist-packages/django/utils/importlib.py", line
>>> 40, in import_module
>>> __import__(name)
>>> File
>>> "/dati/geonode/geonode/geoserver/management/commands/updatelayers.py", line
>>> 24, in <module>
>>> from geonode.geoserver.helpers import gs_slurp
>>> File "/dati/geonode/geonode/geoserver/helpers.py", line 70, in <module>
>>> from geonode.layers.utils import layer_type, get_files
>>> File "/dati/geonode/geonode/layers/utils.py", line 46, in <module>
>>> from geonode.layers.models import Layer, UploadSession
>>> File "/dati/geonode/geonode/layers/models.py", line 35, in <module>
>>> from geonode.base.models import ResourceBase, ResourceBaseManager,
>>> resourcebase_post_save
>>> File "/dati/geonode/geonode/base/models.py", line 41, in <module>
>>> from mptt.models import MPTTModel, TreeForeignKey
>>> File "/usr/local/lib/python2.7/dist-packages/mptt/models.py", line 15,
>>> in <module>
>>> from mptt.managers import TreeManager
>>> File "/usr/local/lib/python2.7/dist-packages/mptt/managers.py", line
>>> 63, in <module>
>>> class TreeManager(models.Manager.from_queryset(TreeQuerySet)):
>>> AttributeError: type object 'Manager' has no attribute 'from_queryset'
>>>
>>> Any ideas?
>>>
>>> E.
>>>
>>>
>>>
>>>
>>> ------------------------------
>>> *Da:* Simone Dalmasso <simone.dalmasso at gmail.com>
>>> *Inviato:* lunedì 27 giugno 2016 14.39
>>> *A:* Eugenio Trumpy
>>> *Cc:* geonode-users at lists.osgeo.org
>>> *Oggetto:* Re: [GeoNode-users] database update error
>>>
>>> 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
>>>
>>
>>
>>
>> --
>> Simone
>>
>
>
>
> --
> Simone
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geonode-users
>
>
--
*Best Regards *
*M. Farhan-Ul-Moazzam*
*BS(Hons) Geomatics (GIS/RS)*
*Research Associate *
*Alkhidmat Disaster Management Center*
*Cell# : +923139779248*
*E-mail: farhan.moazzam at gmail.com <farhan.moazzam at gmail.com> *
* farhanpf1525 at hotmail.com <farhanpf1525 at hotmail.com>*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20160628/d0d95f84/attachment-0001.html>
More information about the geonode-users
mailing list