Page MenuHomeMiraheze

RottenLinksProject
ActivePublic

Members (1)

Details

Description

A project for the RottenLinks extension being developed to easily make the detection and management of dead links easier.

Recent Activity

Fri, Feb 5

Universal_Omega moved T5700: Make RottenLinks more effective at status detection from Features to Maintenance on the RottenLinks board.
Fri, Feb 5, 18:54 · MediaWiki (SRE), RottenLinks

Jan 10 2021

Universal_Omega moved T5700: Make RottenLinks more effective at status detection from Backlog to Features on the RottenLinks board.
Jan 10 2021, 08:05 · MediaWiki (SRE), RottenLinks

Jan 1 2021

Southparkfan closed T6095: Lack of PK on RottenLinks tables causes huge replication lag as Resolved.

Done (using P365).

Jan 1 2021, 19:20 · RottenLinks, Database, Site Reliability Engineering

Dec 22 2020

John added a comment to T6095: Lack of PK on RottenLinks tables causes huge replication lag.

@Southparkfan status?

Dec 22 2020, 13:30 · RottenLinks, Database, Site Reliability Engineering

Oct 24 2020

Southparkfan lowered the priority of T6095: Lack of PK on RottenLinks tables causes huge replication lag from High to Normal.

I was deploying the ALTERs to the wikis while RottenLinks was disabled (the ALTERs cannot be done live using pt-osc, unfortunately), but I forgot to re-enable RottenLinks. For now, I have enabled RottenLinks. The extension only needs to be disabled again (and the update scripts killed) if you are deploying the schema changes on databases.

Oct 24 2020, 18:14 · RottenLinks, Database, Site Reliability Engineering

Oct 13 2020

John added a comment to T6095: Lack of PK on RottenLinks tables causes huge replication lag.

@John it doesn't look like larger VARCHARs are possible. Even if you don't use the rl_id field, it does seem to be working fine at first glance, without fundamentally changing the schema (the current, old fields can stay). What do you think?

Oct 13 2020, 22:01 · RottenLinks, Database, Site Reliability Engineering
Southparkfan added a comment to T6095: Lack of PK on RottenLinks tables causes huge replication lag.

@John it doesn't look like larger VARCHARs are possible. Even if you don't use the rl_id field, it does seem to be working fine at first glance, without fundamentally changing the schema (the current, old fields can stay). What do you think?

Oct 13 2020, 21:40 · RottenLinks, Database, Site Reliability Engineering

Oct 10 2020

Southparkfan added a comment to T6095: Lack of PK on RottenLinks tables causes huge replication lag.
02:56:34 <+SPF|Cloud> JohnLewis: db7 doesn't seem to accept a varchar(8192) for rl_externallink
02:56:38 <+SPF|Cloud> ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
03:01:39 <+SPF|Cloud> looking at https://mariadb.com/kb/en/innodb-system-variables/#innodb_large_prefix and https://mariadb.com/kb/en/innodb-large_prefix-deprecated-resulting-key-length/, relying on such huge varchars for index keys seems deprecated
03:09:42 <+SPF|Cloud> I don't think having the varchars as primary key is a good idea, given the deprecation comments. What do you think?
Oct 10 2020, 01:54 · RottenLinks, Database, Site Reliability Engineering

Oct 9 2020

Southparkfan reopened T6095: Lack of PK on RottenLinks tables causes huge replication lag as "Open".

While the change was committed, the change has not been applied to existing tables.

Oct 9 2020, 21:47 · RottenLinks, Database, Site Reliability Engineering

Sep 8 2020

John closed T6095: Lack of PK on RottenLinks tables causes huge replication lag as Resolved.
Sep 8 2020, 17:57 · RottenLinks, Database, Site Reliability Engineering
John moved T6095: Lack of PK on RottenLinks tables causes huge replication lag from Backlog to Bugs on the RottenLinks board.
Sep 8 2020, 17:50 · RottenLinks, Database, Site Reliability Engineering
Paladox added a project to T6095: Lack of PK on RottenLinks tables causes huge replication lag: RottenLinks.
Sep 8 2020, 13:43 · RottenLinks, Database, Site Reliability Engineering

Jun 30 2020

MacFan4000 removed a member for RottenLinks: MacFan4000.
Jun 30 2020, 16:01

Jun 18 2020

John closed T5772: ErrorException from line 53 of /srv/mediawiki/w/extensions/RottenLinks/maintenance/updateExternalLinks.php: PHP Notice: Undefined offset: 2 as Resolved.
Jun 18 2020, 17:07 · Production Error, RottenLinks

Jun 17 2020

Reception123 added a project to T5772: ErrorException from line 53 of /srv/mediawiki/w/extensions/RottenLinks/maintenance/updateExternalLinks.php: PHP Notice: Undefined offset: 2: Production Error.
Jun 17 2020, 14:57 · Production Error, RottenLinks

Jun 16 2020

Paladox triaged T5772: ErrorException from line 53 of /srv/mediawiki/w/extensions/RottenLinks/maintenance/updateExternalLinks.php: PHP Notice: Undefined offset: 2 as Normal priority.
Jun 16 2020, 21:37 · Production Error, RottenLinks

Jun 7 2020

OnKoydenKovuldum closed T5706: Spam as Resolved.

WikiLirik sözcüleri eleştirisel pozitif-negatif düşünce karşılaştırma
PyschoLyricWiki Attack Groups
Ben ötesi psikoloji

Jun 7 2020, 03:40 · Trash

Jun 6 2020

John triaged T5700: Make RottenLinks more effective at status detection as Low priority.
Jun 6 2020, 11:20 · MediaWiki (SRE), RottenLinks

Mar 23 2020

John reassigned T5345: Issues with version 1.0.8 from John to Seb35.
Mar 23 2020, 17:00 · RottenLinks
John closed T5345: Issues with version 1.0.8 as Resolved.

Thank you for the contribution and spotting issues that escaped testing for this particular extension!

Mar 23 2020, 16:59 · RottenLinks
Seb35 updated the task description for T5345: Issues with version 1.0.8.
Mar 23 2020, 16:05 · RottenLinks
Seb35 updated subscribers of T5345: Issues with version 1.0.8.

The third point is linked to T5295.

Mar 23 2020, 16:04 · RottenLinks
Seb35 created T5345: Issues with version 1.0.8.
Mar 23 2020, 15:58 · RottenLinks

Mar 22 2020

John closed T5295: Protocol-independent links are badly handled as Resolved.
Mar 22 2020, 20:39 · RottenLinks
John closed T5237: Allow opt-in blacklist of sites that return status codes improperly as Resolved.
Mar 22 2020, 20:38 · RottenLinks
John closed T5069: Add help page link as Resolved.
Mar 22 2020, 20:38 · RottenLinks
John closed T4422: Convert RottenLinks to MediaWiki Config interface as Resolved.
Mar 22 2020, 20:38 · RottenLinks, Technical-Debt
John closed T3706: Define a maximum width for the colums as Resolved.
Mar 22 2020, 20:38 · RottenLinks
John closed T3706: Define a maximum width for the colums, a subtask of T3718: Updates to RottenLinks extension, as Resolved.
Mar 22 2020, 20:38 · RottenLinks
John closed T5076: Special:RottenLinks should be in the same section of Special:SpecialPages as Special:LinkSearch is as Declined.

RottenLinks is more of a maintenance-based tools. The current section therefore is appropriate.

Mar 22 2020, 18:36 · RottenLinks

Mar 2 2020

Seb35 edited projects for T5295: Protocol-independent links are badly handled, added: RottenLinks; removed Configuration.

Sorry for the bad classification.

Mar 2 2020, 10:33 · RottenLinks

Feb 16 2020

John closed T5194: "Notice: Did not find alias for special page 'RottenLinks' ..." as Declined.

The name “RottenLinks” is a noun and as such would not have another translatable alternatives.

Feb 16 2020, 17:11 · RottenLinks
RhinosF1 triaged T5237: Allow opt-in blacklist of sites that return status codes improperly as Low priority.
Feb 16 2020, 16:30 · RottenLinks
RhinosF1 triaged T5194: "Notice: Did not find alias for special page 'RottenLinks' ..." as Low priority.
Feb 16 2020, 16:14 · RottenLinks

Feb 4 2020

Tenbergen created T5194: "Notice: Did not find alias for special page 'RottenLinks' ..." .
Feb 4 2020, 18:04 · RottenLinks

Jan 8 2020

John added a comment to T5066: Support multiple Wiki databases.

The extension is built on standard MediaWiki code - the support for —wiki is through standard MediaWiki (as proven above).

Jan 8 2020, 19:41 · RottenLinks
IntactiWiki added a comment to T5066: Support multiple Wiki databases.

I fully understand what you explain about the PHP magic constant __DIR__ - but shouldn't your script then at least support the given --wiki database name and use it? In all my tests, it does not.

Jan 8 2020, 14:51 · RottenLinks
John added a comment to T5066: Support multiple Wiki databases.

You say;

Jan 8 2020, 13:09 · RottenLinks
IntactiWiki added a comment to T5066: Support multiple Wiki databases.

Thank you for documenting your approach. Here is mine - using the unpatched script updateExternalLinks.php:

Jan 8 2020, 11:19 · RottenLinks
John added a comment to T5066: Support multiple Wiki databases.
root@mw1:~# cd /srv/mediawiki/w/extensions/RottenLinks/maintenance/
root@mw1:/srv/mediawiki/w/extensions/RottenLinks/maintenance# php updateExternalLinks.php
The wiki database '' was not found.
Jan 8 2020, 09:59 · RottenLinks
IntactiWiki added a comment to T5066: Support multiple Wiki databases.

Can you please tell me HOW you tested it? As I already explained, my installations are like this:

Jan 8 2020, 07:09 · RottenLinks

Jan 7 2020

Jidanni triaged T5076: Special:RottenLinks should be in the same section of Special:SpecialPages as Special:LinkSearch is as Low priority.
Jan 7 2020, 19:21 · RottenLinks
Jidanni added a comment to T5070: Add timestamp showing when list was compiled.

OK!, but
$ w3m -dump https://abj.miraheze.org/wiki/Special:RottenLinks?stats=1

Status of external links
Jan 7 2020, 18:30 · RottenLinks

Jan 6 2020

John closed T5066: Support multiple Wiki databases as Invalid.

wfGetDB( DB_MASTER ) opens a database connection from the wiki where the script is being ran (namely the --wiki option, or whatever the value of $wgDBname is).

Jan 6 2020, 12:47 · RottenLinks
IntactiWiki added a comment to T5066: Support multiple Wiki databases.

Hi John,
as I wrote in my initial message, the original PHP script does not recognize when run from e.g. /MYPATH/wiki/en/extensions/ - it then also checks all URLs in the IntactiWiki pool's database named intactiwiki, but not in the English Intactiwiki database, which is named intactiwiki_en. My patch fixes this for me.

Jan 6 2020, 10:26 · RottenLinks
John closed T5070: Add timestamp showing when list was compiled as Resolved.

This is found under statistics.

Jan 6 2020, 06:23 · RottenLinks
John closed T5071: No way for user to update Rottenlinks as Declined.

The script is fairly bandwidth intensive. It’s not reasonable to allow any user on a wiki to run it on demand - it would be a decision of the system administrators running the extension when to run it.

Jan 6 2020, 06:21 · RottenLinks
Jidanni triaged T5072: Special:RottenLinks finds problems on new wikis as Low priority.
Jan 6 2020, 02:25 · Configuration
Jidanni added a comment to T5071: No way for user to update Rottenlinks.

I am not saying "please update it for my wiki".
I am saying "please give users a way to update it without needing a Steward's help."

Jan 6 2020, 02:21 · RottenLinks
Jidanni triaged T5071: No way for user to update Rottenlinks as Low priority.
Jan 6 2020, 02:20 · RottenLinks