Jump to content

Turbo212

Approved members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

 Content Type 

Posts posted by Turbo212

  1. Statistics Will Not Show No Matter What, Help Sought

    in Managing Revive Adserver

    Posted

    23 hours ago, andrewatfornax said:

    https://documentation.revive-adserver.com/display/DOCS/Revive+Adserver+Broken

    https://documentation.revive-adserver.com/display/DOCS/No+Statistics

    ?

    In addition to the above, @Turbo212, I notice that your oxcd_data_bkt_m table is MyISAM. 

    This table type only supports table level locking.

    If you're under high load, it's possible that the table will be locked by delivery processes queued up to write their data when the hourly maintenance process wants to lock the table to make updates. Are you sure that's not happening? Your MySQL logs might give you more information on this.

    I did notice that and thought it was odd, which is what led me to my next step. Did not think it was able to be salvaged, and since the install was only a week old, no harm no foul. I did a fresh install on a spare server I had, confirmed it was working well and logging stats, then moved it over to my live server and gave Revive its own subdomain. Now all is working great!

  2. Statistics Will Not Show No Matter What, Help Sought

    in Managing Revive Adserver

    Posted · Edited by Turbo212

    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

    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!

     

  3. Same ads repeating in single page call

    in Using Revive Adserver

    Posted

    Found an old topic on this from a year ago but there were no replies. Figured maybe someone knows a fix. When using single page call all of the ads in a zone are showing the same ad. I have the two options checked not to repeat ads or campaigns, but it doesn't seem to do anything. I have copied the invocation code 8 times in the zone to show 8 ad spaces and they're all the same ad. If I reload it does the same thing but with a different ad.

    If I use javascript it works fine but I don't want to overload my server.

    Anyone know what causes this or how to fix?

×
×
  • Create New...