Hi,

I am new to SugarCRM. I am using version 5.02h. I have a problem in the Activities module. When i sort using the column "Contacts" it is getting sorted, when i click on the "next" button, i am getting an error "Invalid Column name 'isnull'". While debugging i found out that in the LimitQuery while getting the orderby column, i am getting the return value as null. Below is the query

01/19/10 11:42:04 [5056][SUPPORT][FATAL] Invalid column name 'isnull'.: SELECT TOP 11 * FROM
(
SELECT ROW_NUMBER()
OVER (ORDER BY isnull asc) AS row_number,
calls.id ,calls_cstm.aconfirm_c,calls_cstm.activcode_c,call s_cstm.alarmdate_c,calls_cstm.alarmflag_c,calls_cs tm.alarmtime_c,calls_cstm.apptuser_c,calls_cstm.co mpany_c,calls_cstm.dircode_c,calls_cstm.hist_durat ion_c,calls_cstm.number1_c,calls_cstm.number2_c,ca lls_cstm.rectype_c,calls_cstm.resultcode_c,calls_c stm.rsvp_c,calls_cstm.srectype_c,calls_cstm.status _c,calls_cstm.units_c, calls.status , calls.date_start , ISNULL(contacts.first_name,'') + ' ' + ISNULL(contacts.last_name,'') contact_name, jtl0.contact_id contact_id, calls.name , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.assigned_user_id FROM calls LEFT JOIN calls_cstm ON calls.id = calls_cstm.id_c LEFT JOIN calls_contacts jtl0 ON calls.id=jtl0.call_id AND jtl0.deleted=0
LEFT JOIN contacts contacts ON contacts.id=jtl0.contact_id AND contacts.deleted=0
AND contacts.deleted=0 LEFT JOIN users jt1 ON
jt1.id= calls.assigned_user_id AND jt1.deleted=0
AND jt1.deleted=0 where ( calls.assigned_user_id ='SUPPORT') AND calls.deleted=0
) AS a
WHERE row_number > 10

The highlighted is where i am getting the error. Can someone please help me out?
Sugar Version : 5.20h
Apache server
Windows OS
SQL Server 2005.


Thanks,
Arunseeth.