[Cloud] [Mediawiki-api-announce] Change to action=login response when login fails due to session loss

2020-04-08 Thread Brad Jorsch (Anomie)
26 [4]: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/586448 -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Mediawiki-api-announce mailing list mediawiki-api-annou...@lists.wikimedia.org https://lists.wik

[Cloud] [Mediawiki-api-announce] BREAKING CHANGE: Parameter validation error codes

2020-02-04 Thread Brad Jorsch (Anomie)
h or without error code changes), and for a few the error metadata may be changing (e.g. "botMax" changes to "highmax" for limit-type warnings in non-back-compat error formats). This change will most likely go out to Wikimedia wikis with 1.35.0-wmf.19. See https://www.medi

[Cloud] [Mediawiki-api-announce] BREAKING CHANGE: Stricter validation of integer-type parameters

2020-02-04 Thread Brad Jorsch (Anomie)
- "foobar", formerly interpreted as "0". Most clients should already be using correct formats, unless they are taking direct user input without validation. This change will most likely go out to Wikimedia wikis with 1.35.0-wmf.19. See https://www.mediawiki.org/wiki/

[Cloud] [Mediawiki-api-announce] BREAKING CHANGE: Format of blockexpiry timestamps from list=users and list=allusers

2019-09-18 Thread Brad Jorsch (Anomie)
nd list=allusers fully in line with that already used for meta=userinfo and 'blocked' errors from various actions. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Mediawiki-api-announce mailing list mediawik

[Cloud] [Mediawiki-api-announce] BREAKING CHANGE: Reporting of edit failures due to AbuseFilter and SpamBlacklist

2019-09-10 Thread Brad Jorsch (Anomie)
tps://phabricator.wikimedia.org/P8990 [3]: AbuseFilter: https://phabricator.wikimedia.org/P8989 [4]: SpamBlacklist: https://phabricator.wikimedia.org/P8991 [5]: ConfirmEdit: https://phabricator.wikimedia.org/P9076 -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation _

Re: [Cloud] SQL Query optimization

2019-08-19 Thread Brad Jorsch (Anomie)
e advantage of the index on (log_namespace, log_title, log_timestamp). If possible you might also change it to "order by log_title, log_timestamp" to make it even faster, although I suspect that won't fit with whatever you're trying to do. What was the original query before yo

[Cloud] [Mediawiki-api-announce] Change to handling of POSTs without Content-Type on Wikimedia wikis due to PHP 7 migration

2019-08-16 Thread Brad Jorsch (Anomie)
tps://tools.ietf.org/html/rfc7231#section-3.1.1.5 [2]: As seen for example at https://www.mediawiki.org/w/api.php. [3]: See https://phabricator.wikimedia.org/T176370 for progress on the migration. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation

Re: [Cloud] SQL Question

2019-08-14 Thread Brad Jorsch (Anomie)
> ( -> select -> (@row_number_2:=@row_number_2 + 1) as rownumber, -> ipb_address -> from ipblocks -> where ipb_by_actor = 1789 -- HujiBot -> order by ipb_range_start -> ) as lead -> on lead.rownumber = ipb.rownumber + 1; [..

Re: [Cloud] Toolforge SQL performance issue with new comment table

2019-06-03 Thread Brad Jorsch (Anomie)
cks" view could use a where clause specific to the > ipblocks entity table like "WHERE exists( select 1 from ipblocks where > ipb_reason_id = comment_id and ipb_deleted = 0)" and exclude the tests > for other entities (image, filearchive, revision, etc). > See also https

[Cloud] [Mediawiki-api-announce] BREAKING CHANGE: Action API action=logout will require a CSRF token

2019-04-25 Thread Brad Jorsch (Anomie)
org/T25227> [3]: https://phabricator.wikimedia.org/T25227#4902709 -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Mediawiki-api-announce mailing list mediawiki-api-annou...@lists.wikimedia.org https://lists.wikimedia.org/m

[Cloud] User/actor storage changes

2019-04-03 Thread Brad Jorsch (Anomie)
more information on the deployment process. Note that accesses to the actor table may be slow, as are accesses to the comment table. Improving that situation is being tracked at https://phabricator.wikimedia.org/T215445. -- Brad Jorsch (Ano

[Cloud] [Mediawiki-api-announce] DEPRECATION: Action API uncaught exception error codes

2018-11-27 Thread Brad Jorsch (Anomie)
"[61e9f71eedbe401f17d41dd2] Exception caught: Testing", "data": { "errorclass": "InvalidArgumentException" } } ], "trace": "InvalidArgumentException at ...&quo

Re: [Cloud] Comment/summary storage changes

2018-10-16 Thread Brad Jorsch (Anomie)
AM Brad Jorsch (Anomie) wrote: > As you may have been aware, we've been working on changing how MediaWiki > stores comments: instead of having them as fields in each revision > (rev_comment), log entry (log_comment), and so on, we're storing the text > in a central "comm

[Cloud] [Mediawiki-api-announce] Deprecation of the disabletidy parameter to action=parse

2018-09-25 Thread Brad Jorsch (Anomie)
[1]: https://phabricator.wikimedia.org/T198214 [2]: https://phabricator.wikimedia.org/tag/parsoid-php/ -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Mediawiki-api-announce mailing list mediawiki-api-annou...@lists.wikimedia.org https://lists.wikimedia.o

Re: [Cloud] Comment/summary storage changes

2018-09-17 Thread Brad Jorsch (Anomie)
On Mon, Sep 17, 2018 at 11:07 AM, Brad Jorsch (Anomie) < bjor...@wikimedia.org> wrote: > We've been writing to the new fields and tables since the end of February > 2018, and have back-populated them for old revisions, log entries, and so > on. > Correction, the back-popul

[Cloud] Comment/summary storage changes

2018-09-17 Thread Brad Jorsch (Anomie)
ields makes use of the CommentStore class that was introduced in MediaWiki 1.30. You can watch https://phabricator.wikimedia.org/T166733 (and any subtasks) for more information on the deployment process. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation __

[Cloud] [Mediawiki-api-announce] Deprecations and changes in API action=compare

2018-08-25 Thread Brad Jorsch (Anomie)
h as the rvdifftotext parameter to action=query&prop=revisions, will not be updated for MCR. Code using these parameters should be updated to use action=compare instead. [1]: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/448160 [2]: e.g. https://en.wikipedia.beta.wmflabs.org/w/api.php?modul

[Cloud] [Mediawiki-api-announce] BREAKING CHANGE: Some missing parameter error codes are changing

2018-07-25 Thread Brad Jorsch (Anomie)
lient is checking for specific missing parameter error codes, it may need to be updated for the changed codes. [1]: https://phabricator.wikimedia.org/T200155 -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Mediawiki-api-announce m

Re: [Cloud] Fwd: [Mediawiki-api-announce] BREAKING CHANGE: Passing too many values for a multi-valued parameter waring is becoming an error

2018-05-30 Thread Brad Jorsch (Anomie)
iawiki-api-announce is a low-volume announce-only list, while mediawiki-api is a discussion/help list (like this one) that also gets all the announcements. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Wikimedia Cloud Ser

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread Brad Jorsch (Anomie)
ly enough possibility to tell us not to count on it remaining available. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) htt

Re: [Cloud] Emulate cross-wiki joins

2018-01-18 Thread Brad Jorsch (Anomie)
k[1] one of our DBAs warned this list that that ability is not guaranteed or supported, and changing that is indeed a possibility. [1]: https://lists.wikimedia.org/pipermail/cloud/2018-January/000169.html -- Brad Jorsch (Anomie) Senior Software Engineer Wikim

Re: [Cloud] Help with a query

2017-12-31 Thread Brad Jorsch (Anomie)
On Sat, Dec 30, 2017 at 10:55 PM, Huji Lee wrote: > and log_id > 9406768; > As I said earlier, it was bad advice to use log_id rather than log_timestamp for this query. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia F

Re: [Cloud] Help with a query

2017-12-30 Thread Brad Jorsch (Anomie)
_action. It looks like logging_userindex is useful for queries that are targeting indexes user_time, log_user_type_time, log_user_text_type_time, and log_user_text_time. Any of the three views should work for the primary key and the type_time and times indexes. -- Brad Jorsch (Anomie) Senior Softw

Re: [Cloud] Help with a query

2017-12-30 Thread Brad Jorsch (Anomie)
*" in "count(*)" does not cause the database to fetch all fields. If anything, "count(*)" might be ever so slightly faster since it's literally staying "count the number of rows" rather than "count the number of rows where the constant 1 is not nul

Re: [Cloud] Help with a query

2017-12-30 Thread Brad Jorsch (Anomie)
do the subquery in batches to merge in your client code. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud

Re: [Cloud] Database queries via PHP

2017-10-10 Thread Brad Jorsch (Anomie)
bug in PHP (or HHVM, if that's what you're using). You should file it upstream with details on how exactly to reproduce it. -- Brad Jorsch (Anomie) Senior Software Engineer Wikimedia Foundation ___ Wikimedia Cloud Services mailing list