alpha1 Posted January 24, 2014 Report Posted January 24, 2014 Hello, I too am having a problem with no stats since the upgrade. I am running a dedicated ubuntu apache VPS for Revive. My mysql user gas full privileges. My Plugins (All Enabled as well as all sub modules of them) IAB VAST Plugin 1.9.1 Invocation Tags Plugin 1.1.0 Banner Delivery Cache Store Plugin 1.1.0 Banner Delivery Logging Plugin 1.1.0 MaxMind GeoIP Plugin 1.1.0 Reports Plugin 1.4.1 3rd Party Servers Plugin 1.1.0 Delivery Limitations Plugin 1.1.0 Banner Types Plugin 1.1.0 A copy of the latest maintenance task to run Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Running Maintenance Priority Engine Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] LOAD DATA INFILE / COPY failed or not supported, falling back to INSERTing data by looping over each record... Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Inserted 11 rows in the table tmp_ad_required_impression Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting Zones forecasts for all managers for OI from 2014-01-24 18:00:00 to 2014-01-24 18:59:59 Jan 24 13:33:13 -0500 OX-maintenance-52e2b1e93bb0e [ info] LOAD DATA INFILE / COPY failed or not supported, falling back to INSERTing data by looping over each record... Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Inserted 324 rows in the table tmp_ad_zone_impression Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting Zones forecasts for all managers for OI from 2014-01-24 18:00:00 to 2014-01-24 18:59:59 Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Looping over each zone linked to 5 ads Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Finished querying impressions for 20 ad-zones combinations Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] LOAD DATA INFILE / COPY failed or not supported, falling back to INSERTing data by looping over each record... Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Inserted 53 rows in the table ox_data_summary_ad_zone_assoc Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting All Managers Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting active campaigns with priority = '9' for manager 1 Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting active campaigns with priority = '8' for manager 1 Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting active campaigns with priority = '7' for manager 1 Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting active campaigns with priority = '6' for manager 1 Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] - Selecting Managers with ECPM priority campaigns running Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Jan 24 13:33:14 -0500 OX-maintenance-52e2b1e93bb0e [ info] Maintenance Priority Engine Completed (Started at 2014-01-24 18:33:13 UTC) There is nothing in the apache log files for that vhost. The debug.log file above seems to indicate that there are stats being recorded. How can i verify stats are being recorded, what tables are used for the most recent stats? Why would this not show up then, only stats before the upgrade show up. Could it be the PHP version? I believe I am running PHP 5.5. Am i missing a plugin? Quote
Dave Brain Posted January 24, 2014 Report Posted January 24, 2014 Recent impression storing table : rv_data_bkt_m . Check this table first . Your debug log file look like having some problem. You have enable auto maintenance or else schedule maintenance? Quote
alpha1 Posted January 27, 2014 Author Report Posted January 27, 2014 Thanks. That table was actually missing. I had a table called ox_data_btk_county_m, which seemed to hold the same info, so i cloned that table and renamed it. I did the same thing to "ox_data_bkt_country_c" I'm thinking that was a plugin leftover from openX that didn't clean up after itself? I am also testing on a fresh install. No stats on either yet, but i'm hoping something will come soon... Quote
alpha1 Posted January 28, 2014 Author Report Posted January 28, 2014 Comparing a fresh install to, i found several tables missing or improperly named which solves some of this problem. ox_data_btk_a was missing ox_data_bkt_a_var was missing ox_data_bkt_c was named ox_data_btk_county_c ox_data_bkt_m was named ox_data_btk_county_m ox_data_btk_r was missing So the data was not being stored in any of them obviously. Now, ~20 hours after createing btk_c and a hour or so after creating the others, I do see data in them (over 1800 records), but still, statistics are not actually loading (and yes maintenance has run). On my fresh install, with no tweaks, no stats are available either. How can i force stats to be updated? Any way besides running maintenance? Quote
alpha1 Posted January 28, 2014 Author Report Posted January 28, 2014 Ok, after repairing those tables (Using PhpMyAdmin Operations tab to clone from a fresh install to the existing FUBAR'ed install, a few hours later stats started appearing. Don't forget if anyone else tries this, when you copy the tables, you have to ensure that the prefix is correct. Mine are prefixed as "ox_" because I upgraded from openx, but your may be "rv_" or something else. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.