Hi Valerio,
It's great that you looked into it further - I hadn't had time to look at
the issue yet. Semantic Drilldown definitely sometimes exposes weird values
in the SMW tables that otherwise wouldn't be visible. I think you did the
right thing by just deleting the bad entries in the smw_ids table - I don't
believe there's any downside to doing that.
As to what caused it originally - I don't know. It could be that the site
had an older version of SMW and SF, that didn't handle those characters
correctly, when the values were first stored - or maybe you were using a
different DB encoding then.
-Yaron
On Fri, Feb 4, 2011 at 1:56 PM, Valerio Pelliccioni <v...@silkwood.it> wrote:
> Hi all,
> the MW site I'm running is a traditional tunes archive with a lot of tunes
> belonging to british isles and most of them have unusual characters in the
> titles.
> After a recent upgrade from 1.15.x to 1.16.0 I warned the community that
> suddenly the drilldown is no longer functioning, i.e. the Special:BrowseData
> page just shows the values of the filtered property but not the list of
> articles (the traditional tunes) in the category.
>
> I made some research and found that:
>
> - this is not a SemanticDrilldown issue;
> - listing by category (i.e. Category:Tune) works fine;
> - listing by properties
> (e.g. Special:SearchByProperty/It-20comes-20from/Scotland) shows duplicated
> titles like:
> - 'A Bhean a Bh'aig an Tàillear
> Chaol<http://vclvm54.isis.unc.edu/mediawiki/index.php/%27A_Bhean_a_Bh%27aig_an_T%C3%A0illear_Chaol>
> *(a normal link)*
> - 'A Bhean a Bh'aig an T�illear
> Chaol<http://vclvm54.isis.unc.edu/mediawiki/index.php?title=%27A_Bhean_a_Bh%27aig_an_T%E0illear_Chaol&action=edit&redlink=1>
> *(a red link...)*
>
> Searching in wikidb.*page* table I have found two records as expected: the
> page itself (namespace 0) and the talk:page (namespace 1)
> Searching in wikidb.*smw_ids *table I've found four records
>
> 'A Bhean a Bh'aig an Tàillear
> Chaol<http://vclvm54.isis.unc.edu/mediawiki/index.php/%27A_Bhean_a_Bh%27aig_an_T%C3%A0illear_Chaol>
> 'A Bhean a Bh'aig an Tàillear
> Chaol<http://vclvm54.isis.unc.edu/mediawiki/index.php/%27A_Bhean_a_Bh%27aig_an_T%C3%A0illear_Chaol>
>
> 'A Bhean a Bh'aig an
> T<http://vclvm54.isis.unc.edu/mediawiki/index.php/%27A_Bhean_a_Bh%27aig_an_T%C3%A0illear_Chaol>
> �<http://vclvm54.isis.unc.edu/mediawiki/index.php?title=%27A_Bhean_a_Bh%27aig_an_T%E0illear_Chaol&action=edit&redlink=1>illear
> Chaol
> 'A Bhean a Bh'aig an
> T<http://vclvm54.isis.unc.edu/mediawiki/index.php/%27A_Bhean_a_Bh%27aig_an_T%C3%A0illear_Chaol>
> �<http://vclvm54.isis.unc.edu/mediawiki/index.php?title=%27A_Bhean_a_Bh%27aig_an_T%E0illear_Chaol&action=edit&redlink=1>illear
> Chaol
>
> a couple of main and talk namespaces respectively.
>
> So what to do now?
> May I DELETE from wikidb.smw_ids where smw_id = *<the corresponding
> smw_id>* of the incorrect tune titles without damage the db???
> Dunno! But I did it!
> The SemanticDrillDown now does what is expected to do.
> Did I made a mistake? But above all, what happened to my wiki?
> Any clue/help appreciated.
> Regards,
>
> Valerio
>
>
>
>
>
> ------------------------------------------------------------------------------
> The modern datacenter depends on network connectivity to access resources
> and provide services. The best practices for maximizing a physical server's
> connectivity to a physical network are well understood - see how these
> rules translate into the virtual world?
> http://p.sf.net/sfu/oracle-sfdevnlfb
> _______________________________________________
> Semediawiki-devel mailing list
> Semediawiki-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
>
>
--
WikiWorks · MediaWiki Consulting · http://wikiworks.com
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
