Topic on Extension talk:RottenLinks

Jump to navigation Jump to search

Special:RottenLinks doesn't show rotten links

5
Summary by Kghbln

Run "updateExternalLinks.php" provided with the extension every time you would like to create or update the list of rotten links.

Bryandamon (talkcontribs)

Great idea for an extension!

After installing, running the update script, and navigating to Special:RottenLinks, it only shows the table with "No results" even though I created a bad link (https://www.rottenestlinks.com) on the main page. Posting this here because I couldn't log into Miraheze Phabricator with my GitHub account and I don't have a Miraheze account. Any suggestions?

My Setup:

  • MediaWiki 1.31.1
  • PHP 7.2.10
  • MySQL 5.7.23
  • RottenLinks 1.0.1 (3a7b171)20:46, 16 October 2018
Debug log

[DBConnection] Wikimedia\Rdbms\LoadBalancer::openConnection: connected to database 0 at 'localhost'.

[DBQuery] wikidb BEGIN /* Wikimedia\Rdbms\Database::query (LCStoreDB::get) */

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'list' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'preload' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'preload' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'specialPageAliases' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'namespaceGenderAliases' LIMIT 1

[error] [6b50895c18ed291af3293963] /mediawiki/index.php/Special:RottenLinks ErrorException from line 309 of /usr/share/mediawiki/includes/debug/MWDebug.php: PHP Notice: Did not find alias for special page 'RottenLinks'. Perhaps no aliases are defined for it? [Called from SpecialPageFactory::getLocalNameFor in /usr/share/mediawiki/includes/specialpage/SpecialPageFactory.php at line 683]

[error] [6b50895c18ed291af3293963] /mediawiki/index.php/Special:RottenLinks ErrorException from line 309 of /usr/share/mediawiki/includes/debug/MWDebug.php: PHP Notice: Did not find alias for special page 'RottenLinks'. Perhaps no aliases are defined for it? [Called from SpecialPageFactory::getLocalNameFor in /usr/share/mediawiki/includes/specialpage/SpecialPageFactory.php at line 683]

User: loading options for user 1 from override cache.

[MessageCache] MessageCache::load: Loading en... local cache is empty, got from global cache

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:rottenlinks' LIMIT 1

Unstubbing $wgParser on call of $wgParser::firstCallInit from MessageCache->transform

Parser: using preprocessor: Preprocessor_DOM

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'magicWords' LIMIT 1

Unstubbing $wgLang on call of $wgLang::_unstub from ParserOptions->__construct

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:rottenlinks-summary' LIMIT 1

ContextSource::getContext (RottenLinksPager): called and $context is null. Using RequestContext::getMain() for sanity

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:rottenlinks-table-external' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:rottenlinks-table-response' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:rottenlinks-table-usage' LIMIT 1

[DBQuery] wikidb SELECT /* IndexPager::buildQueryInfo (RottenLinksPager) */ rl_externallink,rl_respcode,rl_pageusage FROM `rottenlinks` ORDER BY rl_externallink LIMIT 51

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:sort-descending' LIMIT 1

[error] [6b50895c18ed291af3293963] /mediawiki/index.php/Special:RottenLinks ErrorException from line 309 of /usr/share/mediawiki/includes/debug/MWDebug.php: PHP Notice: Did not find alias for special page 'RottenLinks'. Perhaps no aliases are defined for it? [Called from SpecialPageFactory::getLocalNameFor in /usr/share/mediawiki/includes/specialpage/SpecialPageFactory.php at line 683]

[error] [6b50895c18ed291af3293963] /mediawiki/index.php/Special:RottenLinks ErrorException from line 309 of /usr/share/mediawiki/includes/debug/MWDebug.php: PHP Notice: Did not find alias for special page 'RottenLinks'. Perhaps no aliases are defined for it? [Called from SpecialPageFactory::getLocalNameFor in /usr/share/mediawiki/includes/specialpage/SpecialPageFactory.php at line 683]

[error] [6b50895c18ed291af3293963] /mediawiki/index.php/Special:RottenLinks ErrorException from line 309 of /usr/share/mediawiki/includes/debug/MWDebug.php: PHP Notice: Did not find alias for special page 'RottenLinks'. Perhaps no aliases are defined for it? [Called from SpecialPageFactory::getLocalNameFor in /usr/share/mediawiki/includes/specialpage/SpecialPageFactory.php at line 683]

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:table_pager_empty' LIMIT 1

MediaWiki::preOutputCommit: primary transaction round committed

MediaWiki::preOutputCommit: pre-send deferred updates completed

MediaWiki::preOutputCommit: LBFactory shutdown completed

[DBQuery] wikidb SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) */ page_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title FROM `page` WHERE (page_namespace = '2' AND page_title = 'Bryan_Hilderbrand') OR (page_namespace = '3' AND page_title = 'Bryan_Hilderbrand') OR (page_namespace = '4' AND page_title IN ('Privacy_policy','About','General_disclaimer') )

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'rtl' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'capitalizeAllNouns' LIMIT 1

[DBQuery] wikidb SELECT /* User::checkNewtalk */ user_id FROM `user_newtalk` WHERE user_id = '1' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'linkPrefixExtension' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:mytalk' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:mypreferences' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:mywatchlist' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:mycontris' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:pt-userlogout' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:nstab-special' LIMIT 1

[DBQuery] wikidb SELECT /* User::idFromName */ user_id FROM `user` WHERE user_name = 'Bryan Hilderbrand' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'separatorTransformTable' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'digitTransformTable' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'defaultDateFormat' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:january' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:february' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:march' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:april' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:may_long' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:june' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:july' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:august' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:september' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:october' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:november' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:december' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:jan' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:feb' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:mar' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:apr' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:may' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:jun' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:jul' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:aug' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:sep' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:oct' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:nov' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:dec' LIMIT 1

[DBQuery] wikidb SELECT /* ResourceLoaderWikiModule::getTitleInfo */ page_namespace,page_title,page_touched,page_len,page_latest FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js') )

User: loading options for user 1 from override cache.

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-userpage' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-userpage' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-mytalk' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:red-link-title' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-mytalk' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-preferences' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-preferences' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-watchlist' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-watchlist' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-mycontris' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-mycontris' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-logout' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-logout' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-ca-nstab-special' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-ca-nstab-special' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-more-actions' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-p-navigation' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-p-tb' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:upload' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-t-upload' LIMIT 1

[DBQuery] wikidb SELECT /* LCStoreDB::get */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-t-upload' LIMIT 1

[gitinfo] Computed cacheFile=/usr/share/mediawiki/gitinfo.json for /usr/share/mediawiki

[gitinfo] Cache incomplete for /usr/share/mediawiki

MacFan4000 (talkcontribs)

Try running extensions/RottenLinks/updateExternalLinks.php

Bryandamon (talkcontribs)

That was it, thanks!

Bryandamon (talkcontribs)

After updateExternalLinks.php is run once, will the extension continue to update or is this needed every time (or create a cron job)?

MacFan4000 (talkcontribs)

It is needed every time (or cron)