Statisics bug?

[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

[maschoff]

Is it possible for you to mail us some screenshots with the wrong statistics to support AT openemm DOT org? Thanks!

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

[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!

[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!

[markus]

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?

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