https://bugzilla.wikimedia.org/show_bug.cgi?id=43260
--- Comment #5 from Andreas Plank <[email protected]> --- Hi Yaron, (1) I did use git HEAD of SemanticDrilldown but it did not help in the end. You mentioned the problem lies in the update procedure somehow, so (2) I did first on Special:SMWAdmin clicked on, started [Initialise or upgrade tables] and (3) clicked on/started [Start updating data]. After that (4) the error occurred: MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' (maybe a JOIN can do it? See similar problem http://stackoverflow.com/questions/12434525/this-version-of-mysql-doesnt-yet-support-limit-in-all-any-some-subquery) (5) I switched back to SemanticDrilldown 1.2.4. Below is the debug output of HEAD of SemanticDrilldown and http://terms.gbif.org/w/index.php?title=Special:BrowseData/Concept was: 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 WHERE insts.o_id IN (SELECT smw_id FROM `smw_object_ids` cat_ids WHERE smw_namespace = 14 AND (smw_title = 'Concept') LIMIT 1) ORDER BY sortkey LIMIT 501 from within function "SDBrowseDataPage::reallyDoQuery". Database returned error "1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' (localhost)". Backtrace: #0 /usr/share/mediawiki20/includes/db/Database.php(916): DatabaseBase->reportQueryError('This version of...', 1235, '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(501, 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
