View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015579||phpList 3 application||Statistics||public||03-02-11 18:59||29-04-11 18:45|
|Platform||Phplist 2.11||OS||Linux||OS Version||CentOS|
|Fixed in Version||2.11.6|
|Summary||0015579: mclicks.php always shows "no active campaigns", Caused by error in SQL|
|Description||Using 2.11.5, click tracking enabled, visiting mclicks.php with known messages that have been fully sent and thoroughly clicked.|
Page says "there are no active campaigns", no matter the user's access level (all, owner, admin).
Therefore, user thinks that links are not monitored.
Checked admin/mclicks.php, found a problem in main SQL SELECT at row 52:
where clicked and linktrack_ml.messageid = message.id %s and entered < date_sub(now(), interval 12 month) group by messageid order by entered desc limit 50',
****Issue: condition "entered < date_sub" causes always zero results.
****Solution: turned before to later
"entered > date_sub"
****Result: mclicks.php lists messages sent within last 12 months with at least 1 click. Titles can be clicked for drill-down.
****Why not in 2.10.12: in that version, the SELECT does not have the time condition.
|Steps To Reproduce||In 2.11.5, click tracking enabled, visit mclicks.php|
|Additional Information||Problem should be solved, hope the solution is fine.|
|Tags||No tags attached.|
||I believe mclicks.php has undergone some some changes in the last development version. Have you tried upgrading yo 2.11.6 ?|
We use Phplist in a production environment, migrated to 2.11.5 just recently, so we are not doing any more general updates in the near future (ok bugfixing).
||can't replicate that in 2.11.6|