History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: OX-5668
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Chris Nutting
Reporter: Joanna Mazgaj
Votes: 1
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
OpenX Ad Server

ox_data_bkt_r table counts request for one zone & creative out of three on the page

Created: 05/Aug/09 10:57 AM   Updated: 11/Jan/10 07:29 PM
Component/s: OXP: Delivery Engine
Affects Version/s: OpenX 2.8.2
Fix Version/s: OpenX 2.8.4
Security Level: Public (All users can see these issues)

Time Tracking:
Not Specified

File Attachments: None
Image Attachments:

1. allure_media_rl_example.jpg
(24 kb)

2. Statistics.png
(9 kb)

3. Statistics1.png
(12 kb)
Issue Links:
Duplicate
 


 Description  « Hide
I have a website with 3 zones [different sizes], each of them linked to one banner from remnant campaign. Banners are invoked via SPC.
Now the ox_data_bkt_r table has request statistics only for one of those banners and zones. With every refresh the count number goes up by three:
mysql> select * from ox_data_bkt_r;
+---------------------+-------------+---------+-------+
| interval_start      | creative_id | zone_id | count |
+---------------------+-------------+---------+-------+
| 2009-08-05 10:00:00 |          19 |      18 |    57 | 
+---------------------+-------------+---------+-------+
1 row in set (0.00 sec)

For comparison ox_data_bkt_m table counts data for all three banners and zones:

mysql> select * from ox_data_bkt_m;
+---------------------+-------------+---------+-------+
| interval_start      | creative_id | zone_id | count |
+---------------------+-------------+---------+-------+
| 2009-08-05 10:00:00 |          18 |      20 |    19 | 
| 2009-08-05 10:00:00 |          17 |      19 |    19 | 
| 2009-08-05 10:00:00 |          19 |      18 |    19 | 
+---------------------+-------------+---------+-------+
3 rows in set (0.00 sec)

Looks like the problem is with the way SPC tag requests for banners, but I'm not sure.



 All   Comments   Work Log   Change History   FishEye   Crucible   Builds      Sort Order: Ascending order - Click to sort in descending order
Joanna Mazgaj - 05/Aug/09 11:04 AM
Update: after the maintenance it's clear that the statistics are not correct and the requests number for all banners/zones was being counted for one banner/zone only

Kaan Kivilcim - 07/Sep/09 05:49 AM
I've attached another real life example of where this occurs. We're in the process of switching from SPC back to normal JS tags in order to have accurate statistics.

Chris Nutting - 15/Dec/09 09:27 PM
Fixed in 2.8.3-rc9

Added unset($GLOBALS['_MAX']['deliveryData']) to the iteration of zones in SPC requests


Joanna Mazgaj - 11/Jan/10 07:29 PM
Works in 2.8.4-rc12. Closing.