Page MenuHomePhabricator

Creating Template page show database error for PostgreSQL 9.0.1
Closed, ResolvedPublic

Description

Author: anton.kochkov

Description:
A database error has occurred
I'm have MediaWiki 1.16.0, PostgreSQL 9.0.1, latest (from svn SematicWiki/SemanticForms)

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 /usr/home/droid-dev/www/includes/db/Database.php(538): DatabasePostgres->reportQueryError('ERROR: syntax ...', 1, 'DELETE FROM smw...', 'SMW::getUnusedP...', false)
#1 /usr/home/droid-dev/www/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(1099): DatabaseBase->query('DELETE FROM smw...', 'SMW::getUnusedP...')
#2 /usr/home/droid-dev/www/extensions/SemanticForms/specials/SF_CreateTemplate.php(43): SMWSQLStore2->getUnusedPropertiesSpecial(Object(SMWRequestOptions))
#3 /usr/home/droid-dev/www/extensions/SemanticForms/specials/SF_CreateTemplate.php(99): SFCreateTemplate::getAllPropertyNames()
#4 /usr/home/droid-dev/www/extensions/SemanticForms/specials/SF_CreateTemplate.php(27): SFCreateTemplate::printCreateTemplateForm()
#5 /usr/home/droid-dev/www/includes/SpecialPage.php(559): SFCreateTemplate->execute(NULL)
#6 /usr/home/droid-dev/www/includes/Wiki.php(254): SpecialPage::executePath(Object(Title))
#7 /usr/home/droid-dev/www/includes/Wiki.php(64): MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#8 /usr/home/droid-dev/www/index.php(117): MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#9 {main}


Version: unspecified
Severity: critical

Details

Reference
bz27731
TitleReferenceAuthorSource BranchDest Branch
build: Add wmf-certificates package for production TLS certsrepos/abstract-wiki/wikifunctions/function-evaluator!30jforresterwmf-certificatesmain
Customize query in GitLab

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:24 PM
bzimport set Reference to bz27731.

Hi - do you see this same error when you go to the page Special:UnusedProperties? If so, it's actually a bug in Semantic MediaWiki.

anton.kochkov wrote:

Yes. Same error on Special:UnusedProperties

Okay - I'm marking this as a duplicate of bug 27380.

  • This bug has been marked as a duplicate of bug 27380 ***
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.