by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - Compatible with the Outlook Web App or Outlook 2016+ connected to Office365 or Exchange Server 2016. A complete rebuild developed and maintained by SuiteCRM developers, the addon retains previous functionality while massively improves performance, reliability and stability!

Free 30 day trial
Try it Now

#4780 - Suite CRM Outlook plugin stopped working after upgrade Cert on Suite server

Closed Bug? created by ron Verified Purchase a year ago

It was working before upgrade. in one machine it's not loaded completely and another machine giving me an error like waiting for connection

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    a year ago

    Hi there,

    Can you connect to the CRM from the workstation that is having difficulties using the web browser and does that give any warnings about certificates at that stage?

    Regards, The Outlook Plugin Team

    • ron member avatar

      ron Verified Purchase

      about a year ago

      Yes it works fine from browser

    • ron member avatar

      ron Verified Purchase

      11 months ago

      Through our troubleshooting we were able to get the plugin working, but with the credentials we keep getting an error of the user not having a valid license. we can confirm the user is added into the plugin user sub panel. We have even tried it with another user that is working fine on another machine and still get the error with no valid license again.

    • ron member avatar

      ron Verified Purchase

      11 months ago

      When we go back to SuiteCRM to re-add the user we are getting an error of No-Valid Key Found.

  2. ron member avatar

    ron Verified Purchase

    about a year ago

    Yes t works fine from browser

  3. ron member avatar

    ron Verified Purchase

    about a year ago

    Through our troubleshooting we were able to get the plugin working, but with the credentials we keep getting an error of the user not having a valid license. we can confirm the user is added into the plugin user sub panel. We have even tried it with another user that is working fine on another machine and still get the error with no valid license again.

  4. ron member avatar

    ron Verified Purchase

    about a year ago

    Also when i tried to add user under outlook user profile into plugin its giving me an error like - No Valid Key Found

  5. suitecrm member avatar

    SuiteCRM Provider Affiliate

    11 months ago

    Hi,

    Could you please send us the exact steps to replicate your current issue and give us further details of any errors within the logs and any other details that could be relevant to find the problem?

    Regards, The Outlook Plugin Team

    • ron member avatar

      ron Verified Purchase

      11 months ago

      we have followed the documentation from the suitecrm store here: https://store.suitecrm.com/docs/SuiteCRM-official-outlook-plugin/plugin-installation for the logs am I able to upload them here?

      checking the logs the standout errors I see are:

      Wed Mar 15 14:45:01 2023 [22604][1][FATAL] Job e078e4fb-13e6-87a9-e332-64123c75554d (Outlook Sync) failed in CRON run Wed Mar 15 14:45:01 2023 [22604][6daf2cf4-f619-57bd-07aa-568d1bd8c647][WARN] There is no any workflow to run Wed Mar 15 14:45:02 2023 [22604][6daf2cf4-f619-57bd-07aa-568d1bd8c647][WARN] aorRunScheduledReports: id: 91716412-fea9-b8ca-fcc1-5da4c0127f37 got exception. code: 0, message: Invalid CRON field value null as position 0

      Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][FATAL] Mysqli_query failed. Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][FATAL] Query Failed: SELECT detai_site.id , detai_site.modified_user_id , detai_site.created_by , detai_site.assigned_user_id , detai_site.name , detai_site.date_entered , detai_site.date_modified , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod, detai_site.description , detai_site.deleted , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, detai_site.detai_site_type , detai_site.industry , detai_site.annual_revenue , detai_site.phone_fax , detai_site.billing_address_street , detai_site.billing_address_city , detai_site.billing_address_state , detai_site.billing_address_postalcode , detai_site.billing_address_country , detai_site.rating , detai_site.phone_office , detai_site.phone_alternate , detai_site.website , detai_site.ownership , detai_site.employees , detai_site.ticker_symbol , detai_site.shipping_address_street , detai_site.shipping_address_city , detai_site.shipping_address_state , detai_site.shipping_address_postalcode , detai_site.shipping_address_country , detai_site.location , detai_site.equipment , detai_site.outside , detai_site.inside , detai_site.data , detai_site.voice , detai_site.serial , detai_site.access , detai_site.login , detai_site.pass , detai_site.notes , detai_site.circuitid , detai_site.carrier FROM detai_site LEFT JOIN users jt0 ON detai_site.modified_user_id=jt0.id AND jt0.deleted=0

      AND jt0.deleted=0 LEFT JOIN users jt1 ON detai_site.created_by=jt1.id AND jt1.deleted=0

      AND jt1.deleted=0 LEFT JOIN users jt2 ON detai_site.assigned_user_id=jt2.id AND jt2.deleted=0

      AND jt2.deleted=0 where (((detai_site.name like 'apc%' ) OR ( detai_site.phone_office like 'apc%' ) OR ( ( email1 like 'apc%' OR detai_site.email2 like 'apc%' )))) AND detai_site.deleted=0 ORDER BY detai_site.date_entered DESC LIMIT 0,21: MySQL error 1054: Unknown column 'email1' in 'where clause'

      Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] Cannot find bean file for module: thread Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] Cannot find bean file for module: thread Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] Cannot find bean file for module: thread Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][ERROR] Unable to find relationship projects_contacts_resources Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] project_resource for projects_contacts_resources failed to load

  6. ron member avatar

    ron Verified Purchase

    11 months ago

    we have followed the documentation from the suitecrm store here: https://store.suitecrm.com/docs/SuiteCRM-official-outlook-plugin/plugin-installation for the logs am I able to upload them here?

    checking the logs the standout errors I see are:

    Wed Mar 15 14:45:01 2023 [22604][1][FATAL] Job e078e4fb-13e6-87a9-e332-64123c75554d (Outlook Sync) failed in CRON run Wed Mar 15 14:45:01 2023 [22604][6daf2cf4-f619-57bd-07aa-568d1bd8c647][WARN] There is no any workflow to run Wed Mar 15 14:45:02 2023 [22604][6daf2cf4-f619-57bd-07aa-568d1bd8c647][WARN] aorRunScheduledReports: id: 91716412-fea9-b8ca-fcc1-5da4c0127f37 got exception. code: 0, message: Invalid CRON field value null as position 0


    Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][FATAL] Mysqli_query failed. Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][FATAL] Query Failed: SELECT detai_site.id , detai_site.modified_user_id , detai_site.created_by , detai_site.assigned_user_id , detai_site.name , detai_site.date_entered , detai_site.date_modified , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod, detai_site.description , detai_site.deleted , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, detai_site.detai_site_type , detai_site.industry , detai_site.annual_revenue , detai_site.phone_fax , detai_site.billing_address_street , detai_site.billing_address_city , detai_site.billing_address_state , detai_site.billing_address_postalcode , detai_site.billing_address_country , detai_site.rating , detai_site.phone_office , detai_site.phone_alternate , detai_site.website , detai_site.ownership , detai_site.employees , detai_site.ticker_symbol , detai_site.shipping_address_street , detai_site.shipping_address_city , detai_site.shipping_address_state , detai_site.shipping_address_postalcode , detai_site.shipping_address_country , detai_site.location , detai_site.equipment , detai_site.outside , detai_site.inside , detai_site.data , detai_site.voice , detai_site.serial , detai_site.access , detai_site.login , detai_site.pass , detai_site.notes , detai_site.circuitid , detai_site.carrier FROM detai_site LEFT JOIN users jt0 ON detai_site.modified_user_id=jt0.id AND jt0.deleted=0

    AND jt0.deleted=0 LEFT JOIN users jt1 ON detai_site.created_by=jt1.id AND jt1.deleted=0

    AND jt1.deleted=0 LEFT JOIN users jt2 ON detai_site.assigned_user_id=jt2.id AND jt2.deleted=0

    AND jt2.deleted=0 where (((detai_site.name like 'apc%' ) OR ( detai_site.phone_office like 'apc%' ) OR ( ( email1 like 'apc%' OR detai_site.email2 like 'apc%' )))) AND detai_site.deleted=0 ORDER BY detai_site.date_entered DESC LIMIT 0,21: MySQL error 1054: Unknown column 'email1' in 'where clause'


    Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] Cannot find bean file for module: thread Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] Cannot find bean file for module: thread Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] Cannot find bean file for module: thread Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][ERROR] Unable to find relationship projects_contacts_resources Wed Mar 15 14:57:57 2023 [18723][d6546013-614a-77bb-a0d3-43e3297e9c4a][WARN] project_resource for projects_contacts_resources failed to load

  7. suitecrm member avatar

    SuiteCRM Provider Affiliate

    11 months ago

    Hi,

    Thanks for sending over those logs, we can see that there is nothing obvious in those logs that suggest any errors. You are welcome to send us the full log at debug level to us directly using our email - outlook[at]salesagility.com .

    If you could provide steps to replicate your issue as well then this may help us as well to find your issue.

    Regards, The Outlook Plugin Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "It works very good. You should deactivate the contacts sync on the first run, because it sorts the contacts in the main folder and thus uploads duplic..." - Wieland

    Read More Reviews