SugarCRM 4.5.1e Lead list problem

[Zeonz]

Hi guys, i have problem on the lead list as i selected a lead and error come out as :

Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name , leads_cstm.* FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c where leads.deleted=0 ORDER BY name DESC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'


which mean i cannot go into the lead details... Please help me out with this.


thank you!

[kuske]

The correct statement should be:

SELECT leads.id , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.email1 , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where leads.deleted=0 ORDER BY name

Here you can see that the CONCAT function is missing in your statement.

Did you change the listview layout and did you remove the lead name from it?
Then an old order by can produce this error. Just click on status heading to sort for status.

Or is there no entry

'db_type' => 'mysql',

in your config.php?

[Zeonz]

Thank Kuske for reply on my problem.

in config.php already point to mysql

I try a fresh installation also give the same problem after i click on the column name for sorting and click on lead that i created.

i would not like to upgrade the version as my project is using this version and i hope can solve the problem on this verison.



Thank you

[kuske]

Can you post your config.php or better your diagnostic zip file here?
That could help a lot.

[Zeonz]

Hi Kuske you can get the diagnostic file at this URL

http://download.yousendit.com/E1C144967BF91D90


Thank you

[Zeonz]

Anyone can help on this issue?