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

#5655 - Error in Plugin configuration

Open Bug? created by Verified Purchase 6 days ago

Hello,

Under the plug-in configuration in section Outlook Users, I get the following error: "Database failure. Please refer to suitecrm logs for details."

In the logs I get: Fri Mar 21 11:02:28 2025 [400843][1][FATAL] Error running count query for User List: Query Failed: (SELECT count(*) c FROM users LEFT JOIN email_addr_bean_rel eabr ON users.id = eabr.bean_id AND eabr.primary_address = 1 AND eabr.deleted = 0 LEFT JOIN email_addresses e ON e.id = eabr.email_address_id AND e.deleted = 0 WHERE users.sa_outlook_is_licensed != 0 AND users.deleted = 0): MySQL error 1054: Unknown column 'users.sa_outlook_is_licensed' in 'where clause'

I'm using SuiteCRM 8.7.1. I did run Quick Repair and Rebuild several times....

Thanks for your assistance

Patrick

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    6 days ago

    HI Patrick,

    When running quick repair and rebuild, please scroll down to the bottom of the screen and be sure to apply the database changes recommended. This should resolve your issue.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "no funciono no consigo conectar. ni con suitcrm 7 ni 8 me doy de baja por que no es posible." - santiago

    Read More Reviews