User Details
- User Since
- Apr 12 2015, 12:29 AM (503 w, 4 d)
- Availability
- Available
- IRC Nick
- Dispenser
- LDAP User
- Dispenser
- MediaWiki User
- Dispenser [ Global Accounts ]
Jun 21 2022
Aug 19 2018
Aug 7 2018
{{Ping project}} uses a Hidden Structure which causes issues for bots, web scrapers, and screen readers. The proper fix is to add the functionality to Echo.
Jul 17 2018
Is there a conpherence for watching the milestone?
Jun 16 2018
From the Green on black skin, it was brought up at Village Pump (screenshot) after I removed the workaround for T147667. Apparently locals styles in MediaWikiMonobook.css are applied after gadget styles.
Jun 5 2018
@Krinkle Could you look into this? Hopefully the fix is a simple modification of T147667: Site and Gadget CSS should apply after core and skin CSS
May 19 2018
Apr 16 2018
Apr 13 2018
@Pentachlorphenol may have volunteered in getting community consensus ;-)
Apr 10 2018
Mar 23 2018
@jcrespo I was developing the script last night, so something might have gone astray. I'll add a PRIMARY KEY so it doesn't happen in the future.
Kill it and drop the table. The script should only take 10 minutes for LOAD DATA
Mar 19 2018
Mar 6 2018
Mar 4 2018
I talked with @jcrespo on IRC and with some digging (P6782) to eventually find out the index I was using wb_ips_site_page was dropped without updating the documentation (T179793#4018800).
Feb 24 2018
Feb 15 2018
According to MPEG-LA, MPEG-2 is patent free in the United States now.
According to MPEG-LA, MPEG-2 is patent free in the United States now.
Feb 14 2018
Similar problem in Internet Explorer 11 and Firefox, but those browsers remove background-image so it affects all high contrast modes.
Feb 13 2018
Feb 12 2018
@Volker_E I tested it, it works. Empty green boxes are better than invisible buttons.
A workaround if we're unable to render icons is to draw boxes when in high contrast mode with border:1px solid transparent;. The transparent color will be forced to the visible foreground color.
Feb 7 2018
Feb 6 2018
@Aklapper I'm currently analyzing SVGs files for problems 404 file, missing xmlns=, font issues, etc. In a month or two, I will download all thumbnails on Commons again for several projects of mine.
Feb 5 2018
Feb 4 2018
File:An Itch in Time.webm is a recent upload with the encoder metadata extracted:
Jan 31 2018
I've compiled a list of [[https://commons.wikimedia.org/w/index.php?oldid=283987037|SVGs missing the xmlns tag]] for anyone who wants to fix them.
Jan 26 2018
Jan 25 2018
@RazeSoldier has done nice work with the patch, but it should be in hexadecimal to be consistent with the API (and every sha1sum tool).
Jan 6 2018
Dec 29 2017
Dec 28 2017
Dec 24 2017
Dec 16 2017
Query just now on ToolForge's analytics cluster (labsdb1010): 13 min 24.37 sec. It seems to be getting worse.
Dec 15 2017
I mean literally just that. You can try out the aforementioned gimped tool which only joins against dplbot 's pre-generated results table for enwiki, The tool calls watchlistraw OAuth or Watchlist Token to create a TEMPORARY TABLE with all the pages that you currently watch.
"Net neutrality vote: FCC repeals Obama-era Internet rules". There are now no obstacles from regulators for getting this implemented
DNG support was torpedoed in the 2016 Community Wishlist Survey due to patent concerns. I'm interested in legal's opinion since the WMF hosted Commons Archive accepts them.
Dec 14 2017
I did something similar years ago to pre-generate thumbnails for WikiMiniAtlas with its unusual sizes (48x48). Stored the content-length and response code. This was useful in multiple ways, we were able to identify corrupt files, missing files, rendering problems, and had a list of thumbnails that somehow were 2 MB in size--Those ended up being very large ICC Profiles.
Dec 12 2017
@jcrespo The current pipeline is:
- A bash/python script on ToolForge which makes 275,000 MW API requests and bundles JSON responses in a .tar.gz on the last day of the month
- A python script on my server downloads that on the first of the month. Processes it which spits out a Tab-Separated Value then loads it into the database.
- (edit) The death_dabs.sql script then for 30 minutes creating a report for users to work off of. (Currently long running query)
Dec 9 2017
Dec 4 2017
Dec 3 2017
I forgot to mention that this is a regression. That code was executing under 1 second 6+ months ago and only in late November I noticed queries failing constantly.
Dec 2 2017
Nov 29 2017
Nov 28 2017
Nov 27 2017
Nov 21 2017
@kaldari An AcoustID web interface for Commons.
Nov 16 2017
@Aklapper The Checkuser information is irrecoverably gone and thus the task can no longer be completed and Invalid. You can change it to decline if you think that's more appropriate.
The team squandered a perfect opportunity where a WP0 pirate broke the ISP blackholing, registered an account on mediawiki.org, and finally created an account on Phabricator to upload files. All on Maroc Telecom IP address missed by Wikipedia Zero Phabricator block and https://gerrit.wikimedia.org/r/#/c/368775/
Nov 15 2017
I hope to see a namespace table added to meta_p. And with more thought. Domain isn't needed, dbname should lose _p per Labs convention, and maybe a gender flag to distinguish Benutzer and Benutzerin depending on future MW plans. Here's what it is currently (note: MediaWiki and MediaWiki Diskussion):
SELECT * FROM s51892_toolserverdb_p.namespacename WHERE dbname LIKE "dewiki_p" ORDER BY FLOOR(ns_id/2), ns_is_favorite DESC, ns_type, ns_name;
dbname | domain | ns_id | ns_name | ns_type | ns_is_favorite |
---|---|---|---|---|---|
dewiki_p | de.wikipedia.org | -2 | Medium | primary | 1 |
dewiki_p | de.wikipedia.org | -1 | Spezial | primary | 1 |
dewiki_p | de.wikipedia.org | -2 | Media | canonical | 0 |
dewiki_p | de.wikipedia.org | -1 | Special | canonical | 0 |
dewiki_p | de.wikipedia.org | 0 | primary | 1 | |
dewiki_p | de.wikipedia.org | 1 | Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 1 | Talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 2 | Benutzer | primary | 1 |
dewiki_p | de.wikipedia.org | 3 | Benutzer Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 2 | User | canonical | 0 |
dewiki_p | de.wikipedia.org | 3 | User talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 3 | BD | alias | 0 |
dewiki_p | de.wikipedia.org | 2 | Benutzerin | alias | 0 |
dewiki_p | de.wikipedia.org | 3 | Benutzerin Diskussion | alias | 0 |
dewiki_p | de.wikipedia.org | 4 | Wikipedia | primary | 1 |
dewiki_p | de.wikipedia.org | 5 | Wikipedia Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 4 | Project | canonical | 0 |
dewiki_p | de.wikipedia.org | 5 | Project talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 5 | WD | alias | 0 |
dewiki_p | de.wikipedia.org | 4 | WP | alias | 0 |
dewiki_p | de.wikipedia.org | 6 | Datei | primary | 1 |
dewiki_p | de.wikipedia.org | 7 | Datei Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 6 | File | canonical | 0 |
dewiki_p | de.wikipedia.org | 7 | File talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 6 | Bild | alias | 0 |
dewiki_p | de.wikipedia.org | 7 | Bild Diskussion | alias | 0 |
dewiki_p | de.wikipedia.org | 6 | Image | alias | 0 |
dewiki_p | de.wikipedia.org | 7 | Image talk | alias | 0 |
dewiki_p | de.wikipedia.org | 9 | MediaWiki Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 8 | MediaWiki | canonical | 1 |
dewiki_p | de.wikipedia.org | 9 | MediaWiki talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 10 | Vorlage | primary | 1 |
dewiki_p | de.wikipedia.org | 11 | Vorlage Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 10 | Template | canonical | 0 |
dewiki_p | de.wikipedia.org | 11 | Template talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 12 | Hilfe | primary | 1 |
dewiki_p | de.wikipedia.org | 13 | Hilfe Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 12 | Help | canonical | 0 |
dewiki_p | de.wikipedia.org | 13 | Help talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 12 | H | alias | 0 |
dewiki_p | de.wikipedia.org | 13 | HD | alias | 0 |
dewiki_p | de.wikipedia.org | 14 | Kategorie | primary | 1 |
dewiki_p | de.wikipedia.org | 15 | Kategorie Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 14 | Category | canonical | 0 |
dewiki_p | de.wikipedia.org | 15 | Category talk | canonical | 0 |
dewiki_p | de.wikipedia.org | 100 | Portal | canonical | 1 |
dewiki_p | de.wikipedia.org | 101 | Portal Diskussion | canonical | 1 |
dewiki_p | de.wikipedia.org | 100 | P | alias | 0 |
dewiki_p | de.wikipedia.org | 101 | PD | alias | 0 |
dewiki_p | de.wikipedia.org | 828 | Modul | primary | 1 |
dewiki_p | de.wikipedia.org | 829 | Modul Diskussion | primary | 1 |
dewiki_p | de.wikipedia.org | 828 | Module | canonical | 0 |
dewiki_p | de.wikipedia.org | 829 | Module talk | canonical | 0 |
@Marostegui It is needed in the middle of JOINs. Similar to the pagelinks table.
Nov 13 2017
An example from a recent created report:
- Table 1: Article titles with GROUP BY normalized titles HAVING COUNT(*) > 1
- Table 2: All links from disambiguation pages and set-index articles with redirects resolved, sorting and indexing by (target_page, dab_page)
- These tables are combined and outputted into the report
The initial version using a single query and was projected to be 12x slower (6-8 hours vs 30 minutes).
SELECT @@hostname, @@version, @@max_user_connections, @@max_connections, "Notes ";
hostname | version | max_user_connections | max_connections | Notes |
---|---|---|---|---|
labsdb1001 | 10.0.22-MariaDB | 0 | 1000 | Disk failure |
labsdb1003 | 10.0.22-MariaDB | 0 | 1000 | Labsdb |
labsdb1005 | 10.0.31-MariaDB | 0 | 1024 | tools.labsdb |
labsdb1009 | 10.1.28-MariaDB | 10 | 1024 | analytics |
labsdb1011 | 10.1.28-MariaDB | 10 | 1024 | web |
Toolserver had max_user_connections set to 15. Firefox until June 2017 had 8 connection pipelining, so two users could saturate all your database connections. The new standard HTTP/2 uses no fewer than 100 streams, so eleven users could saturate all connections on the database server if there was no DB user limit.
Nov 12 2017
Nov 6 2017
7 days. In 7 days the IP information will start disappearing.
Nov 4 2017
Nov 2 2017
@Keegan You've got less than a fortnight!
Oct 20 2017
Here are the changes I made to that script on my server:
... # mime types next if $extensions{$_}; $extensions{$_} = 1; if (substr($1, 0, 5) eq "text/" or $1 eq "application/javascript") { print "\".$_\" => \"$1; charset=utf-8\",\n"; } else { print "\".$_\" => \"$1\",\n"; } } ...
That still leaves out extensions .log, .conf, and README not listed in mime.types, but are covered by Bühler's script.
Oct 19 2017
Oct 13 2017
Oct 12 2017
Oct 6 2017
10 out of the 37 files deleted in the past 24 hours are still accessible (with the script I ran for @Keegan yesterday)
Oct 5 2017
Since this seems to be impossible. Would adding interstitial for Facebook referrers be doable? I imagine that we'd want to discourage people from thinking our content comes from Facebook.
Sep 26 2017
Sep 25 2017
These are all known WP0 abusers--The persistent type. They'll wait a week, make edits, whatever to get passed the filters.