Last modified: 2010-03-02 14:02:31 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T24547, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 22547 - Filter for ask output
Filter for ask output
Status: RESOLVED WORKSFORME
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
All All
: Normal enhancement with 1 vote (vote)
: ---
Assigned To: Markus Krötzsch
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-02-16 12:03 UTC by DaSch
Modified: 2010-03-02 14:02 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description DaSch 2010-02-16 12:03:29 UTC
Well like you can see on this page
http://www.wecowi.de/wiki/1941
there are some double entries and this look very uggly. Maybe there could be something like a filter-option to change the behaviour how to handle doublets and other things
Comment 1 DaSch 2010-02-16 12:04:07 UTC
see also https://bugzilla.wikimedia.org/show_bug.cgi?id=22546
Comment 2 Markus Krötzsch 2010-03-02 14:02:31 UTC
Normally, SMW does never display duplicate values. If you look at the generated database query (format=debug) you can see that it uses "SELECT DISTINCT" and that the fields that it selects are only those that determine the result page. So no page should occur twice unless (1) MySQL returns the same results twice in spite of "DISTINCT," or (2) the database contains multiple instances of that page with different values (as MySQL sees them) but these values still are translated into the same page link when displayed.

I did some tests on your site and I think I can exclude (2) since it would also show on other queries. In particular, the problem on your site only occurs when sorting is used. Yet, (1) is also fairly improbable, since this would be a major MySQL bug. So we do not have any likely explanation.

I have been trying to reproduce the problem on other wikis but without success. On your site, the problem only occurs when sorting by the property "Datum (Geschichte)." The duplicated page has two values for this property, where one is inherited by a subproperty "Ende (Geschichte)." This modelling seems to be the main problem, yet I cannot reproduce the problem when reproducing such a situation elsewhere. I am not sure if you are aware of the ramifications of your the way that dates are modelled in your wiki -- in general, I would not consider it very good practice to order query results by a property that is likely to have more than one value for a page, so maybe you want to change this anyway.

There are two possible ways forward: (a) you change the way that super properties are used for sorting in your wiki, maybe by using some other property for sorting, or (b) you manage to reproduce the problem on sandbox.sematnic-mediawiki.org where I have a chance to inspect it more closely for finding a fix. For now, I have to close this as worksforme.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links