Page MenuHomePhabricator

Error when trying to download reports of articles created and improved with Event Metrics
Closed, DuplicatePublicBUG REPORT

Description

Steps to replicate the issue (include links if applicable):

  • Settle the parameters to create a report with Event Metrics (only me as user, last 9 years as dates, different Wikipedias + commons + wikidata)

What happens?:
An error page appears:

The message:

500: Internal Server Error

The server said:

An exception occurred while executing 'SET STATEMENT max_statement_time = 900 FOR SELECT `metric`, `value` FROM ( ( SELECT 'creator' AS `metric`, actor_name AS `value` FROM eswiki_p.revision, eswiki_p.actor WHERE rev_page = ? AND rev_actor = actor_id LIMIT 1 ) UNION ( SELECT 'edits' AS `metric`, COUNT(*) AS `value` FROM eswiki_p.revision WHERE rev_page = ? AND rev_timestamp <= ? AND rev_actor IN (?) ) UNION ( SELECT 'bytes' AS `metric`, rev_len AS `value` FROM eswiki_p.revision WHERE rev_page = ? AND rev_timestamp <= ? AND rev_actor IN (?) ORDER BY rev_timestamp DESC LIMIT 1 ) UNION ( SELECT 'links' AS `metric`, COUNT(*) AS `value` FROM eswiki_p.pagelinks JOIN eswiki_p.page ON page_id = pl_from WHERE pl_from_namespace = 0 AND pl_namespace = 0 AND pl_title = ? AND page_is_redirect = 0 ) ) t1' with params [73798, 73798, "20240520025900", 15687, 73798, "20240520025900", 15687, "Acrididae"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pl_namespace' in 'where clause'

What should have happened instead?:
Allow the download of a CSV file

Software version (on Special:Version page; skip for WMF-hosted wikis like Wikipedia): no idea

Other information (browser name/version, screenshots, etc.):

Event Timeline

An error page appears:

Where?

create a report with Event Metrics

How? Where? What are *full* steps to reproduce?