SplendidCRM Software

Forum Home

Plug-in and Platform Forums

Outlook 2003 Plug-in

Error when Send...

Error when Sending to Sugar

smueller72

26 posts

Joined
6/20/2007

Error when Sending to Sugar
Posted: 11 Sep 07 3:59 PM

I'm using SugarCRM 4.5.1b and Outlook 2003 along with the latest Outlook plugin. Everything seems ok except when I try to search for a record - contact in this case - I get the error below. Ideas?

---------------------------
SplendidCRM Plug-in for Outlook - Error
---------------------------
Void btnSearch_Click(System.Object, System.EventArgs) Line 126.

Client found response content type of 'text/html', but expected 'text/xml'.

The request failed with the error message:

--

Error running count query for Contact List: Query Failed:SELECT count(*) c FROM contacts RIGHT JOIN autharised_user ON autharised_user.record_id=contacts.id where (contacts.last_name like 'steve@test.com%' or contacts.first_name like 'steve@test.com%' or accounts.name like 'steve@test.com%' or contacts.assistant like 'steve@test.com%' or contacts.email1 like 'steve@test.com%' or contacts.email2 like 'steve@test.com%') AND contacts.deleted=0 and autharised_user.office_id in () and autharised_user.module_name='Contacts' and autharised_user.deleted='0' ::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and autharised_user.module_name='Contacts' and autharised_user

--.
---------------------------
OK
---------------------------

support

2240 posts

Joined
1/3/2006

Re: Error when Sending to Sugar
Posted: 11 Sep 07 5:00 PM

This is clearly a bug in SugarCRM. A web service should never generate errors and return them as Text. At the very least, it should catch them and return them as a XML SOAP error.

However, the real problem is that the SQL code within SugarCRM is not being generated properly. Please work with them to resolve the issue. And, while you are at it, have them correct the spelling of Authorized.

Page 1 of 1

Plug-in and Platform Forums

Outlook 2003 Plug-in

Error when Send...