https://bugzilla.wikimedia.org/show_bug.cgi?id=43260
--- Comment #8 from Andreas Plank <andreas.pl...@web.de> --- Dear Yaron it is not fixed yet :-( http://terms.gbif.org/wiki/Special:BrowseData/Concept?_single&Modified=April_2009 … returns the debug messages below I used your latest fix in HEAD with your git comment Fix - replaced "SELECT ... LIMIT 1" with "SELECT MAX" for subqueries Change-Id: If6810a391641d2fb7cbb0feeba13bde80f039542 We still run that HEAD version but debug is switched of. Is it the following subquery that causes trouble? SELECT smw_id FROM `smw_object_ids` WHERE smw_title = 'terms-internal:dcterms-modified' AND smw_namespace = 102 …it returns 9 results maybe this "AND a0.p_id = (SELECT smw_id …)" should be altered to "AND a0.p_id IN(SELECT smw_id …)". At least it returns a result set an no error but I don't have such a deep code understanding Andreas 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_time` 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 = 'terms-internal:dcterms-modified' AND smw_namespace = 102) AND (YEAR(SUBSTR(o_serialized, 3, 100)) = 2009 AND MONTH(SUBSTR(o_serialized, 3, 100)) = 4 ) 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(124): 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
