Backend breaks when searching.

MBG
MBG
Offline
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.

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

Accepted Answer

Tuesday, April 07 2015, 10:09 AM - #Permalink
0
ok, we fixed this issue. Please, re-download the component and re-install it on your website (it's the same version number)
The reply is currently minimized Show
Responses (1)
  • Accepted Answer

    Saturday, April 04 2015, 10:04 AM - #Permalink
    0
    sorry about this. we will build a new package to solve this on Tuesday.
    The reply is currently minimized Show
Your Reply