View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0016796||phpList 3 application||Interface - Administrator||public||29-05-13 15:35||03-06-13 19:09|
|Target Version||2.11.11||Fixed in Version||2.11.11|
|Summary||0016796: Review statistics exactness|
|Description||Splitting out the statistics issue from 0016788|
Issue is, statistics include "not sent" entries, and are therefore incorrect
|Tags||No tags attached.|
|related to||0016788||new||phpList 3 plugins||Not able to send a message to subscribers who previously were excluded|
|related to||0006499||resolved||michiel||phpList 3 application||subtract bounces to calculate percentages|
|has duplicate||0014253||resolved||michiel||phpList 3 application||clicktracking totals: sent msgs is calculated wrong (especially for RSS msgs)|
(made you developer, so I can assign things to you :-)
Can you specify the Statistics being wrong? The statistics overview page does an SQL Query that includes
um.status = "sent"
which afaict should ensure that "not sent" entries are excluded from the calculations.
The View Opens page, http://strontian/lists2.11.9/admin/?page=mviews, includes the 'not sent' rows from the usermessage table.
The sql has a count(status) to get the number of messages sent to the user.
The Find Subscribers page, http://strontian/lists2.11.9/admin/?page=users, includes 'not sent' in the total of messages sent to each user.
The sql has a count(*) to get the number of messages sent to the user.
There might be others, but I haven't looked closely as it seems to be a retrograde step to introduce the new value of 'not sent' for the status column. Up until now a row in usermessage means that the message was sent to the user.
great, thanks, I'll look into it.
I think it's preferable to use the status column, as I intend to use the table for more stuff, eg, there is already the PREPARE_QUEUE, which marks them as "todo", so that the sending can be done by multiple processes.
||have added 'and status = "sent"' to all relevant queries|