[RESOLVED] SQL Syntax Error on Activity Log

[jetdino]

There error on Activity Log

 

SQL Error: Unknown column 'balance' in 'order clause' - Full Query: SELECT tblaffiliatesaccounts.id,tblaffiliatesaccounts.lastpaid,tblaffiliatesaccounts.relid, concat(tblclients.firstname,' ',tblclients.lastname) as clientname,tblproducts.name,tblhosting.userid,tblhosting.domainstatus,tblhosting.domain,tblhosting.amount,tblhosting.firstpaymentamount,tblhosting.regdate,tblhosting.billingcycle FROM tblaffiliatesaccounts INNER JOIN tblhosting ON tblhosting.id=tblaffiliatesaccounts.relid INNER JOIN tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblclients ON tblclients.id=tblhosting.userid WHERE tblaffiliatesaccounts.affiliateid='020' ORDER BY `balance` DESC LIMIT 0,50

[Matt]

This has been confirmed as happening when the affiliates list is sorted by balance, and then an individual affiliates profile is entered into and it tries to sort the referred signups list by the balance field. A workaround for this right now is to click any column heading in the referred signups list should it occur, and that will allow the referred signups to be displayed correctly.

 

Matt