[ECODP-dev] Reseting new database error with vocabularies

[John Glover]

Hi Dimitrios,

Yes, that seems correct to me.

Regards,
John


On 10 September 2013 11:51, Dimitrios Mexis <dimitrios.mexis at tenforce.com>wrote:

>  Hello,
>
> FYI, these are the changes that I see between old and new schema.
>
> 385,386c385,386
> <     <field name="views_total" type="int" indexed="true" stored="false"/>
> <     <field name="views_recent" type="int" indexed="true" stored="false"/>
> ---
> >     <field name="views_total" type="int" indexed="true" stored="true"/>
> >     <field name="views_recent" type="int" indexed="true" stored="true"/>
> 391a392
> >     <field name="modified_date" type="date" indexed="true" stored="true"
> multiValued="false"/>
>
>
>
> On 10/09/2013 10:21, John Glover wrote:
>
> Hi Bert,
>
>  Sure: our Solr schema [1] is still in the same place:
> ckanext-ecportal/ckanext/ecportal/solr/schema.xml.
>
>  The version of Solr that you are using on the acceptance server (or your
> test server, not sure where you are doing this) will need to be updated to
> use this new schema, and then you must restart tomcat and rebuild the
> search index. The test server was using Solr from a different machine, so I
> copied this file to the Solr configuration directory there
> (/applications/ecodp/users/ecodp/ecodp-solr/conf).
>
>  [1]:
> https://github.com/okfn/ckanext-ecportal/blob/master/ckanext/ecportal/solr/schema.xml
>
>  Regards,
> John
>
>
> On 10 September 2013 10:13, Bert Van Nuffelen <
> bert.van.nuffelen at tenforce.com> wrote:
>
>>   Hi John,
>>
>>  can you provide us with the pointers to the updated files of solr
>> configuration for release 01.00.00
>>
>>  best,
>>
>>  Bert
>>
>>
>> 2013/9/9 John Glover <john.glover at okfn.org>
>>
>>> Hi Dimitrios,
>>>
>>>  Did you rebuild the search index after upgrading from the 09 database?
>>> Release 1 uses a slightly different Solr schema, so you would also have to
>>> copy over the new schema first from ckanext-ecportal/ckanext/ecportal/solr
>>> and restart tomcat before rebuilding the index.
>>>
>>>  By the way, if you have not also updated the Solr schema on your test
>>> server this might be why you are not seeing the most view datasets box, as
>>> we have changed how that information is stored (it is now in Solr). I will
>>> add a note about this to our operations manual changes document.
>>>
>>>  Regards,
>>> John
>>>
>>>
>>> On 9 September 2013 13:43, Dimitrios Mexis <dimitrios.mexis at tenforce.com
>>> > wrote:
>>>
>>>> Hi John,
>>>>
>>>> there is something "fishy". I can not understand and I can not explain
>>>> it.
>>>> The nginx could be a problem. I see the boxes including a dataset under
>>>> "Top publishers"
>>>> As I took a copy from ODP, it should be all of informations including
>>>> datasets. Right ?
>>>>
>>>> What turns out is that I do see there is Secretariat-General, and 1
>>>> dataset. But when I click it, I don't go to the dataset
>>>> the link en/data/dataset/Qj83cpCYT0MrAZIJILOQQ
>>>> which on ODP is the dataset, on the test returns 404.
>>>>
>>>> Recap:
>>>> After the restore of 09.x database I run the following one after the
>>>> other, one by one.
>>>>
>>>> paster --plugin=ckanext-ecportal ecportal migrate-odp-namespace -c
>>>> $CKAN_INI
>>>> paster --plugin=ckanext-ecportal ecportal update-all-vocabs -c $CKAN_INI
>>>> paster --plugin=ckanext-ecportal ecportal update-publishers -c $CKAN_INI
>>>>
>>>>
>>>> The backup is under folder /applications/ecodp/users/ecodp/BACKUP/
>>>> and there you can find your okf's backup as well as the rel09 as
>>>> backeup from odp.
>>>>
>>>> Regards
>>>> Dimitrios
>>>>
>>>>
>>>>
>>>> On 9/09/2013 13:20, John Glover wrote:
>>>>
>>>>>
>>>>> Ok thanks, so it is something else. If this continues to be a problem
>>>>> could you please transfer the release 09 database dump file to our test
>>>>> server (just put it in the home directory) so that I can load it and run
>>>>> through the upgrade
>>>>>
>>>>
>>>>
>>>
>>
>>
>>  --
>> Bert Van Nuffelen
>>
>> Semantic Technologies Software Architect at TenForce
>> www.tenforce.be
>>
>> Bert.Van.Nuffelen at tenforce.com
>> Office: +32 (0)16 31 48 60 <%2B32%20%280%2916%2031%2048%2060>
>> Mobile:+32 479 06 24 26 <%2B32%20479%2006%2024%2026>
>> skype: bert.van.nuffelen
>>
>
>
>
> _______________________________________________
> Ecodp-dev mailing listEcodp-dev at lists.okfn.orghttp://lists.okfn.org/mailman/listinfo/ecodp-dev
>
>
>
> _______________________________________________
> Ecodp-dev mailing list
> Ecodp-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ecodp-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130910/0c78f16b/attachment.html>