Help, Email Checking Preventing Save

[jjwdesign]

See attached image. SugarCRM 5.2 CE

I've noticed recently that our Contacts, Leads and even Users can not be saved with email addresses - because the "check exsiting email" functionality is failing (or getting stuck / not processing). Has anyone experienced this problem?


I'm trying to go back and revist everything I've done/added/changed in the past week or two.

1. I've added some logic hooks.
2. I've also added some custom controllers.
3. Custom Studio views; imported.

Any ideas? Jeff

[jjwdesign]

I'd almost bet that this has something to do with the Javascript cache and/or the mini-fied JavaScript files. I recall Rebuilding the Javascript files thru the Admin repair. This may have created the javascript problem. Perhaps it introduced an old bug. Jeff

[jjwdesign]

I went thru the InnoDB MySQL database setup to make sure that was working properly. I also setup logging of slow queries (2sec). Nothing showed up so far. I also rebooted.

Copying the 'include' Directory?

I've now got two instances of SugarCRM on the same server. One has this existing email checking issue (hangs), and the other words just fine. I'm considering copying the entire 'include' directory from the working instance to the non-working instance. I'll make a backup first, of course. Is there anything anyone can advise to be careful of?

Thanks, Jeff

[jjwdesign]

Ok, well the coffee has kicked in. I'm posting this message so others will hopefully benefit from my experience. I tracked down the language ("Checking for existing email entry...") to a label "LBL_VERIFY_EMAIL_ADDRESS". This label is used in the Javascript in:

/include/SugarEmailAddress/SugarEmailAddress.js

Which uses an AJAX call to:

index.php?module=Contacts&action=RetrieveEmail ...

Trying to request this action results in a message of:

"There is no action by that name."

Removing my custom controller seems to fix the problem, resulting in a response:

{"target":null}

So, this brings me to my custom controller. I thought my custom controller would only extend the existing actions, but obviously I'm mistaken. I noticed that there's already a controller.php file. This is where the action and view is set for action_RetrieveEmail().

/modues/Contacts/controller.php

 class ContactsController extends SugarController
{
 function action_Popup(){
  if(!empty($_REQUEST['html']) && $_REQUEST['html'] == 'mail_merge'){
   $this->view = 'mailmergepopup';
  }else{
   $this->view = 'popup';
  }
 }
 
    function action_ValidPortalUsername()
    {
  $this->view = 'validportalusername';
    }
    function action_RetrieveEmail()
    {
        $this->view = 'retrieveemail'; 
    }
    function action_ContactAddressPopup()
    {
  $this->view = 'contactaddresspopup';
    }
 
    function action_CloseContactAddressPopup()
    {
     $this->view = 'closecontactaddresspopup';
    }    
} 
  

I fixed this problem by extending the existing module controller into my custom controller.

require_once('modules/Contacts/controller.php');

class CustomContactsController extends ContactsController {
...
}


Thanks, Jeff

[416]

Hi, Jeff

Your post was very helpful for me. I have had the same issue and it was solved very easy.

Thanks, Michael.

[williamconley]

Very helpful. I traced the problem to SugarEmailAddress.js.

This javascript function uses an ajax function to request data from index.php. The method of retrieval will cause only appropriate data reply, not an actual web page. I had altered index.php to show content below the SugarCRM page. This extra data was confusing the AJAX interpreter and it would then freeze and fail to complete.

asyncRequest('GET','index.php?&module=Contacts&act ion=RetrieveEmail&target='+target.id+'&email='+tar get.value,

So checking for "Retrieve" in the query string and disabling my extra code if it is present resolved the problem, but I'll be on the lookout for any other functions that have similar issues.

This thread lead me directly to the issue. Thanks!