Enhanced Search Plugin Problem w/deleted records

[gyromind]

After I installed Enhanced Search 2.0 on SugarCRM Version 5.0.0c (Build 3187) I was no longer able to search for cases marked with the deleted flag. I have about 50 cases that are deleted and nothing is showing up when the deleted field is checked and there are no other field values in the other search forms.

I checked the log to see what the SQL query was like and it seemed to show a contradiction when it came to the deleted field. I'm assuming that it's some coding that needs to be changed somewhere in SearchForm2.php, unfortunately I'm not skilled enough in php to know what to change or add.

Here is the query information with a search string of "FFXX", check out the cases.deleted stuff near the end:

SELECT cases.id , cases.case_number , cases.name , accounts.name account_name , accounts.assigned_user_id account_name_owner , 'Accounts' account_name_mod, cases.account_id , cases.priority , cases.status , cases.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, cases.assigned_user_id FROM cases LEFT JOIN accounts accounts ON
accounts.id= cases.account_id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN users jt1 ON
jt1.id= cases.assigned_user_id AND jt1.deleted=0
AND jt1.deleted=0 where ((cases.description like '%FFXX%' ) AND ( cases.deleted like '%1%')) AND cases.deleted=0 ORDER BY cases.case_number ASC LIMIT 0,21

[kenshiro]

I've found out that It's not an Enhanced Search bug, but a SugarCE 5.0.0c one.
You can verify it by yourself by uninstalling Enahnced Search and searching again, or by re-installing SugarCRM 5.0.0c.
I've started this thread where I've posted the bug fix.

[gyromind]

Thank you for your help with this. Sorry I didn't realize it was an existing issue. Worked great.

[gguillote]

Thank you for your help with this. Sorry I didn't realize it was an existing issue. Worked great.

Hello!
I’ve installed Enhanced-Search 2.1.2 in my SugarCrm CE 5.0.0e (Standard) and when I click in Accounts/Contacts Module SugarCrm shows me the following errors:

Notice: Undefined index: id_basic in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 323
Notice: Undefined index: name_basic in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 323
Notice: Undefined index: date_entered_basic in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 323
Notice: Undefined index: date_modified_basic in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 323
…………..
Notice: Undefined index: sync_contact_upperbound in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 333
Notice: Undefined index: sync_contact_OR in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 333
Notice: Undefined index: sync_contact_NOT in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 333
Notice: Undefined index: sync_contact_OPER in C:\Archivos de programa\Apache Group\Apache2\htdocs\SugarCrm\include\SearchForm\S earchForm2.php on line 333

Do you know the causes of these errors? Did I forget anything to config previously?

Thank you very much for your feedback.
Regards.
Guillermo

[kenshiro]

Hi,
it's a known bug due to the E_NOTICE php flag set to on.

I'm fixing it in the next Enhanced Search release.
In the meantime you can try to switch it to off if you can.

Thank you for your feedback.