0014253: clicktracking totals: sent msgs is calculated wrong (especially for RSS msgs)

Create

Capture

Maintain

Audience

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0014253

[phplist] Click Tracking

minor

always

24-04-08 07:59

24-04-08 13:09

Reporter

flohack

View Status

public

Assigned To

Priority

normal

Resolution

open

Status

new

Product Version

2.10.5

Summary

0014253: clicktracking totals: sent msgs is calculated wrong (especially for RSS msgs)

Description

mviews.php: the SQL (which was already changed in bug #6531) is still not correct, it should include a where/having-condition to only select the msgs which were actually sent. If status is being counted, it has to select "where um.status='sent'", or else the stats will be horribly wrong for msgs with 2 or 3 RSS frequencies.

Additional Information

Tags

No tags attached.

Attached Files

Relationships

related to

0011267

new

CLicktrack totals are incorrect

Notes
(0045691) flohack (reporter) 24-04-08 08:23	this also affects statsoverview.php ... by the way, statsoverview and mviews are basically the same file, I suggest merging them to stats.php with different function blocks for voerview and details... also code which does nothing should be assessed: $timerange = ' and date_add(msg.entered,interval 6 month) > now()'; $timerange = '';