View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0014253 | phpList 3 application | Statistics | public | 24-04-08 08:59 | 21-06-18 14:05 |
| Reporter | flohack | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | duplicate | ||
| Product Version | 2.10.5 | ||||
| Target Version | next major | Fixed in Version | |||
| 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. | ||||
| Tags | No tags attached. | ||||
|
|
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 = ''; |
