Mailing List Archive

upgrade to 1.35.0 fails

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
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(
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?


Jörn Clausen
BITS - Bielefelder IT-Servicezentrum

MediaWiki-l mailing list
To unsubscribe, go to: