Last modified: 2012-08-04 20:48:59 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T29731, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 27731 - Creating Template page show database error for PostgreSQL 9.0.1
Creating Template page show database error for PostgreSQL 9.0.1
Status: RESOLVED DUPLICATE of bug 27380
Product: MediaWiki extensions
Classification: Unclassified
SemanticForms (Other open bugs)
unspecified
All All
: Normal critical (vote)
: ---
Assigned To: Yaron Koren
:
Depends on:
Blocks: postgres
  Show dependency tree / graph
 
Reported: 2011-02-26 02:38 UTC by Anton Kochkov
Modified: 2012-08-04 20:48 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Anton Kochkov 2011-02-26 02:38:11 UTC 
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}
Comment 1 Yaron Koren 2011-02-27 15:28:39 UTC 
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.
Comment 2 Anton Kochkov 2011-02-27 15:52:46 UTC 
Yes. Same error on Special:UnusedProperties
Comment 3 Yaron Koren 2011-02-27 16:00:32 UTC 
Okay - I'm marking this as a duplicate of bug 27380.

*** This bug has been marked as a duplicate of bug 27380 ***
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links