NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1

View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015579phplist applicationStatisticspublic03-02-11 18:5929-04-11 18:45
PlatformPhplist 2.11OSLinuxOS VersionCentOS
Product Version2.11.5 
Target VersionFixed in Version2.11.6 
Summary0015579: mclicks.php always shows "no active campaigns", Caused by error in SQL
DescriptionUsing 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 = %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 ReproduceIn 2.11.5, click tracking enabled, visit mclicks.php
Additional InformationProblem should be solved, hope the solution is fine.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
h2b2 (manager)
03-02-11 23:26

I believe mclicks.php has undergone some some changes in the last development version. Have you tried upgrading yo 2.11.6 ?
solmar (reporter)
04-02-11 08:58

Not yet.
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).
michiel (manager)
29-04-11 18:45

can't replicate that in 2.11.6

Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker