https://bugzilla.wikimedia.org/show_bug.cgi?id=27731
Summary: Creating Template page show database error for
PostgreSQL 9.0.1
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: critical
Priority: Normal
Component: SemanticForms
AssignedTo: yaro...@gmail.com
ReportedBy: anton.koch...@gmail.com
CC: wikibugs-l@lists.wikimedia.org
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}
--
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
