Page MenuHomePhabricator

Event Metrics queries for Commons need to be updated following imagelinks normalization
Closed, ResolvedPublicBUG REPORT

Description

il_to was dropped from the imagelinks table in r1248863. Our queries should instead JOIN on linktarget with the new il_target_id column.

Impact: No reports targeting Wikimedia Commons can be generated using Event Metrics.

Example event: #5332 (must be the event coordinator or an admin to view)

Event Timeline

@Wikicology: Thanks for reporting this. For future reference, please use the bug report form (linked from the top of the task creation page) to create a bug report, and fill in all the sections in the template. Which exact error do you get?

Thank you @Aklapper. The error message is “Something went wrong, Try again or report this issue”. It just timed out and that error message received.

MusikAnimal changed the subtype of this task from "Task" to "Bug Report".

My previous comment (now deleted) was inaccurate. There's a legit issue here. Looks like we need to update some queries following the removal of the il_to field of the imagelinks table.

So the short of it is, I guess we can't support some Commons-specific metrics until this bug is fixed.

Hopefully this won't be too hard to fix, but it does take time. Thanks for your patience, and moreover for reporting this issue to us!

MusikAnimal renamed this task from BUG: Error generating stats to Event Metrics queries for Commons need to be updated following imagelinks normalization.Apr 16 2026, 7:21 AM
MusikAnimal updated the task description. (Show Details)
MusikAnimal updated the task description. (Show Details)

Thank you @MusikAnimal. It seems we still cannot generate data even if we exclude Commons.

Just a note this has not been forgotten about! Higher priorities are in the way right now but I hope to have this fixed by the end of the week.

Hi @MusicAnimal, do you think the tool will be operationnal tomorrow? I really need it for my reports :)

Just a note this has not been forgotten about! Higher priorities are in the way right now but I hope to have this fixed by the end of the week.

Could it be possible to know when the tool will be working next week ? @MusikAnimal

Sorry the delay. I have started on it and hope to have it finished before I head to the Hackathon next Wednesday. There's a bit of tech debt that needs to be sorted out too, which is what's making it so complicated. Thank you for your patience.

Natacha_LSP raised the priority of this task from Medium to High.Tue, Apr 28, 6:51 PM

Hi @MusikAnimal I have to hand in my annual report for les sans pagEs on thursday. I am getting really worried that I will not be able to calculate the retention rate. How are you doing on this task ? Sorry to put such pressure on you :/

Note changing the priority should normally be left to the developer or product manager https://www.mediawiki.org/wiki/Phabricator/Project_management#Setting_task_priorities But it's okay as I agree this is high priority :)

I am sorry for the long wait. I'm working on it now with the goal of getting something out today.

MusikAnimal changed the task status from Open to In Progress.Tue, Apr 28, 8:00 PM
MusikAnimal claimed this task.

Alright, I think all is resolved now! Apologies again for the delay. I was tied up with higher-priority issues that were effecting production wikis.

I have tried to go through and re-generate events that failed, but I wasn't able to get all of them. It's rather tedious to do manually. But things should no longer error out.

Going to resolve as I won't hassle QA into learning a new product, and all we're doing here really is making sure nothing errored out, which I was able to verify.

Than you so much @MusikAnimal. It’s working fine now.