Page MenuHomePhabricator

1064 You have an error in your SQL syntax
Open, Needs TriagePublic

Description

Setup

  • MediaWiki 1.27.3 (feedefb) 03:12, 7 September 2017
  • PHP 7.0.22-0ubuntu0.16.04.1 (apache2handler)
  • MySQL 5.7.19-0ubuntu0.16.04.1
  • Semantic MediaWiki 2.5.4 (9d8fac2) 14:13, 7 August 2017
  • Semantic Drilldown 2.0.2 (99736da) 20:03, 9 June 2016

Issue

Database error

A database query error has occurred. This may indicate a bug in the software.

Query:
	CREATE TEMPORARY TABLE semantic_drilldown_filter_values
	AS SELECT s_id AS id,  AS value
	FROM 
	JOIN `smw_object_ids` p_ids ON .p_id = p_ids.smw_id
	WHERE p_ids.smw_title = ''
Function: DatabaseBase::query
Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS value\x0A\x09FROM \x0A\x09JOIN `smw_object_ids` p_ids ON .p_id = p_ids.smw_id' at line 2 (localhost)

Backtrace:

#0 /../w/includes/db/Database.php(901): DatabaseBase->reportQueryError('You have an err...', 1064, '\tCREATE TEMPORA...', 'DatabaseBase::q...', false)
#1 /../w/extensions/SemanticDrilldown/includes/SD_Filter.php(426): DatabaseBase->query('\tCREATE TEMPORA...')
#2 /../w/extensions/SemanticDrilldown/specials/SD_BrowseData.php(970): SDFilter->createTempTable()
#3 /../w/extensions/SemanticDrilldown/specials/SD_BrowseData.php(1187): SDBrowseDataPage->printUnappliedFilterLine(Object(SDFilter), '/wiki/Special:B...')
#4 /../w/includes/specialpage/QueryPage.php(619): SDBrowseDataPage->getPageHeader()
#5 /../w/extensions/SemanticDrilldown/specials/SD_BrowseData.php(127): QueryPage->execute('Extensions')
#6 /../w/includes/specialpage/SpecialPage.php(479): SDBrowseData->execute('Extensions')
#7 /../w/includes/specialpage/SpecialPageFactory.php(577): SpecialPage->run('Extensions')
#8 /../w/includes/MediaWiki.php(282): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#9 /../w/includes/MediaWiki.php(735): MediaWiki->performRequest()
#10 /../w/includes/MediaWiki.php(509): MediaWiki->main()
#11 /../w/index.php(43): MediaWiki->run()
#12 {main}