Kisai Posted November 24, 2016 Report Share Posted November 24, 2016 Hello everyone. I updated two 3.2.4 installations to 4.0 on the 20th. Guess what is not working on both? On the older machine, all the stats have stopped dead, this one originally started out as OpenX Source 2.8 . Doing select * from ox_data_bkt_m; Results in data... from 2013. Clicking on the statistics in the Revive UI results in no statistics whatsoever since the upgrade. On the newer machine SELECT * FROM data_bkt_m; Has data from today. However it's data is very very wrong, like 99% of the statistics are missing. Some campaigns that normally have 2 million impressions on remnant have zero or just 10,000, while other campaigns that normally have 100,000 or so also have like 12,000, which there is no way the little site would have more impressions than the large site. I know the ads are still being delivered because the ad partners show the correct values for requests handed off to them. The debug log on both servers show that stats are running, both are running on crontab. Both servers had php updated to PHP 5.6.28 with Zend OPcache at the same time. So this makes me question: 1) Is there not a reference table schema that I can use to check if the database tables are correct? 2) what would make one server produce no stats, while the second server produce only a few? This suggests that some migration element failed. What changed between 3.2.4 and 4.0 that would do this? Quote Link to comment Share on other sites More sharing options...
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.