Official SuiteCRM Outlook Plugin

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

Yes t works fine from browser

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.

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

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

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

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