0
When I search for something in the Backend for Affiliate Tracker -> Conversions I get this message:
Because of it and probably the getUserStateFromRequest I can not reset the search and access that page.
Because of it and probably the getUserStateFromRequest I can not reset the search and access that page.
Unknown column 'at.ip' in 'where clause' SQL=
SELECT at.*, u.name as username, acc.user_id AS owner_id, acc.account_name, u2.name as account_owner, acc.user_id as account_user_id
FROM
kpqlr_affiliate_tracker_conversions as at
LEFT JOIN
kpqlr_affiliate_tracker_accounts as acc ON acc.id = at.atid LEFT JOIN kpqlr_users as u ON u.id = at.user_id
LEFT JOIN
kpqlr_users as u2 ON u2.id = acc.user_id
WHERE ( at.name
LIKE "%test %" OR at.extended_name
LIKE "%test %" OR u.username LIKE "%test %" OR u.name
LIKE "%test %" OR u.email LIKE "%test %" OR acc.account_name
LIKE "%test %" OR at.ip LIKE "%test %" ) AND acc.user_id = "779"
ORDER BY
at.id DESC
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 »