Last modified: 2012-02-11 18:23:19 UTC
My wiki has a namespace called "Namespace". When I execute {{#ask:[[Namespace:+]]}} I receive duplicated results (4x): [[:Namespace:Account|Account]], [[:Namespace:Account|Account]], [[:Namespace:Account|Account]], [[:Namespace:Account|Account]], [[:Namespace:Address|Address]], [[:Namespace:Address|Address]], [[:Namespace:Address|Address]], [[:Namespace:Address|Address]], [[:Namespace:Administrative District|Administrative District]], [[:Namespace:Administrative District|Administrative District]], [[:Namespace:Administrative District|Administrative District]], [[:Namespace:Administrative District|Administrative District]], [[:Namespace:Age|Age]], [[:Namespace:Age|Age]], [[:Namespace:Age|Age]], [[:Namespace:Age|Age]], [[:Namespace:Agency|Agency]], [[:Namespace:Agency|Agency]], [[:Namespace:Agency|Agency]], [[:Namespace:Agency|Agency]], ... Looking at another bug, it occurs to me that there's possibly duplicate ids on the smwid table. All these pages were inserted via import, maybe that is at the root of a problem. I can't say for certain but i don't think I imported these pages more than once. I am using mw 17 & smw 1.6.1 on this laptop. thanks - john
I can do NS queries with trunk and am not getting duplicates. Can you try running maintenance/SMW_refreshData.php and see if that fixes it? And if it does not, see if it happens with the SMW 1.7 beta 1 rel?
when i run refreshdata, I get the same exact error i've reported for runjobs (https://bugzilla.wikimedia.org/show_bug.cgi?id=33182) that you've marked as a duplicate. Until I get refreshdata to work, i don't see the point of trying 1.7beta1 unless you advise otherwise. thanks - john
The bug that kept you from using refreshdata has now been closed, so you could give it another try. However, refreshdata does not clean up duplicate entries in the ID table, if such entries should exists in your case. One radical way to fix the database is to delete and recreate the SMW tables before re-running a refresh. This is also explained in the documentation: http://semantic-mediawiki.org/wiki/Help:Repairing_SMW%27s_data#Rebuilding_everything Doing this should always reset your wiki to a clean default state. Please let us know if the problem persists or if there is any way of reproducing the error (i.e., of creating new duplicates).
