Hello!
I just tried to upgrade some wikis from 1.31.6 and 1.34.1 to 1.35.0. The
process fails with
...recentchanges table does not contain rc_user_text field.
...logging table does not contain log_user field.
...logging table does not contain log_user_text field.
Adding index redirect_pkey to table redirect
...Wikimedia\Rdbms\DBQueryError from line 1699 of
/data/mediawiki/software/mediaw
iki-1.35.0/includes/libs/rdbms/database/Database.php: Error 23505:
ERROR: could not create unique index "redirect_pkey"
DETAIL: Key (rd_from)=(2527) is duplicated.
Function: Wikimedia\Rdbms\Database::sourceFile(
/data/mediawiki/software/mediawiki-1.35.0/maintenance/postgres/archives/patch-
redirect-pk.sql )
Query: ALTER TABLE redirect ADD PRIMARY KEY (rd_from)
and the table "redirect" indeed contains duplicate and triplicate
entries for a lot of my wikis.
IMHO either the update script should collapse these entries, or the
requirement for an index should be dropped from the installer. Does
anyone have a quick SQL snippet to fix these tables?
Joern
--
Jörn Clausen
BITS - Bielefelder IT-Servicezentrum
https://www.uni-bielefeld.de/bits