Hi,
I just upgraded from Sugar Pro 6.0.1 to 6.2.3 and my sugarcrm.log file is being spammed with failed queries such as the following:
Code:
SELECT count(*) c FROM accounts   LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c   LEFT JOIN  users jt0 ON
jt0.id= accounts.modified_user_id AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= accounts.created_by AND jt1.deleted=0
 AND jt1.deleted=0  LEFT JOIN  users jt2 ON
jt2.id= accounts.assigned_user_id AND jt2.deleted=0
 AND jt2.deleted=0  LEFT JOIN  team_sets ts1 ON
ts1.id= accounts.team_set_id AND ts1.deleted=0
 AND ts1.deleted=0  LEFT JOIN  teams tj ON
tj.id= accounts.team_id AND tj.deleted=0
 AND tj.deleted=0  LEFT JOIN  accounts jt5 ON
jt5.id= accounts.parent_id AND jt5.deleted=0
 AND jt5.deleted=0  LEFT JOIN  campaigns jt6 ON
jt6.id= accounts.campaign_id AND jt6.deleted=0
 AND jt6.deleted=0 LEFT JOIN contacts jt7 ON accounts_cstm.contact_id_c = jt7.id AND jt7.deleted=0   LEFT JOIN  users jt8 ON
jt8.id= accounts.modified_user_id AND jt8.deleted=0
 AND jt8.deleted=0 where (accounts.last_name LIKE 'Account Name Here%') AND accounts.deleted=0
The MySQL Error is: Unknown column 'accounts.last_name' in 'where clause'

I'm not sure why it's looking for an account.last_name field. Shouldn't that be a contacts field?

Thanks,
Joe