Manual talk:FixDoubleRedirects.php
Add topicAppearance
Latest comment: 6 years ago by Varlin in topic Database error when using this script
I have read this manual, and I'm not really helped. Is there a way for users, admins, or anyone who doesn't have direct access to the server to use this script to fix double redirects?Joeytje50 (talk) 09:31, 31 May 2012 (UTC)
Database error when using this script
[edit]Hi, I have lots of double redirections on my wiki, and I'm trying to use this script via maintenance shell extension, but I get databse errors. For example, when launching the script on the page "Blanquisme", I get this output.
[WiWExuI7zJQcDMbmg4Q7ZwAAAU4] /Sp%C3%A9cial:MaintenanceShell Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT page_latest FROM `page` WHERE page_id = '2490' AND page_namespace = '0' AND page_title = 'Blanquiste' LIMIT 1 FOR UPDATE Function: WikiPage::lockAndGetLatest Error: 1205 Lock wait timeout exceeded; try restarting transaction (sql-10.proxgroup.fr:3306) Backtrace: #0 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #1 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php(1269): Wikimedia\Rdbms\Database->query(string, string) #2 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/libs/rdbms/database/Database.php(1095): Wikimedia\Rdbms\Database->select(string, string, array, string, array) #3 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/page/WikiPage.php(2930): Wikimedia\Rdbms\Database->selectField(string, string, array, string, array) #4 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/page/WikiPage.php(1701): WikiPage->lockAndGetLatest() #5 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/page/WikiPage.php(1619): WikiPage->doModify(WikitextContent, integer, User, string, array) #6 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/jobqueue/jobs/DoubleRedirectJob.php(171): WikiPage->doEditContent(WikitextContent, string, integer, boolean, User) #7 /var/www/vhosts/wikirouge.net/public_html/wiki/maintenance/fixDoubleRedirects.php(108): DoubleRedirectJob->run() #8 /var/www/vhosts/wikirouge.net/public_html/wiki/extensions/MaintenanceShell/includes/SpecialMaintenanceShell.php(159): FixDoubleRedirects->execute() #9 /var/www/vhosts/wikirouge.net/public_html/wiki/extensions/MaintenanceShell/includes/SpecialMaintenanceShell.php(94): SpecialMaintenanceShell->mainshellExec(string, string) #10 [internal function]: SpecialMaintenanceShell->onSubmit(array, HTMLForm) #11 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/htmlform/HTMLForm.php(663): call_user_func(array, array, HTMLForm) #12 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/htmlform/HTMLForm.php(555): HTMLForm->trySubmit() #13 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/htmlform/HTMLForm.php(570): HTMLForm->tryAuthorizedSubmit() #14 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/specialpage/FormSpecialPage.php(155): HTMLForm->show() #15 /var/www/vhosts/wikirouge.net/public_html/wiki/extensions/MaintenanceShell/includes/SpecialMaintenanceShell.php(19): FormSpecialPage->execute(NULL) #16 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/specialpage/SpecialPage.php(522): SpecialMaintenanceShell->execute(NULL) #17 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL) #18 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext) #19 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/MediaWiki.php(862): MediaWiki->performRequest() #20 /var/www/vhosts/wikirouge.net/public_html/wiki/includes/MediaWiki.php(523): MediaWiki->main() #21 /var/www/vhosts/wikirouge.net/public_html/wiki/index.php(43): MediaWiki->run() #22 {main}
Any idea ? I already tried to launch update.php, but it did not help. --Varlin (talk) 18:29, 4 December 2017 (UTC)