Page MenuHomePhabricator

Lost pages after deployed addtional namespaces on shn.wiktionary
Closed, ResolvedPublicBUG REPORT

Description

There are some pages (Rhymes and Portal pages) that were created in the mainspace before the additional namespaces was deployed at shn.wiktionary (T330376). All those pages are lost after deployed additional namespaces. It might be the same issue like (T328634). You can check lost pages (here). Thanks.

2023-02-24_05h39_52.png (354×1 px, 123 KB)

2023-02-24_05h40_59.png (122×1 px, 38 KB)

Event Timeline

Mentioned in SAL (#wikimedia-operations) [2023-02-23T23:25:40Z] <zabe> mwscript namespaceDupes.php shnwiktionary --fix # T330456

pagelinks from=33356 ns=0 dbk=Appendix:ဢိင်းၵလဵတ်ႈ_pronunciation -> တွၼ်ႈၸပ်းႁၢင်:ဢိင်းၵလဵတ်ႈ_pronunciation
Wikimedia\Rdbms\DBQueryError from line 1534 of /srv/mediawiki/php-1.40.0-wmf.24/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 = '25628' AND tl_target_id = 669' at line 1
Function: NamespaceDupes::checkLinkTable
Query: UPDATE IGNORE `templatelinks` SET 1=0 WHERE tl_from = '25628' AND tl_target_id = 669

#0 /srv/mediawiki/php-1.40.0-wmf.24/includes/libs/rdbms/database/Database.php(1518): Wikimedia\Rdbms\Database->getQueryException('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...')
#1 /srv/mediawiki/php-1.40.0-wmf.24/includes/libs/rdbms/database/Database.php(1492): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...')
#2 /srv/mediawiki/php-1.40.0-wmf.24/includes/libs/rdbms/database/Database.php(865): Wikimedia\Rdbms\Database->reportQueryError('You have an err...', 1064, 'UPDATE IGNORE `...', 'NamespaceDupes:...', false)
#3 /srv/mediawiki/php-1.40.0-wmf.24/includes/libs/rdbms/database/Database.php(1763): Wikimedia\Rdbms\Database->query('UPDATE IGNORE `...', 'NamespaceDupes:...', 128)
#4 /srv/mediawiki/php-1.40.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->update('templatelinks', Array, Array, 'NamespaceDupes:...', Array)
#5 /srv/mediawiki/php-1.40.0-wmf.24/includes/libs/rdbms/database/DBConnRef.php(401): Wikimedia\Rdbms\DBConnRef->__call('update', Array)
#6 /srv/mediawiki/php-1.40.0-wmf.24/maintenance/namespaceDupes.php(466): Wikimedia\Rdbms\DBConnRef->update('templatelinks', Array, Array, 'NamespaceDupes:...', Array)
#7 /srv/mediawiki/php-1.40.0-wmf.24/maintenance/namespaceDupes.php(225): NamespaceDupes->checkLinkTable('templatelinks', 'tl', 102, 'Appendix', Array)
#8 /srv/mediawiki/php-1.40.0-wmf.24/maintenance/namespaceDupes.php(116): NamespaceDupes->checkAll(Array)
#9 /srv/mediawiki/php-1.40.0-wmf.24/maintenance/includes/MaintenanceRunner.php(609): NamespaceDupes->execute()
#10 /srv/mediawiki/php-1.40.0-wmf.24/maintenance/doMaintenance.php(99): MediaWiki\Maintenance\MaintenanceRunner->run()
#11 /srv/mediawiki/php-1.40.0-wmf.24/maintenance/namespaceDupes.php(730): require_once('/srv/mediawiki/...')
#12 /srv/mediawiki/multiversion/MWScript.php(118): require_once('/srv/mediawiki/...')
#13 {main}
zabe@mwmaint1002:~$
Zabe claimed this task.

Applied patch from T328634#8593132, which seems to have worked, pages should be back now.