[ECODP-dev] Reseting new database error with vocabularies

Dimitrios Mexis dimitrios.mexis at tenforce.com
Tue Sep 10 09:51:37 UTC 2013


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 
> <mailto: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
>     <mailto: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
>         <mailto: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 <http://www.tenforce.be>
>
>     Bert.Van.Nuffelen at tenforce.com <mailto:Bert.Van.Nuffelen at tenforce.com>
>     Office: +32 (0)16 31 48 60 <tel:%2B32%20%280%2916%2031%2048%2060>
>     Mobile:+32 479 06 24 26 <tel:%2B32%20479%2006%2024%2026>
>     skype: bert.van.nuffelen
>
>
>
>
> _______________________________________________
> 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/5b672d6a/attachment.html>


More information about the ecodp-dev mailing list