Page MenuHomePhabricator
Create Task
Maniphest T187183

Database error when running install script with postgres: 23505 ERROR: duplicate key value violates unique constant "updatelog_pkey". (Key ul_key from filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql already exists)
Closed, DuplicatePublic
Actions

Description

Hey,
Trying to install and set up MediaWiki on my machine with postgreSQL. However got this error. Any suggestions on what I could do?

Screenshot from 2018-02-13 14-09-15.png (1×3 px, 800 KB)

Related Objects

Event Timeline

• aniansson created this task.Feb 13 2018, 1:10 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 13 2018, 1:10 PM
Aklapper added a comment.Feb 13 2018, 2:22 PM

Hi @aniansson, thanks for taking the time to report this!
Which exact MediaWiki version is this about? Which Postgres version? (Also, can you please post text as text so it can be found by search engines? Thanks!)
Is this an update, as it says "MediaWiki tables seem to already exist"? If so, from which exact version? How did you upgrade the extensions?

(This might turn out to be a support request for https://www.mediawiki.org/wiki/Project:Support_desk instead of a software bug.)

Aklapper renamed this task from Database error when running install script with postgres to Database error when running install script with postgres: 23505 ERROR: duplicate key value violates unique constant "updatelog_pkey". (Key ul_key from filearchive-fa_major_mime-patch-fa_major_mime-chemical.sql already exists).Feb 13 2018, 2:22 PM
• aniansson added a comment.Feb 14 2018, 12:16 PM

Hi, this is not an update.

This is me trying to get Mediawiki running on my machine for the first time. I think the mediawiki version is 1.31.0 and the postgres version is 9.5.11

• aniansson added a comment.Feb 14 2018, 12:23 PM

nevermind, it seems to be wroking now. not sure why or how, guess thats programming. ;)

Aklapper added a comment.Feb 14 2018, 1:01 PM

Great to hear it works for you now!

Issue looks like this is the same problem as T167924, hence closing as duplicate.

Aklapper closed this task as a duplicate of T167924: WebInstaller and DatabasePostgres throws Error: 23505 ERROR: duplicate key value violates unique constraint "updatelog_pkey".Feb 14 2018, 1:01 PM
Tobi_WMDE_SW added a project: User-aniansson.May 2 2018, 8:48 AM
Tobi_WMDE_SW moved this task from Backlog to Completed on the User-aniansson board.May 2 2018, 8:52 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL