Page MenuHomePhabricator

statisticsct2 table missing
Open, Needs TriagePublic


Trying results in

        "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:


CREATE TABLE statistics (



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