[GeoNode-users] database update error

[Simone Dalmasso]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20160623/dee0ea23/attachment.html>