Last modified: 2014-09-18 18:32:40 UTC
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} ---------
Thanks for reporting. I'm planning to have a look at SMWs PostGres support, but this is blocked by the current MediaWiki installer having broken PostGres support, preventing me from setting up a testing wiki.
(In reply to comment #1) > Thanks for reporting. I'm planning to have a look at SMWs PostGres support, but > this is blocked by the current MediaWiki installer having broken PostGres > support, preventing me from setting up a testing wiki. Have you tried the latest installer? I've done extensive testing and verified that Pg works.
I tried 4 days or so ago, and it was broken then. ^demon told me it would probably remain broken for a while, as it's apparently not high priority. Either way, I'll give it another go soonish and see if it works then.
If you run into problems, please report them. I did more than testing -- I actually fixed problems (one that I created, natch).
I just tried again and the installer failed on me during the last step: http://dpaste.org/QsfE/
*** Bug 27731 has been marked as a duplicate of this bug. ***
`SMW_SQLStore2.php` is no longer in use therefore we suggest to update to an supported SMW version and re-open an issue at [0] if the problem still persists. [0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues