Official SuiteCRM Outlook Plugin

if it saying a 500 error then your PHP logs on your server would pick it up. Are you abel to check your PHP logs where your SuiteCRM is situated. I suspect it is a DB error or something else.

-Thanks

Hi, I checked the PHP logs and I only see this very recurring warning:

_mod_fcgid: stderr: PHP Warning: Redis::connect(): connect() failed: Connection refused in /var/www/vhosts/incontacts.it/httpdocs/amcrm/include/SugarCache/SugarCacheRedis.php on line 105

Don't know if it has anything to do with it. Anyway, I think it should not happen.

Thank you

Hi there,

Could you please ensure that you have upgraded to the newest version of the plug-in and if this issues continues if possible could you please send your Outlook DEBUG logs (logs set at DEBUG level) while replicating the issue to our support email address outlook[at]salesagility[dot]com referencing this Ticket #[2072]. If you could also include what PHP version the CRM is run on, that would be much appreciated and will help us investigate this issue further.

SuiteCRM Outlook Plugin Team

As I told privately to support (without having any further answer), I think the problem happens when there are quotes in the name of the sender. This is an example of the search query that returns an error:

Mon Jul 15 14:56:53 2019 [32386][db9b61ad-5286-ea1d-2700-5c8693c25481][FATAL] Error running count query for Contact List:  Query Failed:  SELECT count(*) c FROM contacts  LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c   LEFT JOIN  users jt0 ON contacts.modified_user_id=jt0.id AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON contacts.created_by=jt1.id AND jt1.deleted=0
 AND jt1.deleted=0  LEFT JOIN  users jt2 ON contacts.assigned_user_id=jt2.id AND jt2.deleted=0
 AND jt2.deleted=0  LEFT JOIN  contacts jt5 ON contacts.reports_to_id=jt5.id AND jt5.deleted=0
 AND jt5.deleted=0  LEFT JOIN  campaigns jt6 ON contacts.campaign_id=jt6.id AND jt6.deleted=0
 AND jt6.deleted=0 LEFT JOIN vis1_visualizzatore1 jt11 ON contacts_cstm.vis1_visualizzatore1_id_c = jt11.id AND jt11.deleted=0  LEFT JOIN cad_cad jt12 ON contacts_cstm.cad_cad_id_c = jt12.id AND jt12.deleted=0  LEFT JOIN users jt13 ON contacts_cstm.user_id_c = jt13.id AND jt13.deleted=0  LEFT JOIN vis2_visualizzatore2 jt14 ON contacts_cstm.vis2_visualizzatore2_id_c = jt14.id AND jt14.deleted=0  LEFT JOIN cad_cad jt15 ON contacts_cstm.cad_cad_id1_c = jt15.id AND jt15.deleted=0  where (contacts.id in (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 = ''Antonio**')) AND contacts.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 'Antonio')) AND contacts.deleted=0' at line 11

The WHERE condition searches for ''Antonio' - that is A PART of the NAME of the sender - rather than for his email address. The wrong string has been taken from the message header, and it happens when there are quotes. As you can see, the starting quote is also taken, resulting in a syntax error.

Asterisks are there because I tried to put bold inside the code. This is the original WHERE condition, with the duplicate quotes resulting in a syntax error:

WHERE eabr.deleted=0 and ea.email_address = ''Antonio'

Hi there,

We have passed this on to our development team who are investigating the issues further. I will get back in contact when I know more.

SuiteCRM Outlook Plugin Team

Hi there,

This issue will be closed as we have received no response, if this is still an issue please comment and we will reopen this ticket. We recommend upgrading your SuiteCRM Outlook Plugin to the latest available version to ensure you stay up to date with new features and fixes.

SuiteCRM Outlook Plugin Team

My Apologies, Please Disregard the last message.

Hi there,

SuiteCRM Outlook Plugin has now been updated to version 3.0.22.0. We were unable to replicate this issue in the new version of the plugin. Could you please install the new update and test to ensure your issue has been resolved.

SuiteCRM Outlook Plugin Team