Page 1 of 1

Statisics bug?

Posted: Tue Mar 20, 2007 10:53 am
by markus
I created and send a newsletter via OpenEMM with some link lists (about 40 lnks; assigned to different target groups that represent topics). It seems that there is a problem with the click rate statistic. I enabled click rate tracking for all links. When I open the statistics of this mailing no link clicks are displayed. I get only the sum (total clicking subscribers). But the are no details about the links they clicked and the total number of clicks (remains 0).

The links in the newsletter mails are replaced with the correct redirect url and the redirection to the original link works without problems.

All links show up in the rdir_url_tbl. relevance for these links is 0. Where I find the click count for a link? Click counts are stored in rdir_log? The entries in this table look ok?

company_id, customer_id, mailing_id, ip_adr, change_date, url_id
1, 2797, 68, 192.168.1.231, 2007-03-16 12:51:13, 501

There are url_id, date and ip. The mailing id is ok. Maybe there is only a problem with the jsp frontend that generates the statistics pages.

A cross browser issue: If I open the statistics page in Firefox the bar of the clicking subscribers is way too long.

Code: Select all

<img src="images/emm/one_pixel.gif" border="0" height="10" width="0"><img src="images/emm/one_pixel_h.gif" border="0" height="10" width="167401">
Maybe the real width of the bar image is used?

Thanks for any hints!

Markus

We have to look into it

Posted: Tue Mar 27, 2007 11:09 am
by maschoff
Is it possible for you to mail us some screenshots with the wrong statistics to support AT openemm DOT org? Thanks!

Posted: Wed Mar 28, 2007 9:07 am
by markus
I've made a screenshot of the begin / end of the statistics page (viewed in Firefox and IE). As mentioned before no link clicks are displayed.
Firefox displays the bar graph image way too long.

Posted: Wed Apr 11, 2007 9:02 am
by markus
Any news concerning this bug?
Any hints how to make the stats working?
Should I check the db fields related to the stats?
Thanks in advance!

Bug

Posted: Thu Apr 19, 2007 11:14 am
by maschoff
In the meantime we confirmed the bug (will be posted in the SourceForge bugtracker soon) and we will work on a solution next week. Thanks for making us aware of this bug!

Re: Bug

Posted: Mon Apr 23, 2007 3:08 pm
by markus
ma wrote:In the meantime we confirmed the bug (will be posted in the SourceForge bugtracker soon) and we will work on a solution next week. Thanks for making us aware of this bug!
Just drop me a line if you need additional info.
It seems that this bug only affects the stats output (bar graph generation).
The entries on the db tables (rdir_log_tbl rdir, customer_1_tbl cust, rdir_url_tbl urladdr) look okay.
BTW is there a "public beta" of ver 5.0.3 of OpenEMM that should be tested?

Posted: Tue Jun 12, 2007 9:57 am
by markus
If read that this bug was fixed in 5.1
Statistics (Source: Internal)
- fixed bug in clicksTotal, length of blue bars is now displayed correctly
Currently I'm doing a insallation of 5.1. I'll try it.