Hello Folks,
Well, I am officially stumped. I followed all of the instructions posted on the Revive website, edited the RV.php file as suggested by some others, set the proper permissions to all maintenance scripts and folder (even went so far as to chmod 777 just to see if I could work backwards) and absolutely nothing works to generate my statistics. I went into phpMyAdmin and checked the database tables, and they all have the correct data placed in them. I also set up a cronjob to access the maintenance script and despite a successful access, no statistics can be seen in the UI. All other functionality of Revive works perfect. I am running v4.1.4 on Apache 2.4.33, PHP 7.0.30 and MySQL 5.5.60-0ubuntu0.14.04.1-log.
MySQL tables:
http://shorebeat.com/ads/mysql.png
The only issue I found is in my debug log, which outputs the following:
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Running Maintenance Engine
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Running Maintenance Statistics Engine
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Maintenance statistics will NOT be run
It then goes on to output the following for the remainder of the maintenance:
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Maintenance Statistics Engine Completed (Started at 2018-08-01 17:15:31 UTC)
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Running Maintenance Priority Engine
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting Zones forecasts for all managers for OI from 2018-08-01 17:00:00 to 2018-08-01 17:59:59
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting Zones forecasts for all managers for OI from 2018-08-01 17:00:00 to 2018-08-01 17:59:59
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting All Managers
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '9' for manager 1
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '8' for manager 1
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '7' for manager 1
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting active campaigns with priority = '6' for manager 1
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] - Selecting Managers with ECPM priority campaigns running
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Maintenance Priority Engine Completed (Started at 2018-08-01 17:15:31 UTC)
Aug 01 17:15:31 +0000 OX-maintenance-5b61eab3b7c67 [ info] Maintenance Engine Completed (Started at 2018-08-01 17:15:31 UTC, taking 00:00:00)
I am begging for help from anyone who might have a solution. Been trying every option under the sun for a week and simply cannot get the stats to load. Thanks!