https://bugzilla.wikimedia.org/show_bug.cgi?id=42659
Web browser: ---
Bug #: 42659
Summary: Unable to install SMW 1.8 with PostgreSQL
Product: MediaWiki extensions
Version: unspecified
Platform: PC
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Semantic MediaWiki
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected]
Classification: Unclassified
Mobile Platform: ---
OS: Fedora 17
MediaWiki: 1.20 (from source)
SMW: 1.8
PostgreSQL: 9.1.6-1.fc17
Following installation instructions, I unpacked the extensions and enabled them
in LocalSettings.php. Now:
- Accessing the main wiki page results in blank page, nothing in apache's
error_log and status 500 in access log
- Special:SMWAdmin can be accessed, but "Initialise or upgrade tables" results
in the same error as below but without the backtrace (didn't know how to make
php produce one).
- I figured that running "php maintenance/SMW_setup.php" should do the same.
The result is:
Selected storage "SMWSQLStore3" for update!
Setting up standard database configuration for SMW ...
Selected storage engine is "SMWSQLStore" (or an extension thereof)
Checking table "smw_object_ids" ...
Table not found, now creating...
... done.
A database error has occurred. Did you forget to run maintenance/update.php
after upgrading? See:
https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: CREATE INDEX "smw_object_ids" ON "smw_object_ids" USING btree(smw_id)
Function: SMWSQLHelpers::createIndex
Error: 42P07 ERROR: relation "smw_object_ids" already exists
Backtrace:
#0 /var/www/mw/includes/db/DatabasePostgres.php(472):
DatabaseBase->reportQueryError('ERROR: relatio...', '42P07', 'CREATE INDEX
"s...', 'SMWSQLHelpers::...', false)
#1 /var/www/mw/includes/db/Database.php(899):
DatabasePostgres->reportQueryError('ERROR: relatio...', '42P07', 'CREATE INDEX
"s...', 'SMWSQLHelpers::...', false)
#2
/var/www/mw/extensions/SemanticMediaWiki/includes/storage/SMW_SQLHelpers.php(495):
DatabaseBase->query('CREATE INDEX "s...', 'SMWSQLHelpers::...')
#3
/var/www/mw/extensions/SemanticMediaWiki/includes/storage/SMW_SQLHelpers.php(376):
SMWSQLHelpers::createIndex(Object(DatabasePostgres), 'INDEX',
'"smw_object_ids...', '"smw_object_ids...', 'smw_id', NULL)
#4
/var/www/mw/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3_SetupHandlers.php(101):
SMWSQLHelpers::setupIndex('smw_object_ids', Array, Object(DatabasePostgres))
#5
/var/www/mw/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3_SetupHandlers.php(38):
SMWSQLStore3SetupHandlers->setupTables(true, Object(DatabasePostgres))
#6
/var/www/mw/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3.php(396):
SMWSQLStore3SetupHandlers->setup(true)
#7
/var/www/mw/extensions/SemanticMediaWiki/includes/storage/SMW_Store.php(451):
SMWSQLStore3->setup(true)
#8 /var/www/mw/extensions/SemanticMediaWiki/maintenance/SMW_setup.php(91):
SMWStore::setupStore(true)
#9 /var/www/mw/maintenance/doMaintenance.php(110): SMWSetupScript->execute()
#10 /var/www/mw/extensions/SemanticMediaWiki/maintenance/SMW_setup.php(189):
require_once('/home/mmilata/p...')
#11 {main}
I managed to progress a bit further by poking at the source code but eventually
gave up. Attaching the changes I made -- they are probably useless as I'm
unfamiliar with both SMW codebase and postgres.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
