Page MenuHomePhabricator

NicholasG04 (Nicholas)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
Dec 8 2019, 7:30 PM (146 w, 3 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
NicholasG04 [ Global Accounts ]

Recent Activity

Jan 12 2020

NicholasG04 added a comment to T241513: Add a filter by country and language to the map.

I'm getting through this task quite nicely but just have a couple of concerns:
Firstly, for adding in the tooltips that use Flask-JSONLocale, is it ok that I cannot translate them into all of the languages?
Secondly, I'm having some issues with getting the data by selecting multiple options in a <select multiple> that I'd like to discuss on IRC please, and how I can then translate this into SQL. Thanks!

Jan 12 2020, 12:27 PM · Patch-For-Review, Google-Code-in-2019, Map-of-monuments

Jan 8 2020

NicholasG04 claimed T241513: Add a filter by country and language to the map.
Jan 8 2020, 7:19 AM · Patch-For-Review, Google-Code-in-2019, Map-of-monuments

Dec 22 2019

NicholasG04 added a comment to T213557: Allow user to fill trackerprofile info during registration.

For future reference, I've decided to do the following:

Dec 22 2019, 2:51 PM · Google-Code-in-2019, WMCZ-Tracker

Dec 20 2019

NicholasG04 added a comment to T213557: Allow user to fill trackerprofile info during registration.

Excited to be working with you again, Mr Urbanec on my first Tracker task! In terms of my approach to this, I have come up with two options:

  • Redirect everyone to /my/details after registering and add 'PLEASE COMPLETE' in red text next to bank account so that it stands out therefore compelling them to fill it in.
  • Redirect everyone to a new page which says 'Please fill in the following details: (copy of parts of /my/details)' + a skip button.
Dec 20 2019, 7:20 PM · Google-Code-in-2019, WMCZ-Tracker
NicholasG04 claimed T213557: Allow user to fill trackerprofile info during registration.
Dec 20 2019, 7:16 PM · Google-Code-in-2019, WMCZ-Tracker

Dec 19 2019

NicholasG04 added a comment to T240845: Temporary lift of IP cap on en.wikipedia for 21 Jan 2020.

It says on the dashboard page that it's only on Wikipedia UK so I'll push my changes to Gerrit as described above! Thanks, Mr Urbanec.

Dec 19 2019, 10:31 PM · Google-Code-in-2019, Wikimedia-Site-requests
NicholasG04 added a comment to T240845: Temporary lift of IP cap on en.wikipedia for 21 Jan 2020.

Just want to check, if I may, whether I should be allowing a grace period before/after the event and also in the value of users? Right now I've extended the exception for one hour either side of the event and also set a value of 25 because 'expecting roughly 15 people', in my mind, may rise up to such number. Is this ok or should I change these settings? Thanks!

Dec 19 2019, 6:41 PM · Google-Code-in-2019, Wikimedia-Site-requests
NicholasG04 added a comment to T240845: Temporary lift of IP cap on en.wikipedia for 21 Jan 2020.

Hiya, I'll be working on this task hopefully as part of Google Code-in 2019!

Dec 19 2019, 6:31 PM · Google-Code-in-2019, Wikimedia-Site-requests
NicholasG04 claimed T240845: Temporary lift of IP cap on en.wikipedia for 21 Jan 2020.
Dec 19 2019, 6:30 PM · Google-Code-in-2019, Wikimedia-Site-requests

Dec 11 2019

NicholasG04 added a comment to T240119: /users throws a fatal error.

No, thank you Mr Urbanec!

Dec 11 2019, 9:49 PM · Google-Code-in-2019, Commons-Mass-Description

Dec 10 2019

NicholasG04 added a comment to T240119: /users throws a fatal error.

https://gerrit.wikimedia.org/r/#/c/labs/tools/commons-mass-description/+/556243

Dec 10 2019, 8:11 PM · Google-Code-in-2019, Commons-Mass-Description
NicholasG04 added a comment to T240119: /users throws a fatal error.

Brilliant! Thank you so much for your assistance sir throughout this task. I'll push for review now.

Dec 10 2019, 7:51 PM · Google-Code-in-2019, Commons-Mass-Description

Dec 9 2019

NicholasG04 added a comment to T240119: /users throws a fatal error.

Hi, thanks for your very helpful advice! It has allowed me to fix my SQL such that it is now working fine on Quarry.
One last thing, before I push for review: When trying to run the flask app to see if it is working, it is erroring that it cannot connect to 'commonswiki.web.db.svc.eqiad.wmflabs' when using toolforget.connect('commonswiki') or commonswiki_p.

Dec 9 2019, 4:38 PM · Google-Code-in-2019, Commons-Mass-Description

Dec 8 2019

NicholasG04 added a comment to T240119: /users throws a fatal error.

Now my queries aren't completing - probably because I'm joining too many (rather large I suppose) tables together. Is there a better way of submitting such a query which now requires so many tables? Thanks!

Dec 8 2019, 10:14 PM · Google-Code-in-2019, Commons-Mass-Description
NicholasG04 added a comment to T240119: /users throws a fatal error.

Ahhh, how stupid of me! I should've realised! Thanks very much.

Dec 8 2019, 10:07 PM · Google-Code-in-2019, Commons-Mass-Description
NicholasG04 added a comment to T240119: /users throws a fatal error.

Similarly, I have fixed the second SQL query as part of this task:

SELECT count(*) FROM change_tag join change_tag_def join revision join actor_revision on ct_rev_id=rev_id where ctd_name="OAuth CID: 821" AND actor_id>0

Quarry

Dec 8 2019, 9:52 PM · Google-Code-in-2019, Commons-Mass-Description
NicholasG04 added a comment to T240119: /users throws a fatal error.

Good Evening,
I've created the following SQL query to replace what was not previously working.

SELECT actor_name, count(*) from change_tag join actor_revision join revision join change_tag_def on ct_rev_id=rev_id where ctd_name="OAuth CID: 821" and actor_user>0 group by actor_user order by count(*) desc
Dec 8 2019, 9:42 PM · Google-Code-in-2019, Commons-Mass-Description
NicholasG04 claimed T240119: /users throws a fatal error.
Dec 8 2019, 9:10 PM · Google-Code-in-2019, Commons-Mass-Description