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.

Modifying WordPress custom database error connection page

Database connection has a big role when we build using a dynamic webpage. To be more spesific, if we’re using WordPress it’s always a good thing to have our database connection alive. But, for some technical situation, database connection might be dropped. Like or not, this is the situation we might have.
To deal with high-traffic website, there is a WordPress plugin (note: we’re talking about WordPress here) called WP Super Cache. This plugin will help your WordPress installation to deal with major traffic, to keep our site alive e.g. when our site got a massive traffic from site like Digg or Slashdot. When there is a failure on MySQL database connection, there will be a page presented informing about problem on establishing database connection. A page that we want to avoid. The worst thing is that when this ‘temporary’ page is indexed by search engines.