I got the following error when trying to pull up a "Unique Clicks" report:

user warning: Unknown column 'clicks' in 'order clause' query: SELECT u.uid, u.name, u.status, u.created, u.access FROM users u INNER JOIN users_roles ur ON u.uid = ur.uid WHERE ur.rid IN (SELECT r.rid from role r INNER JOIN permission p ON r.rid = p.rid WHERE p.perm LIKE '%act as affiliate%') GROUP BY u.uid ORDER BY clicks ASC in /var/www/drupal/sites/all/modules/uc_affiliate2/uc_affiliate2.module on line 661.

I don't see that the module added a a clicks column to any of the tables referenced in the query. Nor do I see a clicks column in the uc_affiliate2_clicks table.

Comments

cjscullyca’s picture

Correction: When I said "pull up a "Unique Clicks" report" I meant sort by Unique Clicks.

bojanz’s picture

Status: Active » Closed (fixed)

Fixed in CVS (disabled sorting by clicks, users, orders, not possible for now)