[ckan-dev] problems upgrading to CKAN 2.2

Mon Feb 10 23:56:45 UTC 2014

Works!

Thanks a lot.

- Ivan

On Tue, Feb 11, 2014 at 1:52 AM, Hildegard Gerlach
<hildegard.gerlach at jrc.ec.europa.eu> wrote:
> Hi,
>
> see mail from Adrià here:
> https://lists.okfn.org/pipermail/ckan-dev/2014-January/006686.html
>
> you can run the SQL commands from line 22 to 55 of the migration file [1].
> That will fill the metadata_modified field.
>
> [1]
> https://github.com/ckan/ckan/blob/master/ckan/migration/versions/069_resource_url_and_metadata_modified.py#L22
>
> Afterwards the rebuild index should work.
>
> Hilde
>
>
> On 2/10/2014 1:59 PM, Ivan wrote:
>>
>> Hello,
>>
>> I'm having similar issues as Hildegard when trying to reload db dump
>> from 2.1.1 into 2.2a or 2.3a (current master tip).
>>
>>
>> $ paster db clean -c $inif
>> $ paster db load  /tmp/20140210_ckan-db-dump.sql -c $inif
>> ...
>> Loaded CKAN database: /tmp/20140210_ckan-db-dump.sql
>> Upgrading DB
>> 2014-02-10 06:56:20,731 INFO  [ckan.model] CKAN database version remains
>> as: 71
>> Rebuilding search index
>> 2014-02-10 06:56:20,784 INFO  [ckan.lib.search] Rebuilding search index...
>> 2014-02-10 06:56:20,788 INFO  [ckan.lib.search] Rebuilding the whole
>> index...
>> 2014-02-10 06:56:20,832 ERROR [ckan.lib.search] Error while indexing
>> dataset ce2ff6c7-d75d-428c-a765-e0f6c7925848: 'NoneType' object has no
>> attribute 'isoformat'
>>
>> <skip to last line>
>>
>>    File
>> "/srv/ckan-dex/testing/20140210_b377a50/ckan/lib/dictization/model_dictize.py",
>> line 329, in package_dictize
>>      result_dict['metadata_modified'] = pkg.metadata_modified.isoformat()
>> AttributeError: 'NoneType' object has no attribute 'isoformat'
>>
>>
>> I can do `db load-only` and `db update` and get users and
>> organizations in the new instance, but 0 datasets.  `search-index
>> rebuild` fails with the same error message as above.
>>
>> db version on "2.1.1 ckan instance" is 71.
>> ckan.plugins = stats text_preview recline_preview datastore (on both
>> 2.1.1 and 2.3a)
>>
>>
>> Thanks in advance for any help and suggestions.
>>
>> - Ivan