Add Invitees search does nothing.

[mgravindran]

Hi,
in meeting & calls, search in Add Invitees does nothing. while using firebug, there is a request to Jsonserver.php. the response shows a sql query error below.

Error running count query for Contact List: Query Failed: SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= contacts.modified_user_id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON
jt1.id= contacts.created_by AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON
jt2.id= contacts.assigned_user_id AND jt2.deleted=0
AND jt2.deleted=0 LEFT JOIN contacts jt5 ON
jt5.reports_to_id= contacts.id AND jt5.deleted=0
AND jt5.deleted=0 LEFT JOIN campaigns jt6 ON
jt6.id= contacts.campaign_id AND jt6.deleted=0
AND jt6.deleted=0 LEFT JOIN accounts jt9 ON contacts_cstm. = jt9.id AND jt9.deleted=0 LEFT JOIN contacts jt10 ON contacts_cstm.contact_id_c = jt10.id AND jt10.deleted=0 LEFT JOIN users jt11 ON
jt11.id= contacts.modified_user_id AND jt11.deleted=0
AND jt11.deleted=0 where ( contacts.id in ( SELECT er.bean_id AS id FROM email_addr_bean_rel er, email_addresses ea WHERE ea.id = er.email_address_id AND ea.deleted = 0 AND er.deleted = 0 AND er.bean_module = 'Contacts' AND email_address_caps IN ('RAVI') )) AND contacts.deleted=0::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= jt9.id AND jt9.deleted=0 LEFT JOIN contacts jt10 ON contacts_cstm.contact_id_' at line 11

i have no clue why the generated query has 'contacts_cstm.' (ends with dot. without a filed name).


Any help would be appreciated.


version: SugarCE-5.5.2

[mgravindran]

After hours of struggle. i got it solved.

Cause of the problem:

i had a related field in contact which relates to accounts.

since i am not using this field, i have manually removed the field 'account_id' from db table.

Solution:

remove the relate field defintion for vardef or add account_id field in the db table


Thas it. hope this may help somebody else