Issue: Maintenance Not Running Or Statistics Not Summarizing Options

[Arlen Coupland]

Hello,

Below is a checklist of items to check or information to provide in a post if you are having issues with Maintenance or Statistics.

Summary of Issue ::
Some users find that Maintenance never reports itself as Complete. In some cases this will mean that their statistics are never summarized - in other cases statistics are fine however the users wonder why they are getting the 'maintenance has not run' message.

Recently, the 'maintenance has not run' message can be a cosmetic issue where the user has a cron job set and Automatic Maintenance enabled. It reports to them that the Scheduled Maintenance has not run - this could be true because the Auto-Maint ran first.

Who is affected ::
There are a few different scenarios happening. If you are having any issue with maintenance or statistics, it is important to go through this list. Your issue may sound similar to an issue someone else is having, but most likely it is different: it depends largely on your server setup.
Windows users with php 5 should definitely check php.ini for their date.timezone setting.
Any users with php 5.2.4 or above should check item #4 below. There is a known bug which will be fixed soon.

Technical details ::

The below is for OpenX 2.6. Versions 2.4 may have slightly different links.

Please let us know if any of these items help you, as it helps us know what exact issues users are having.

First, always let us know the exact issue (Maintenance has an error? No statistics are seen?) and your setup.

1) What version of PHP are you using? You can see using phpinfo() or by going to My Account -> Product Updates, as an administrator user.

2) If you are using PHP 5, if you look at phpinfo() or php.ini, what is the value for timezone? Please make sure this is a valid value and reset Apache

If you are using PHP 4, please go to your Openads Settings and check the value for timezone. Try setting it to a different city within the same timezone and save settings.

3) What message do you see when you go to My Account -> Maintenance ? If you are using a cron job, what exact cron command are you using? If you are using a cron job, try disabling Automatic Maintenance. This is recommended for best performance.

4) For 2.4 versions, not 2.6+, in your config file at openads/var/www.example.com.conf.php , what is the value for
[modules]
AdServer=1
Tracker=1

If it says 0 for AdServer and/or Tracker please set those to 1

5) For 2.4 versions, not 2.6+, in your settings page at Global Settings -> Statistics and Maintenance Settings, what is the value inside the text box below:
"Global Prevent Statistics Logging Settings"
If you have a list of IPs/domains with too many commas, you may need to edit your configuration file to remove the extra commas.


Please post such information in your own thread so that we can better help you resolve any issue you are having.

Important - when providing debug info please provide a readable maintenance.log and debug.log (only newer versions of 2.4 have a seperate maintenance.log file). This means the log files doesn't need to be for the last 2 weeks, nor for only the last 10 minutes.
1) go to Global Settings->Debug log settings and change the Debug Priority level to "PEAR_LOG_DEBUG" (most information). Press Submit even if this option is already chosen - default installs have no priority debug level set
2) Let maintenance run a few times (meaning: at least a couple hours) and then a good debug and maintenance log should exist for maintenance

You may wish to then reset your debug level to a lower value later, to avoid having too large of debug files.

[Arlen Coupland]

Update - I've modified the post to include information about a cosmetic issue where the 'maintenance has not run' message can appear incorrectly to certain users. Also I've added information about 'global prevent logging' settings.


If the log files report a PEAR debug message like 'table x_y_z is marked as crashed and should be repaired' or a message involving 'Can't find file tbl_name.MYI (Errcode: nnn)', then you need to repair whichever table is listed.
For help on this, please see:
http://forum.openx.org/index.php?showtopic=503419834


If you find that statistics suddenly started reporting many more impressions than normal, it may be that you need to repair the _log_maintenance_statistics table