alpha1

I solved my problem with no stats. You can see more in this thread: forum.revive-adserver.com/topic/215-no-stats-since-upgrade/ but basically in the upgrade, several tables did not get copied/renamed/created correctly.

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.

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?

1) I upgraded from openX because openX was dated, lacked recent PHP support which created many errors in our log files, and many things have been updated in revive, such as support for limitations by browsers to include OSes since XP. 2) We ran straight advertisements, a leaderboard, 960x90, 4 sidebar ad blocks (300x250) and some 468x60 banners. We ran them on 3 sister sites (Wordpress network) and outbound enewsletters for reach site. We racked up over a million impressions within 8 months of use, sometimes up to 5 or 6K a day. I'm the web developer and assumed the role of ad manager too when we created this product, which we do run of site, and you pay per issue. So for say $500, you get a run in our enewsletter, and 2 weeks on the website. Ideally you'd be on the web for a week, we'd publish content, curate it, and generate an enewsletter with a custom plugin, and send the newsletter with ads. You'd see 5 ads in the enewsletter, and when you click any article in it, we take you to our site where you'd see the same ads.

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...

I've had issues with my upgrade, so im testing a fresh install. Same issue on the fresh install, i have stuff in 'data_bkt_m' but it never goes anyway. Even running maintenance manually doesn't do anything.

I do a very similar things. So far since upgrading to revive, i've had nothing but misery. I'm pretty sure revive's impression/click tracking is completely busted, but anyway... 1) Yes. 2) Yes 2a) Ok good. 2b) There is an old Wordpress Plugin, OpenX Widget, but it doesn't offer many options. If it doesn't do it for you, use the text widgets. Using widget area for ads is smart, it allow you to control the pages they show up in via jetpack widget visibility, and can be easily moved and changed.

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?

I open my stats and i see "There are currently no statistics available for the period 23-01-2014 to 23-01-2014" Every day since the update. I reinstalled all plugin yestarday and there should be several thousands hits since i upgraded. Where do i look to see if they're in the database at all but maybe not displayed? I upgraded the mysql user to full global privs, but it already had full database privs, except grant.

Probably related, i see this error in var/debug.log Jan 22 14:05:22 -0500 OX-52e0167224e38 [ info] Automatic Maintenance Task not run: could not acquire lock Jan 22 14:05:22 -0500 OX-52e0167228773 [ info] Automatic Maintenance Task not run: could not acquire lock Jan 22 14:05:22 -0500 OX-52e016722893e [ info] Automatic Maintenance Task not run: could not acquire lock Jan 22 14:05:22 -0500 OX-52e016722912b [ info] Automatic Maintenance Task not run: could not acquire lock

Where in the database can i find the stats exactly, im having a similar problem and would like to see if they're even being recorded.