Page MenuHomePhabricator

statisticsct2 table missing
Open, Needs TriagePublic

Description

Trying https://tools.wmflabs.org/heritage/api/api.php?action=statisticsct&format=json&ctscope=image&ctcountry=Portugal results in

{
    "errors": 
    [
        "SQL error 1146: Table 's51138__heritage_p.statisticsct2' doesn't exist\nLast query was: SELECT SUBSTR(img_timestamp,1,10) AS timeslot\n\t\t\t\t, img_wlm_country as country\n\t\t\t\t, COUNT(1) as n_images\n\t\t\tFROM statisticsct2\n\t\t\tWHERE img_wlm_country IN ( \"Portugal\" )\n\t\t\tGROUP BY img_wlm_country,SUBSTR(img_timestamp,1,10)\n\t\t\tORDER BY img_timestamp;\n\t\t\t"
    ]
}

Either some maintanance script isn't running (ContestStatsBuilder?) or we are no longer supporting the competition statistics feature (in which case action=statisticsct should be redirected to action=help and the section on this removed.

Event Timeline

So digging around, maintenance/INSTALL gives some clues:

_buildStats.php

CREATE TABLE statistics (

and

_fetchContestStats.php

CREATE TABLE statisticsct

I imagine the 2 was jsut for some test.

I still have this problem on that exact endpoint. Why it isn't solved yet?
Thank for you work