MySQL error 1054: unknown accounts_leads.id column

[yizzung]

Trying to run a report on leads in the database. We track whether or not someone wants to download a trial version of our software, so that's my criteria here. The report runs fine so long as I don't care to include "Account Name" in the output. When I add "Account Name" to the display columns, I get the following error:

Error executing query Query Failed:SELECT accounts_leads.id primaryid ,accounts_leads.account_name accounts_leads_account_name ,leads.first_name leads_first_name ,leads.last_name leads_last_name ,leads.lead_source leads_lead_source FROM leads LEFT JOIN leads_cstm leads_cstm ON leads.id = leads_cstm.id_c WHERE (((leads_cstm.interest_in_trial_c LIKE 'on' OR leads_cstm.interest_in_trial_c='1') )) AND leads.deleted=0 LIMIT 0,100::MySQL error 1054: Unknown column 'accounts_leads.id' in 'field list'

Seems odd that the interface will allow me to select a column while building a report but then can't find the column when running the query...

We're using Sugar Enterprise: Version 5.1.0b (Build 4905).

Thanks in advance.

[sugarcrmster]

I can Fix Your Mysql Error in Report

You can mail me sugarcrm.master@gmail.com

Or sugarcrmster@gmail.com

You have to change small code that i will provide you

Thanks

Regards

Sugarcrm Developer