Author: peter
Description:
MediaWiki 1.16.2
SemanticMediaWiki 1.5.5
PHP 5.2.15 (apache2handler)
PostgreSQL 9.0.1
On selecting the semantic search in page Special:Ask following error is reported:
A database error has occurred
Query: DELETE FROM smw_tmp_unusedprops USING smw_tmp_unusedprops INNER JOIN smw_rels2 INNER JOIN smw_ids ON p_id=smw_id AND title=smw_title AND smw_iw=''
Function: SMW::getUnusedPropertySubjects
Error: 1 ERROR: syntax error at end of input
LINE 1: ...OIN smw_ids ON p_id=smw_id AND title=smw_title AND smw_iw=''
^
Backtrace:
#0 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/includes/db/Database.php(538): DatabasePostgres->reportQueryError('ERROR: syntax ...', 1, 'DELETE FROM smw...', 'SMW::getUnusedP...', false)
#1 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(1106): DatabaseBase->query('DELETE FROM smw...', 'SMW::getUnusedP...')
#2 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/extensions/SemanticMediaWiki/specials/AskSpecial/SMW_SpecialAsk.php(222): SMWSQLStore2->getUnusedPropertiesSpecial()
#3 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/extensions/SemanticMediaWiki/specials/AskSpecial/SMW_SpecialAsk.php(378): SMWAskPage::addAutocompletionJavascriptAndCSS()
#4 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/extensions/SemanticMediaWiki/specials/AskSpecial/SMW_SpecialAsk.php(55): SMWAskPage->makeHTMLResult()
#5 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/includes/SpecialPage.php(559): SMWAskPage->execute(NULL)
#6 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/includes/Wiki.php(254): SpecialPage::executePath(Object(Title))
#7 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/includes/Wiki.php(64): MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#8 /opt/lappstack-1.2-4/apache2/htdocs/peterswiki/index.php(117): MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#9 {main}
Version: unspecified
Severity: normal
OS: Linux
Platform: PC