by SuiteCRM

The Ultimate Outlook Plugin Has Arrived - In response to user requests, SuiteCRM have created the ultimate Outlook plugin which is maintained by SuiteCRM developers. Our plugin supports Outlook 2010 upwards and includes two way synchronisation with CRM, Calender, Calls, Meeting, Tasks and Email Archiving.

Cancel at any time!
Free Trial

#2072 - Issues on automatic email archiving

In Progress Bug? created by sviluppo Verified Purchase 2 months ago

Hi,
Testing the automatic email archiving, on some message (both with incoming and outgoing emails) we receive error 500. Log shows this error:

2019-07-04 17:52:48,597 | 7 | ERROR | Failed to archive MailItem 'R: Preventivo' from 'yyyyyy@xxxxxxxxx.com
System.Net.WebException: Errore del server remoto: (500) Errore interno del server.
in System.Net.HttpWebRequest.GetResponse()
in SuiteCRMClient.CrmRestServer.GetResponseString(HttpWebRequest request)
in SuiteCRMClient.CrmRestServer.GetCrmResponse[T](String method, Object input)
in SuiteCRMClient.Email.ArchiveableEmail.GetRelatedIds(IEnumerable1 moduleKeys, IEnumerable1 excludedAddresses)
in SuiteCRMClient.Email.ArchiveableEmail.Save(IEnumerable1 relatedRecords, String excludedEmails) in SuiteCRMAddIn.Extensions.MailItemExtensions.Archive(MailItem olItem, EmailArchiveReason reason, IEnumerable1 moduleKeys, String excludedEmails)
in SuiteCRMAddIn.BusinessLogic.EmailArchiving.ArchiveMailItem(Object item, IEnumerable`1 moduleKeys)

Host is Linux with PHP 7.0, and we tried both suiteCRM 7.11.7 and 7.10.18.

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 months ago

    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

  2. sviluppo member avatar

    sviluppo Verified Purchase

    2 months ago

    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

  3. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 months ago

    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

  4. sviluppo member avatar

    sviluppo Verified Purchase

    one month ago

    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.

  5. sviluppo member avatar

    sviluppo Verified Purchase

    one month ago

    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'
    
  6. suitecrm member avatar

    SuiteCRM Provider Affiliate

    one month ago

    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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...