Sugar5 SoapTest.php Error with Mysql 5

[abrahamelias]

When running the SoapTest.php in the examples dir of sugar 5 using mysql 5 I get the following error:

Update a portal user fields:
HERE IS ERRORS:
Response not of type text/xml

HERE IS RESPONSE:
HTTP/1.1 200 OK Date: Wed, 02 Jan 2008 04:34:58 GMT Server: Apache/2.2.4 (Ubuntu) DAV/2 SVN/1.4.4 PHP/5.2.3-1ubuntu6 mod_ssl/2.2.4 OpenSSL/0.9.8e X-Powered-By: PHP/5.2.3-1ubuntu6 Set-Cookie: PHPSESSID=df77896324b4fc280a296ad958ae8c9c; path=/ Expires: Thu, 19 Nov 1981 08:52:00 GMT Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Pragma: no-cache Content-Length: 238 Connection: close Content-Type: text/html Retrieving record WHERE deleted = '0' AND email1 = 'Dan_Aarons@example.com' AND deleted=0: Query Failed:SELECT contacts.* FROM contacts WHERE deleted = '0' AND email1 = 'Dan_Aarons@example.com' AND deleted=0 LIMIT 0,1::MySQL error 1054:


email1 is not a column in the contacts table. Suggested work around?

[genimo]

I'm getting similar error from Web Service call to query contacts by email1 (or email2). Is there way to find contact using email from SOAP?

Thanks!

[andopes]

Hi, all.

email1 and email2 are not columns of Person modules anymore.
SugarCRM 5.0 works in different way to emails.
There is another module just to manage email addresses and there are relationships between this one and all Person modules.

Cheers

[genimo]

André, thanks for the reply!

Any idea where can I find information about that module? And specifically how it can be used to query contacts by email using Sugar Web Service API?

[jaenglish]

I've also been searching for an easy way to do this. I can't seem to find one, but there is something of a workaround using other functions. Where I used to call the API as follows:

$result=$this->soap->get_entry list(
     $session,                              // session id
     'Contacts',                            // module name
     " contacts.email1='".$email."',        // query
     ' contacts.last_name',                 // order by
     0,                                     // offset 
     array(),                               // array of fields to be retrieved 
     1,                                     // max number of entries to retrieve
     false                                  // whether to show deleted entries
);

Clearly this will no longer work, since 'email1' is no longer a field in the contacts database. The way around this is to use the contact_by_email function in the api to grab the id for the contact:

$contact = $this->soap->contact_by_email(SUGAR_USER, SUGAR_PASS, $email);

Then we can use this id to retrieve the rest of the contact information:

$result=$this->soap->get_entry list(
     $session,                              // session id
     'Contacts',                            // module name
     " contacts.id='".$contact[0]['id']."', // query
     ' contacts.last_name',                 // order by
     0,                                     // offset 
     array(),                               // array of fields to be retrieved 
     1,                                     // max number of entries to retrieve
     false                                  // whether to show deleted entries
);

This seems to be pretty foolproof since the user ID's are unique values, and looking up a contact by his or her ID is the most certain way to find that contact. The only thing this does NOT check for is more than one contact with the same email, but if that happens, you have duplicate record problems anyway.

Hope this helps. It's the only workaround I know for the time being, and I'm by no means an expert with SOAP or Sugar.


-jae