Jump to content

JeffOYB

Approved members
  • Posts

    15
  • Joined

  • Last visited

Posts posted by JeffOYB

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

  2. Most likely reason I think for something breaking with the upgrade is incorrect permissions on the filesystem, or a corrupted database....?

     

    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!

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

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

  5. 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 
  6. 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?

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

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

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

×
×
  • Create New...