[MediaWiki-l] upgrade to 1.35.0 fails

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[MediaWiki-l] upgrade to 1.35.0 fails

Jörn Clausen

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: