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!
#4415 - SuiteCRM Outlook Plugin Error running count query for User List: Query Failed
I just added the Outlook Plugin to SuiteCRM ( Version 7.11.19 Sugar Version 6.5.25 (Build 344) ) the license is verified, I exported the manifest and tried to add an Outlook user and got the error: "Database failure. Please refer to suitecrm.log for details."
Here are the log entries:
Thu Jul 21 14:41:07 2022 [26502][seed_jim_id][FATAL] Query Failed: UPDATE users SET sa_outlook_is_licensed = 1 WHERE deleted=0 AND sa_outlook_is_licensed != 0: MySQL error 1054: Unknown column 'sa_outlook_is_licensed' in 'where clause' Thu Jul 21 14:41:07 2022 [26502][seed_jim_id][FATAL] Mysqli_query failed. Thu Jul 21 14:41:07 2022 [26502][seed_jim_id][FATAL] Error running count query for User List: Query Failed: (SELECT count(*) c FROM users WHERE sa_outlook_is_licensed != 0 AND deleted = 0): MySQL error 1054: Unknown column 'sa_outlook_is_licensed' in 'where clause' Thu Jul 21 14:41:07 2022 [26502][seed_jim_id][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
- Most Recent Love from Users
rimacoca- Ricardo Cairello
- marcusvsgimenes
- Ricardo Cairello
- thermoprintix
- clientes
2 years ago
Please ensure you have ran the quick repair and rebuild process, followed by applying any database customisation it recommends.