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 |
| Reporter | solmar | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | Phplist 2.11 | OS | Linux | OS Version | CentOS |
| Product Version | 2.11.5 | ||||
| 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. | ||||
|
|
I believe mclicks.php has undergone some some changes in the last development version. Have you tried upgrading yo 2.11.6 ? |
|
|
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). |
|
|
can't replicate that in 2.11.6 |
