https://bugzilla.wikimedia.org/show_bug.cgi?id=27380

           Summary: SQL Error in SMW_SQLStore2.php at 1106
           Product: MediaWiki extensions
           Version: any
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: Normal
         Component: Semantic MediaWiki
        AssignedTo: mar...@semantic-mediawiki.org
        ReportedBy: pe...@peter-siegel.de
                CC: jeroen_ded...@yahoo.com, pe...@peter-siegel.de


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}
---------

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to