bug issue i think

[alienfactory]

whenever we sort by name in the lead list view i get this error

Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id where (leads.assigned_user_id in ('1034b68a-57cd-3a9e-98ef-4660a1fc13c3')) AND leads.deleted=0 ORDER BY name DESC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

anyone know about this or have suggetions

we have found that going to the edit button work but when you click on the users name it creates the error abouve

[Markku]

Try to select admin -> Repair -> repair database and see if it helps.

[alienfactory]

No that did not work

any other ideas

[Angel]

whenever we sort by name in the lead list view i get this error

Error retrieving Lead list: Query Failed:SELECT leads.*, users.user_name assigned_user_name FROM leads LEFT JOIN users ON leads.assigned_user_id=users.id where (leads.assigned_user_id in ('1034b68a-57cd-3a9e-98ef-4660a1fc13c3')) AND leads.deleted=0 ORDER BY name DESC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

anyone know about this or have suggetions

we have found that going to the edit button work but when you click on the users name it creates the error abouve

I am able to duplicate the issue. The attached lead.php file should fix it.

To apply the fix, backup your existing lead.php file from <sugar root>/modules/Leads/ and replace it with the attached version.

I've logged it as bug #13400

[alienfactory]

Awsome that did the trick thanks a bunch you are A Sugar Hero

Terry

[Markku]

Good find Angel!

I was able to duplicate the issue on my local environment (Sugar 4.5.1d) and public SugarCRM demo (http://www.sugarcrm.com/crm/demo/sugar-suite.html) as well.

[Angel]

Terry should get the credit for finding it.

I just figured out a fix for it.

Team work.

[pauldolphin]

I was having the same "issues" the patch appears to have fixed this problem. . .Thank you so much for your help.