7.2 Global Search fails

šŸ“¦ Install & Upgrade Help
1

Hi,

In my Global Search Settings, Iā€™ve disable AOD as it never returns anything when searching. But thatā€™s another topic - Iā€™d love to find references about what it SHOULD find and how to configure it.

Using classic Sugar Global seach, it worked in 7.1.x like in SugarCRM, but now Global Search wonā€™t find anything in 7.2 and throws an SQL error in sugarcrm.log:

[i]Wed Mar 4 16:04:59 2015 [5655][e0c73158-1a04-7c79-cfce-51cc3a3e4eb6][FATAL] Query Failed: SELECT contacts.id , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,ā€™ā€™),ā€™ ā€˜,IFNULL(contacts.last_name,ā€™ā€™)))) as name, contacts.first_name , contacts.last_name , contacts.salutation , accounts.name account_name, jtl0.account_id account_id, contacts.department , contacts.primary_address_street , contacts.primary_address_postalcode , contacts.primary_address_city , contacts.primary_address_country , contacts.phone_work , contacts.date_modified , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ā€˜Usersā€™ modified_by_name_mod, contacts.assigned_user_id FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN accounts_contacts jtl0 ON contacts.id=jtl0.contact_id AND jtl0.deleted=0

LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN users jt1 ON contacts.modified_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where (((contacts.first_name like ā€˜ganten%ā€™ ) OR ( contacts.last_name like ā€˜ganten%ā€™ ) OR ( ( contacts.phone_mobile like ā€˜ganten%ā€™ OR contacts.phone_work like ā€˜ganten%ā€™ OR contacts.phone_other like ā€˜ganten%ā€™ OR contacts.phone_fax like ā€˜ganten%ā€™ OR contacts.assistant_phone like ā€˜ganten%ā€™ ) ) OR ( contacts.assistant like ā€˜ganten%ā€™ ) OR ( email IN (select bean_id from (SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE ā€˜ganten%ā€™) email_derived) ) OR ( accounts.name like ā€˜ganten%ā€™ ) OR ( ( contacts.first_name like ā€˜ganten%ā€™ OR contacts.last_name like ā€˜ganten%ā€™ )))) AND contacts.deleted=0 ORDER BY contacts.date_entered DESC LIMIT 0,11: MySQL error 1054: Unknown column ā€˜emailā€™ in ā€˜IN/ALL/ANY subqueryā€™[/i]

Any idea what may cause this?
Iā€™ve only upgraded a test site and will wait until this is resolvedā€¦
Happy to help if I can!

Cheers,
Ralf.

2

I have the same exact issue? Is this a big of 7.2 because it worked before that.

3

I also hit by this bug. I answered to this thread:
https://suitecrm.com/forum/suitecrm-7-0-discussion/3824-global-search-box-in-suite-7-2#15582

4

It seems the non-AOD Global Search is fixed in the 7.2.1 update.

5

I can acknowledge that.

Upgrade from 7.2 to 7.2.1 fixed the Standard-Search, I have no longer MySQL exceptions in my sugarcrm log.

The Lucene Index Schedular Task however does never finish, and therefore the advanced search only partial works (gives results in some cases). Iā€™m glad that the ā€œ100% CPU Load then lucene index tasks runsā€ bug seems to be solved (have no such problems since 7.1 to 7.2 upgrade). Would be great if a lucene search would work correctly.

6

to me it doesnā€™t work (7.2.1)

7

Works for me.

Did you do a quick repair?

8

I always have done a quick repair and rebuild relations after upgrade steps.

@cerelli: please do a quick repair as svdkar proposed

9

Yes, i do quick repair, but the problem persist
My log after global search:
Thu Mar 12 08:10:46 2015 [8874][1][FATAL] Exception in Controller: Index doesnā€™t exists in the specified directory.