Jump to content

Topic on Project:Support desk

upgrade to 1.35.0 Duplicate entry '0-0' for key

2
Harugon1 (talkcontribs)

MediaWiki 1.35.0

PHP 7.4.5 (fpm-fcgi)

MySQL 8.0.21-0ubuntu0.20.04.4


run update.php, I get this error.


Remove this block ??

https://i.imgur.com/1DYsvEe.jpg


Updating length of ll_lang in `langlinks` ...done.

Updating length of site_language in `sites` ...done.

...index ipb_address_unique on table ipblocks includes field ipb_anon_only.

Removing ipb_anon_only column from ipb_address_unique index ...Wikimedia\Rdbms\DBQueryError from line 1699 of /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php: Error 1062: Duplicate entry '0-0' for key 'ipblocks.ipb_address_unique' (localhost)

Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/html/mediawiki/maintenance/archives/patch-ipblocks-fix-ipb_address_unique.sql )

Query: ALTER TABLE `ipblocks` DROP INDEX ipb_address_unique, ADD UNIQUE INDEX ipb_address_unique (ipb_address(255), ipb_user, ipb_auto )

#0 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException()

#1 /var/www/html/mediawiki/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()

#2

Jörgi123 (talkcontribs)

> Remove this block ? ?

Yes, I think the two blocks are identical. I would try removing one of them and I would then try running update.php again.