skylabz0rz Posted April 10, 2016 Report Share Posted April 10, 2016 Hello Revive Adserver Community, I am trying to figure out why my community edition of the revive adserver stopped logging the statistics for the banners. Here is what I have found out thus far. The Cron job is running without any errors being entered into /var/logs/cron. If I manually run the maintenance.php script, I get an output of #!/usr/bin/php -q (not sure what that means). Looking in the debug log, I found that the script for maintenance is running, but this line was odd: - Updating the data_summary_ad_hourly table for data after 2016-03-20 15:00:00 UTC. Ironically, that's the day the statistics stopped. I did check into the database and found I had to repair data_bkt_m and thus I did that via phpmyadmin. I am at a stumbling block as I can't seem to figure out why it wont' log any statistics. Any help is appreciated. Thanks. Quote Link to comment Share on other sites More sharing options...
skylabz0rz Posted April 12, 2016 Author Report Share Posted April 12, 2016 Just a quick update to this, as I am trying to figure an answer on my own. Per the documentation, I ran the mysql command SELECT * FROM rv_data_bkt_m; and it returned the data as it suggested in the documentation. The last interval start was for today's date. So that means the logging is working, I think. Then, I went to check on the maintenance script. The log, as per the documentation, indicated the script last ran on March the 20th. I had the setting checked to run the script. I verified the script was in the right directory, as it was. I tried to manually run the script by opening the maintenance.php file, however, it didn't load anything. I set the script to run via cron now, however I am not seeing any stats come in. I set the scrip to run per minute. Any insight? Quote Link to comment Share on other sites More sharing options...
skylabz0rz Posted April 21, 2016 Author Report Share Posted April 21, 2016 I just wanted to post an update to this as I have solved it. The problem was a correct database. I used phpmyadmin to check all of the Revive tables. Turns out the tables rv_data_bkt_r and rv_data_summary_ad_hourly were corrupt. I simply checked those tables and repaired them. All of the stats returned as they should, and it even corrected the missing data from the previous days. Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted April 21, 2016 Report Share Posted April 21, 2016 1 minute ago, skylabz0rz said: The problem was a correct database. I guess you mean corrupted... Quote Link to comment Share on other sites More sharing options...
skylabz0rz Posted April 21, 2016 Author Report Share Posted April 21, 2016 Ah yes, my apologies. Quote Link to comment Share on other sites More sharing options...
Matt Tews Posted November 22, 2017 Report Share Posted November 22, 2017 This was VERY helpful! My rv_data_intermediate_ad was similarly corrupt. A 'repair' and the maintenance script began working again. andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
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.