View Issue Details

IDProjectCategoryView StatusLast Update
0017056phpList 3 applicationStatisticspublic20-02-14 01:01
Reporterduncanc Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
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',

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



07-02-14 10:11

updater   ~0052891

Last edited: 07-02-14 10:11

View 2 revisions

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'


08-02-14 01:58

administrator   ~0052911

cool, nice find.


20-02-14 01:01

administrator   ~0053092