[postgresql] PostgreSQL Error in SMW_SQLStore2.php at 1106
Closed, InvalidPublic
Actions

Assigned To

Authored By

	• bzimport
	Feb 13 2011, 6:12 PM

Description

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

Details

Reference: bz27380

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:15 PM

• bzimport added a project: MediaWiki-extensions-Semantic-MediaWiki.

• bzimport set Reference to bz27380.

• bzimport created this task.Feb 13 2011, 6:12 PM

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

[postgresql] PostgreSQL Error in SMW_SQLStore2.php at 1106Closed, InvalidPublicActions

Description

#9 {main}

Details

Event Timeline

[postgresql] PostgreSQL Error in SMW_SQLStore2.php at 1106
Closed, InvalidPublic
Actions