0015579: mclicks.php always shows "no active campaigns", Caused by error in SQL

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

View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0015579

phplist application

Click Tracking

public

03-02-11 18:59

29-04-11 18:45

Reporter

solmar

Priority

normal

Severity

major

Reproducibility

always

Status

resolved

Resolution

fixed

Platform

Phplist 2.11

Linux

OS Version

CentOS

Product Version

2.11.5

Target Version

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:

******Original:
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.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0051161) 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 ?

(0051162) 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).

(0051223) michiel (manager) 29-04-11 18:45	can't replicate that in 2.11.6