[GeoNode-users] Missing columns after migrating data from Geonode 2.4 to 2.6

[Annalisa Schiavon]

Dear Eric,
on 3 July I found a similar issue: upload_upload table hasn't 4 attribute:
mosaic_time_regex,
mosaic_time_value, mosaic_elev_regex and mosaic_elev_value.
I added those columns and solved my problem.

Regards,
Annalisa

2017-10-16 16:24 GMT+02:00 Eric Goddard <egoddard1010 at gmail.com>:

> Hi all,
>
> We're trying to upgrade from GeoNode 2.4 to 2.6. I have a new VM with
> Geonode 2.6 installed on Ubuntu 16.04 from the PPA. I dumped the
> postgres data from our 2.4 server and created new DBs on the Geonode
> 2.6 instance and updated settings.py to point to the geonode 2.4
> geonode and geonode_data DBs.
>
> Following the suggestion in this thread
> (http://osgeo-org.1560.x6.nabble.com/Help-for-migrate-
> data-from-2-4-to-2-6-td5323208.html),
> I ran geonode migrate --fake-initial and everything appears to have
> worked, however if I try to create a new account from the geonode
> registration page, or delete an existing account from the admin panel
> I get some errors.
>
> Trying to create a new account results in the following error:
> IntegrityError: null value in column "last_login" violates not-null
> constraint
>
>  Trying to delete an account results in the following error:
> ProgrammingError: column upload_upload.mosaic_time_regex does not exist
>
> It looks like the migration didn't run correctly. If anyone has advice
> on how fix/work a round this issue it would be greatly appreciated!
> We'll be reloading the data anyway so our main concern is just
> migrating the accounts and groups.
>
> If it helps, here is the comparison of the geonode 2.4 and 2.6 schemas
> for the upload_upload table. The mosaic* columns are missing from the
> 2.4 database that was migrated:
>
> geonode 2.4 database (after running migrate):
> geonode24=# \d upload_upload
>                                     Table "public.upload_upload"
>    Column   |           Type           |                         Modifiers
> ------------+--------------------------+--------------------
> ----------------------------------------
>  id         | integer                  | not null default
> nextval('upload_upload_id_seq'::regclass)
>  import_id  | bigint                   |
>  user_id    | integer                  |
>  state      | character varying(16)    | not null
>  date       | timestamp with time zone | not null
>  layer_id   | integer                  |
>  upload_dir | character varying(100)   |
>  name       | character varying(64)    |
>  complete   | boolean                  | not null
>  session    | text                     |
>  metadata   | text                     |
> Indexes:
>     "upload_upload_pkey" PRIMARY KEY, btree (id)
>     "upload_upload_layer_id" btree (layer_id)
>     "upload_upload_user_id" btree (user_id)
> Foreign-key constraints:
>     "upload_upload_layer_id_fkey" FOREIGN KEY (layer_id) REFERENCES
> layers_layer(resourcebase_ptr_id) DEFERRABLE INITIALLY DEFERRED
>     "upload_upload_user_id_fkey" FOREIGN KEY (user_id) REFERENCES
> people_profile(id) DEFERRABLE INITIALLY DEFERRED
> Referenced by:
>     TABLE "upload_uploadfile" CONSTRAINT
> "upload_uploadfile_upload_id_fkey" FOREIGN KEY (upload_id) REFERENCES
> upload_upload(id) DEFERRABLE INITIALLY DEFERRED
>
> Geonode 2.6 database (from initial install):
> geonode=# \d upload_upload
>                                        Table "public.upload_upload"
>       Column       |           Type           |
>  Modifiers
> -------------------+--------------------------+-------------
> -----------------------------------------------
>  id                | integer                  | not null default
> nextval('upload_upload_id_seq'::regclass)
>  import_id         | bigint                   |
>  state             | character varying(16)    | not null
>  date              | timestamp with time zone | not null
>  upload_dir        | character varying(100)   |
>  name              | character varying(64)    |
>  complete          | boolean                  | not null
>  session           | text                     |
>  metadata          | text                     |
>  mosaic_time_regex | character varying(128)   |
>  mosaic_time_value | character varying(128)   |
>  mosaic_elev_regex | character varying(128)   |
>  mosaic_elev_value | character varying(128)   |
>  layer_id          | integer                  |
>  user_id           | integer                  |
> Indexes:
>     "upload_upload_pkey" PRIMARY KEY, btree (id)
>     "upload_upload_7a39a38c" btree (layer_id)
>     "upload_upload_e8701ad4" btree (user_id)
> Foreign-key constraints:
>     "u_layer_id_6346de911330a880_fk_layers_layer_resourcebase_ptr_id"
> FOREIGN KEY (layer_id) REFERENCES layers_layer(resourcebase_ptr_id)
> DEFERRABLE INITIALLY DEFERRED
>     "upload_upload_user_id_7fad116c8478bf31_fk_people_profile_id"
> FOREIGN KEY (user_id) REFERENCES people_profile(id) DEFERRABLE
> INITIALLY DEFERRED
> Referenced by:
>     TABLE "upload_uploadfile" CONSTRAINT
> "upload_uploadfil_upload_id_21ef448d17dd4b6b_fk_upload_upload_id"
> FOREIGN KEY (upload_id) REFERENCES upload_upload(id) DEFERRABLE
> INITIALLY DEFERRED
>
>
> Thanks!
>
> Eric
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20171018/d0b6276a/attachment.html>