0
Hey guys, we encountered one more error when setting up the Content Statistics and selecting Filter by viewing user.
Here is the error
Here is the error
1054 Unknown column 'st.user_id' in 'where clause' SQL=
SELECT SUM(at.comission) AS howmuch, at.date_created AS date_event
FROM x_affiliate_tracker_conversions AS at LEFT JOIN x_affiliate_tracker_accounts AS acc ON acc.id = at.atid
WHERE 1 = 1 AND at.date_created
BETWEEN SUBDATE(CURDATE(), 30) AND NOW() AND st.user_id = X AND acc.user_id = X AND at.approved = 1
GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event)
ORDER BY date_event
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »