See parent task. After renaming/translating namespace names, please run namespacesDupes.php to detect and fix any possible issues. Please Paste or phaste the script output, especially if there are any links that can't be fixed automatically. Thank you.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Juan90264 | T304790 Update Namespace translations on Ks Wiki | |||
| Resolved | Lucas_Werkmeister_WMDE | T334277 Run namespaceDupes.php for kswiki |
Event Timeline
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2023-04-12T13:22:04Z] <Lucas_WMDE> lucaswerkmeister-wmde@mwmaint2002:~$ mwscript namespaceDupes kswiki --fix | tee >(phaste -t T334277) # P46538; errors on stderr, cf. T328634
Comment Actions
lucaswerkmeister-wmde@mwmaint2002:~$ mwscript namespaceDupes kswiki --fix | tee >(phaste -t T334277)
0 pages to fix, 0 were resolvable.
templatelinks from=7129 ns=0 dbk=ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز -> ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز
Wikimedia\Rdbms\DBQueryError from line 1523 of /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/Database.php: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1=0 WHERE tl_from = '6661' AND tl_target_id = 4256' at line 1
Function: NamespaceDupes::checkLinkTable
Query: UPDATE IGNORE `templatelinks` SET 1=0 WHERE tl_from = '6661' AND tl_target_id = 4256
#0 /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/Database.php(1507): Wikimedia\Rdbms\Database->getQueryException('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...')
#1 /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/Database.php(1481): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...')
#2 /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/Database.php(854): Wikimedia\Rdbms\Database->reportQueryError('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...', false)
#3 /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/Database.php(1762): Wikimedia\Rdbms\Database->query('UPDATE IGNORE `...', 'NamespaceDupes:...', 128)
#4 /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->update('templatelinks', Array, Array, 'NamespaceDupes:...', Array)
#5 /srv/mediawiki/php-1.41.0-wmf.3/includes/libs/rdbms/database/DBConnRef.php(406): Wikimedia\Rdbms\DBConnRef->__call('update', Array)
#6 /srv/mediawiki/php-1.41.0-wmf.3/maintenance/namespaceDupes.php(467): Wikimedia\Rdbms\DBConnRef->update('templatelinks', Array, Array, 'NamespaceDupes:...', Array)
#7 /srv/mediawiki/php-1.41.0-wmf.3/maintenance/namespaceDupes.php(226): NamespaceDupes->checkLinkTable('templatelinks', 'tl', 828, '\xD9\x85\xD8\xA7\xDA\x88\xDB\x8C\xD9\x88\xD9\x97\xD9\x84', Array)
#8 /srv/mediawiki/php-1.41.0-wmf.3/maintenance/namespaceDupes.php(117): NamespaceDupes->checkAll(Array)
#9 /srv/mediawiki/php-1.41.0-wmf.3/maintenance/includes/MaintenanceRunner.php(681): NamespaceDupes->execute()
#10 /srv/mediawiki/php-1.41.0-wmf.3/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
#11 /srv/mediawiki/multiversion/MWScript.php(140): require_once('/srv/mediawiki/...')
#12 {main}Comment Actions
Dry run output:
0 pages to fix, 0 were resolvable. templatelinks from=7129 ns=0 dbk=ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز -> ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز DRY RUN templatelinks from=6661 ns=0 dbk=ماڈیوٗل:High-use/دَستاویٖز -> ماڈیوٗل:High-use/دَستاویٖز DRY RUN templatelinks from=10890 ns=0 dbk=ماڈیوٗل:IP/دَستاویٖز -> ماڈیوٗل:IP/دَستاویٖز DRY RUN templatelinks from=7184 ns=0 dbk=ماڈیوٗل:Lang/دَستاویٖز -> ماڈیوٗل:Lang/دَستاویٖز DRY RUN templatelinks from=6662 ns=0 dbk=ماڈیوٗل:Lua_banner/دَستاویٖز -> ماڈیوٗل:Lua_banner/دَستاویٖز DRY RUN templatelinks from=6663 ns=0 dbk=ماڈیوٗل:Protection_banner/دَستاویٖز -> ماڈیوٗل:Protection_banner/دَستاویٖز DRY RUN templatelinks from=8269 ns=0 dbk=ماڈیوٗل:Wikidata/دَستاویٖز -> ماڈیوٗل:Wikidata/دَستاویٖز DRY RUN templatelinks from=15389 ns=0 dbk=ماڈیوٗل:WikidataIB/i18n/دَستاویٖز -> ماڈیوٗل:WikidataIB/i18n/دَستاویٖز DRY RUN templatelinks from=10098 ns=0 dbk=ماڈیوٗل:WikidataIB/دَستاویٖز -> ماڈیوٗل:WikidataIB/دَستاویٖز DRY RUN 9 links to fix, 9 were resolvable, 0 were deleted. Looks good!
It’s probably easiest to just purge-with-linksupdate those nine pages by hand? (E.g. in the API sandbox.)
Comment Actions
Sent purge requests for the page ids listed above:
{
"batchcomplete": true,
"purge": [
{
"ns": 828,
"title": "ماڈیوٗل:High-use",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:Lua banner",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:Protection banner",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:Citation/CS1/Configuration",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:Lang",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:Wikidata",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:WikidataIB",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:IP",
"purged": true,
"linkupdate": true
},
{
"ns": 828,
"title": "ماڈیوٗل:WikidataIB/i18n",
"purged": true,
"linkupdate": true
}
]
}Comment Actions
I also ran a script to purge all 366 pages in namespace 828: P46551
This and/or @MarcoAurelio’s purge seems to have helped a lot:
lucaswerkmeister-wmde@mwmaint2002:~$ mwscript namespaceDupes kswiki 0 pages to fix, 0 were resolvable. templatelinks from=7129 ns=0 dbk=ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز -> ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز DRY RUN 1 links to fix, 1 were resolvable, 0 were deleted. Looks good!
Maybe the one remaining link just needs a bit more time for the job queue to run?
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2023-04-12T14:10:27Z] <Lucas_WMDE> lucaswerkmeister-wmde@mwmaint2002:~$ mwscript namespaceDupes kswiki --fix # T334277, fixed the one remaining link
Comment Actions
Nevermind, for that last link --fix actually worked without a DB error ^^ done, I think!
lucaswerkmeister-wmde@mwmaint2002:~$ mwscript namespaceDupes kswiki --fix 0 pages to fix, 0 were resolvable. templatelinks from=7129 ns=0 dbk=ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز -> ماڈیوٗل:Citation/CS1/Configuration/دَستاویٖز 1 links to fix, 1 were resolvable, 0 were deleted. Looks good! lucaswerkmeister-wmde@mwmaint2002:~$ mwscript namespaceDupes kswiki 0 pages to fix, 0 were resolvable. 0 links to fix, 0 were resolvable, 0 were deleted. Looks good!