Unified Search not finding a contact

[dtokeefe]

Hi Julian,

This search runs for more than 60 seconds, then fails to a blank screen:

http://www.sugarcrm.com/crm/?option=...duct_category=

I was looking for bugs related to Unified Search in 4.5.0.h.

Unified Search does not find Contacts that absolutely exist. Example:

1. Use a clean install with demo data.

2. Type "Landrum" in the unified search box in the upper right of Sugar.

3. Result will be Robert Landrum among the Leads found, and no Contacts found.

However, Robert Landrum is a converted Lead and definitely has a Contact record.

Our client found this. We thought it was related to the upgrade from 3.5.1 to 4.5.0.h, but the problem is present even in our clean test system.

Cheers.

David

[andydreisch]

dtokeefe, I moved this post up to OS -> Help as a new thread to ensure it gets the visibility it deserves.

BTW, I ran a test o this on our demo system (450g) and could not repro it. I'll check a clean install 450h.

Andy

[andydreisch]

dtokeefe, we ran a thorough test with converted Leads, etc. We could not reproduce this.

Might it be that the customer is running Sugar Professional or Enterprise and the Contact is simply not visible to the user? If not, can you please provide any add'l info you think may help with this? Also, are you able to examine the database?

Andy

[dtokeefe]

Hi Andy,

So, I swear that I was able to reproduce this on a clean demo system last night, but today I can't. Also, I discovered that the demo data has Leads with status = converted which do not have a corresponding Contact.

In conclusion, false alarm. The problem definitely exists on our client's system, but it must be related to the upgrade from 3.5.1.c to 4.5.0.h.

I'll let you know if I find anything.

Thanks for looking into it.

David

[andydreisch]

Hi dtokeefe, well if there's a problem related to the upgrade we need to know that as well. Please enter a bug based on what you find.

Thanks,

Andy

[Scott_Savage]

I am having this exact problem with an upgraded 4.5.0h install. Not sure quite where the bug is yet, let me dive a little deeper...

[andydreisch]

Please do, Scott_Savage. I'll be watching this one.

Thanks for your help.

Andy

[Scott_Savage]

Found the cause! The custom listviewdefs.php file defines the Unified Search terms (in the case of contacts these are FIRST_NAME and LAST_NAME), whereas the standard one does not... apparently this prevents it from working. Filed under Bug ID 11171.

[Scott_Savage]

I have to correct myself, I think I have found the ACTUAL cause. It is definately causing the problem now, not sure if it was before or not. It is the same idea, but the listviewdefs.php file for the contacts module has the following lines:

 'ACCOUNT_NAME' => 
  array (
    'width' => '34%',
    'label' => 'LBL_LIST_ACCOUNT_NAME',
    'module' => 'Accounts',
    'id' => 'ACCOUNT_ID',
    'link' => true,
    'default' => true,
    'sortable' => true,
    'ACLTag' => 'ACCOUNT',
    'related_fields' => array ('account_id'),
  ), 
  

If the "default" value is set to false (as is generated in the custom file) then it will not find any contacts in the universal search. Very interesting.

[andydreisch]

Terrific work, Mr Savage!!

Andy