Solution: OpenX Missing Statistic Reports

Yesterday, I was a little bit panic because I couldn’t found any statistic reports in an OpenX installation. I didn’t use the latest version (2.8.0). So, I did an upgrade to 2.8.5. But still, the statistics didn’t come back.
I finally found a solution at OpenX Community Forums. Here’s the trick:

  • Go to your database management tool. I’m using phpMyAdmin.
  • Run this simple query: update ox_application_variable set value = 1 where name ='admin_account_id';
  • Voila!

When I went back to the statistic page, I had all statistics available. Great.