Last modified: 2014-11-19 11:54:58 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
First Last Prev Next    This bug is not in your last search results.
Bug 25450 - Fix PostgreSQL support for Sematic MW
Fix PostgreSQL support for Sematic MW
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
All All
: Normal trivial (vote)
: ---
Assigned To: Markus Krötzsch
:
Depends on: 42659
Blocks: postgres
  Show dependency tree / graph
 
Reported: 2010-10-08 11:05 UTC by Thorsten Glaser
Modified: 2014-11-19 11:54 UTC (History)
6 users (show)

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

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

Description Thorsten Glaser 2010-10-08 11:05:18 UTC 
http://semantic-mediawiki.org/wiki/PostgreSQL says:

select max(smw_id) from smw_ids;    -- get value
alter sequence smw_ids_smw_id_seq restart with x + 1  -- value from select above, add 1


You can do it like this, in the code, programmatically, instead:

SELECT setval('smw_ids_smw_id_seq', (SELECT max(smw_id)+1 FROM smw_ids));


We (FusionForge and Evolvis) use PostgreSQL exclusively, as MySQL is not a database. There may be interest in integrating SMW by my employer, which will involve me packaging it for Debian.
Comment 1 Niklas Laxström 2010-10-08 11:23:19 UTC 
Changing summary. Trolling doesn't help.
Comment 2 John Morton 2011-02-06 16:31:00 UTC 
Is that initializer query actually necessary anymore? A fresh install of 1.5.4 seemed to work out of the box for me.
Comment 3 Jeroen De Dauw 2011-02-06 19:44:22 UTC 
I'm not sure about that particular query, but all the stuff is currently in the same script, and this script does need to be run in order to use SMW.
Comment 4 MWJames 2014-11-19 11:54:58 UTC 
Expected to be solved by [0].

[0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/pull/638
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