phplist

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
0017056phplist applicationStatisticspublic07-02-14 10:0120-02-14 01:01
Reporterduncanc 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version3.0.5 
Target Version3.0.6Fixed in Version3.0.6 
Summary0017056: Clicks column on user history is always 0
DescriptionOn the History of a Subscriber page, page=userhistory&id=xxx , the Clicks column on the Campaigns tab is always 0. This is because the code is looking at the old click tracking table, see file admin/commonlib/pages/userhistory.php line 82:

      $clicksreq = Sql_Fetch_Row_Query(sprintf('select sum(clicked) as numclicks from %s where userid = %s and messageid = %s',
        $GLOBALS['tables']['linktrack'],$user['id'],$msg['messageid']));

The code should be using the linktrack_uml_click table instead.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0052891)
duncanc (developer)
07-02-14 10:11
edited on: 07-02-14 10:11

The column names in the new table are the same, so the change is simply to use the table 'linktrack_uml_click' in the query instead of 'linktrack'

(0052911)
michiel (manager)
08-02-14 01:58

cool, nice find.
(0053092)
michiel (manager)
20-02-14 01:01

https://github.com/michield/phplist/pull/12 [^]


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker