https://bugzilla.wikimedia.org/show_bug.cgi?id=43260
--- Comment #3 from Andreas Plank <[email protected]> --- Hi Yaron, (1) you are rigth the first one can be resolved by setting the filters property to date (not string as I did) and you are rigth too that SD should display an error message or would be a nice feature to have. (2) filtering by a string shows the debug message below (filter Label in our case, I switched $wgShowSQLErrors = true; just temporarily on): http://terms.gbif.org/w/index.php?_search_Label=de%3ADatengrundlage&title=Special%3ABrowseData%2FConcept&_single=&limit=500 A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT DISTINCT ids.smw_title AS title, ids.smw_title AS value, ids.smw_title AS t, ids.smw_namespace AS namespace, ids.smw_namespace AS ns, ids.smw_id AS id, ids.smw_iw AS iw, ids.smw_sortkey AS sortkey FROM `smw_object_ids` ids JOIN `smw_fpt_inst` insts ON ids.smw_id = insts.s_id AND ids.smw_namespace != 14 JOIN `smw_di_blob` a0 ON ids.smw_id = a0.s_id WHERE insts.o_id IN (SELECT smw_id FROM `smw_object_ids` cat_ids WHERE smw_namespace = 14 AND (smw_title = 'Concept')) AND a0.p_id = (SELECT smw_id FROM `smw_object_ids` WHERE smw_title = 'skos:prefLabel' AND smw_namespace = 102) AND (a0.o_hash LIKE '%de:Datengrundlage%') ORDER BY sortkey LIMIT 251 from within function "SDBrowseDataPage::reallyDoQuery". Database returned error "1242: Subquery returns more than 1 row (localhost)". Backtrace: #0 /usr/share/mediawiki20/includes/db/Database.php(916): DatabaseBase->reportQueryError('Subquery return...', 1242, 'SELECT DISTINCT...', 'SDBrowseDataPag...', false) #1 /usr/share/mediawiki20/includes/QueryPage.php(397): DatabaseBase->query('SELECT DISTINCT...', 'SDBrowseDataPag...') #2 /usr/share/mediawiki20/includes/QueryPage.php(488): QueryPage->reallyDoQuery(251, 0) #3 /usr/share/mediawiki20/extensions/SemanticDrilldown/specials/SD_BrowseData.php(121): QueryPage->execute('Concept') #4 /usr/share/mediawiki20/includes/SpecialPage.php(611): SDBrowseData->execute('Concept') #5 /usr/share/mediawiki20/includes/SpecialPageFactory.php(494): SpecialPage->run('Concept') #6 /usr/share/mediawiki20/includes/Wiki.php(290): SpecialPageFactory::executePath(Object(Title), Object(RequestContext)) #7 /usr/share/mediawiki20/includes/Wiki.php(536): MediaWiki->performRequest() #8 /usr/share/mediawiki20/includes/Wiki.php(446): MediaWiki->main() #9 /usr/share/mediawiki20/index.php(59): MediaWiki->run() #10 {main} -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
