JeffOYB

ps: FYI, I got an offlist contact last week from an India company that wanted $200 to check that function. Seems like a lot...

Thanks! Will do right now!

Hi... My Statistics stopped updating after we upgraded my server from OpenX to Revive. I asked about how to fix it in the thread about this but haven't had any luck. Can someone help? I can pay. One of the official helpers thinks it might be just a matter of permissions. I'm a novice coder and don't remember enough about permissions but perhaps it's an easy fix. Here's the link to the discussion in the other thread. (I'm the last poor person in the thread to be suffering from this.) http://forum.revive-adserver.com/topic/90-no-stats-from-when-i-upgraded-to-revive-adserver/page-2#entry2197 THANKS! JP ps: I can be contacted directly at jeff a t outyourbackdoor d o t com

Any chance I could hire you to look into it? Boy, that would really help, I bet! I'm having a hard time finding a coder who will help. Just wasted 2 weeks with someone who kept putting me off. Or is there someone you can recommend? THANKS!

Thanks for your efforts. I can still try to fix this on my own if it might be easy and straightforward. Otherwise, I'm looking into getting help from a coder. But all leads appreciated that I give to him if I can't do it. So... it was logging stats in the old version. When we upgraded the version it's possible that we might also have to increase the logging level, etc.? My main clue is that it happened exactly with the upgrade. So fixing it involves something we might've overlooked when doing the upgrade... Maybe? Thanks again for any ideas.

I checked plugins and I see openXDeliveryLog is enabled.

Sorry to be a bother, but any feedback appreciated. (In light of me needing stepwise info.) Thanks so much for the help!

I went to phpMyAdmin and I found that table. It looks like when I clicked on it that it automatically did a "SELECT * FROM data_bkt_m" -- I see that phrase at the top. It's showing interval_start, creative_id, zone_id, and count. It's sorted by date -- and it ends on the day that my new version was installed. There were only 38 rows, from 2011 to the day of the upgrade. (5 rows from 2011, a dozen or so from 2012, and then a couple dozen from 2014. None from 2013. ?) What does that table mean?

Thanks for helping on this! I appreciate it. OK, I'll look. About banners delivering... if I look at my website and refresh the views the banners appear and change with each refresh. Does that tell us anything? About the RV.php file -- should I change it back to what it was?

Apologies for repeating myself, but I'm not a coder. So how do I "restart MySQL"? Also, I do like some explanation or verification. Is there maybe a link that explains it? It seems odd that installing a new vs of OpenX would "turn off" MySQL. I sure wouldn't want to mess something up. Thanks for any help or confidence. JP

Here is what is in my var/debug.php log. It's neat stuff! I wish I knew what it meant. OK, for the weeks after my new install I got a lot of the same entries, which I've copied at the start. Then today I changed that line in RV.php about PEAR at about 8am. You can see where the entries suddenly change. I don't know what it means. Sorry for copying in so much, but maybe it'll give someone a sense of what is happening and what I need to do to get my Stats working again. THANKS! -- JP Apr 28 07:26:05 -0600 OX-535e56ed78d52 [ info] Running Automatic Maintenance Task Apr 28 07:28:30 -0600 OX-535e577e337a4 [ info] Running Automatic Maintenance Task Apr 28 07:29:56 -0600 OX-535e57d48b5f5 [ info] Running Automatic Maintenance Task Apr 28 07:29:56 -0600 OX-535e57d4adc9c [ info] Running Automatic Maintenance Task Apr 28 07:29:56 -0600 OX-535e57d4a9c85 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:29:57 -0600 OX-535e57d4cbfe2 [ info] Running Automatic Maintenance Task Apr 28 07:29:57 -0600 OX-535e57d5268ce [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:29:57 -0600 OX-535e57d50962f [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:30:32 -0600 OX-535e57f837b1f [ info] Running Automatic Maintenance Task Apr 28 07:35:53 -0600 OX-535e5939c2d51 [ info] Running Automatic Maintenance Task Apr 28 07:41:25 -0600 OX-535e5a8550a49 [ info] Running Automatic Maintenance Task Apr 28 07:43:02 -0600 OX-535e5ae63f1c1 [ info] Running Automatic Maintenance Task Apr 28 07:43:44 -0600 OX-535e5b10e1ac3 [ info] Running Automatic Maintenance Task Apr 28 07:44:01 -0600 OX-535e5b212f392 [ info] Running Automatic Maintenance Task Apr 28 07:52:12 -0600 OX-535e5d0ca0472 [ info] Running Automatic Maintenance Task Apr 28 07:52:12 -0600 OX-535e5d0cb5d7b [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:12 -0600 OX-535e5d0ca72f7 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:12 -0600 OX-535e5d0cb4067 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:12 -0600 OX-535e5d0cb01f1 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Running Maintenance Engine Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Running Maintenance Statistics Engine Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - Maintenance statistics will be run Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - The intermediate table statistics will be updated Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - The final table statistics will be updated Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - Managing (activating/deactivating) campaigns Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Maintenance Statistics Engine Completed (Started at 2014-04-28 13:52:13 UTC) Apr 28 07:52:13 -0600 OX-535e5d0ca0472 [ info] Running Midnight Maintenance Tasks Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Begin pruning old records from data_summary_ad_zone_assoc Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Finished pruning old records from data_summary_ad_zone_assoc: 0 records deleted Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Begin pruning records for expired inactive campaigns from data_summary_ad_zone_assoc Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Finished pruning expired inactive campaigns from data_summary_ad_zone_assoc: 0 records deleted Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Begin pruning records for completed inactive campaigns from data_summary_ad_zone_assoc Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Table ox_data_summary_ad_zone_assoc overhead (number of allocated but unused bytes) = 0 Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Delaying Revive Adserver sync process by 13 seconds. Apr 28 07:52:27 -0600 OX-535e5d0ca0472 [ info] Sync: updates found! Apr 28 07:52:27 -0600 OX-535e5d0ca0472 [ info] Finished Revive Adserver Sync process. Apr 28 07:52:27 -0600 OX-535e5d0ca0472 [ info] Midnight Maintenance Tasks Completed Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Running Maintenance Priority Engine Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 13:00:00 to 2014-04-28 13:59:59 Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] Inserted 74 rows in the table tmp_ad_zone_impression Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 13:00:00 to 2014-04-28 13:59:59 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting All Managers Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '9' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '8' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '7' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '6' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting Managers with ECPM priority campaigns running Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Maintenance Priority Engine Completed (Started at 2014-04-28 13:52:13 UTC) Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Maintenance Engine Completed (Started at 2014-04-28 13:52:13 UTC, taking 00:00:20) Apr 28 07:52:33 -0600 OX-535e5d0ca0472 [ info] Automatic Maintenance Task Completed Apr 28 08:06:22 -0600 OX-535e605ece1d1 [ info] Running Automatic Maintenance Task Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Running Maintenance Engine Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Running Maintenance Statistics Engine Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Maintenance statistics will be run Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - The intermediate table statistics will be updated Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - The final table statistics will be updated Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Managing (activating/deactivating) campaigns Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Maintenance Statistics Engine Completed (Started at 2014-04-28 14:06:23 UTC) Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Running Maintenance Priority Engine Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 14:00:00 to 2014-04-28 14:59:59 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Inserted 74 rows in the table tmp_ad_zone_impression Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 14:00:00 to 2014-04-28 14:59:59 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting All Managers Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '9' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '8' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '7' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '6' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting Managers with ECPM priority campaigns running Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Maintenance Priority Engine Completed (Started at 2014-04-28 14:06:23 UTC) Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Maintenance Engine Completed (Started at 2014-04-28 14:06:23 UTC, taking 00:00:00) Apr 28 08:06:23 -0600 OX-535e605ece1d1 [ info] Automatic Maintenance Task Completed Apr 28 09:08:21 -0600 OX-535e6ee4d4e89 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 09:08:21 -0600 OX-535e6ee4d55dd [ info] Running Automatic Maintenance Task Apr 28 09:08:21 -0600 OX-535e6ee50c7b0 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 09:08:21 -0600 OX-535e6ee4d9fb4 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 09:08:21 -0600 OX-535e6ee526778 [ info] Automatic Maintenance Task not run: could not acquire lock Apr

Hi! I had my OpenX upgraded to Revive a few weeks ago. I just checked my Stats and there is nothing but that notice. I am not a coder and I have low skills but I can check files for this'n'that. I already tried changing the RV.php file in relation to that bit about PEAR. It's been a couple hours, no effect. I checked my Maintenance settings and it says it's correctly set up. I'm not so hot with logs but I can try to take a look. I'm much worse with databases. But, again, I could go thru the motions to look for things. I've never fooled around with permissions, but, again, I've seen those settings from time to time, tho I couldn't tell you right now where they are. Any tips for easiest, simplest ways that a beginner could use to remedy this situation?

Not to put too fine a point on it, but it just came to me. The reason why I was surprised that I needed a plugin to handle billing and payments is because THAT'S THE WHOLE POINT OF ADVERTISING! Maybe I'm missing these features and they're already in Revive somewhere?

Hi... I just upgraded from OpenX to Revive. I'll use it to handle my website advertising. I was surprised that I needed a plugin to handle billing and payments since THAT'S THE WHOLE POINT OF ADVERTISING! Am I overlooking some feature that's already in Revive? I'm trying to install RevMax now since that's a plugin to do those tasks. I'm having a hard time, getting errors, it won't install, but I'm trying to get help. Anyone have luck with RevMax? Anyone use something else? Thanks! JP

Hi... I'm trying to get up to speed in using Revive for my advertisers on my website. I used to use OpenX. I have a couple dozen accounts but I haven't yet got everything going well enough to bill people yet. Which brings me to my request. Why would software like this NOT having billing and payment features? My clients and I want to track billing and then have their account set up so that they can pay each month for their clicks and impressions. Who would want an adserver that didn't have those features? Right now it seems like only the RevMax plugin will do this. I'm having trouble installing it right now.