Error Retrieving lead list

[cyberitpros]

Hello,

I am getting the following error when selecting a lead from my lead module ...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 ASC LIMIT 19,1::MySQL error 1054: Unknown column 'name' in 'order clause'... Any suggestions? Any help would be greatly appreciated.

[SamuelAugy]

There is no column called "name" in leads table.
How do you try to retrieve.

Look your listviewdefs.php files (in modules/leads/metadata and custom/modules/Leads/metadata) . You must have :

 'NAME' => array(
        'width' => '30',
        'label' => 'LBL_LIST_NAME',
        'link' => true,
        'default' => true,
        'related_fields' => array('first_name', 'last_name', 'salutation')), 
  

or

 'LAST_NAME' => 
  array (
    'width' => 30,
    'label' => 'LBL_LAST_NAME',
    'link' => true,
    'default' => true,
  ), 
  

[cyberitpros]

SamuelAugy,

This is what I have on my listviewdefs.php...

'ASSIGNED_USER_NAME' => array(
'width' => '10',
'label' => 'LBL_LIST_ASSIGNED_USER',
'default' => true),
'MODIFIED_USER_NAME' => array(
'width' => '10',
'label' => 'LBL_MODIFIED')

What would i need to change?

Thanks,

Carlos

[globalimage]

Have the same problem, once i click on specific lead

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.deleted=0 ORDER BY name ASC LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

please help

[HolmesA]

What version of Sugar do you use?
Did you perform any manual changes to Leads module? Or maybe using the Studio.

[globalimage]

Version 4.5.1h (Build 1104)

I have importing leads form CSV. There were some peroblems, and Sugar was not able to complete the opration. It stoped at the screen; Import Step 3: Confirm Fields and Import Import Started. No progesss no action.

[philipmartinjones]

Hi,

I searched the net for this exact same error message and have read that it relates to a known bug in the Leads module.

The bug is documented here: http://www.sugarcrm.com/crm/?option=...4-465a7fa84963

However the fix they provide isn't exactly easy to follow, so here is how I got it working for me:

1. Find the file: modules/Leads/metadata/listviewdefs.php (in our case this was in the public_html directory)
2. Make a backup copy (just in case)
3. Open the file in your preferred editor (eg. notepad)
4. Fairly near to the top you'll find the text:

'NAME' => array(
'width' => '30',
'label' => 'LBL_LIST_NAME',

5. Insert the missing definition so it now looks like:

'NAME' => array(
'orderBy' => 'last_name',
'width' => '30',
'label' => 'LBL_LIST_NAME',

6. I found that to make it work I needed to wait a few moments, log out of sugar, close the browser and go back in again. Then it all worked fine again.

Hope this helps.

Plus, credit where it's due: Here's the site where I found discussion of the issue (amongst other things) http://www.stonemind.net/blog/2007/1...-and-sugarcrm/

[globalimage]

It worked Thank you