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!
#5101 - Database Error After Module Installation - 8.4.2
Brand new installation. Following the guide and got as far as selecting licensed users where I get "Database failure. Please refer to suitecrm.log for details." After a bit of research I found that I didn't have an email address on my account profile. Adding the email and saving threw another database error. Contents of log file:
Thu Nov 16 00:38:24 2023 [1415][1][FATAL] Mysqli_query failed.
Thu Nov 16 00:38:24 2023 [1415][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'
Thu Nov 16 00:38:24 2023 [1415][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Thu Nov 16 00:42:11 2023 [1667][1][FATAL] Mysqli_query failed.
Thu Nov 16 00:42:11 2023 [1667][1][FATAL] Error updating table: users: Query Failed: UPDATE users
SET user_name='jason',user_hash='hash',system_generated_password=0,pwd_last_changed=NULL,authenticate_id=NULL,sugar_login=1,first_name=NULL,last_name='Administrator',is_admin=1,external_auth_only=0,receive_notifications=1,description=NULL,date_modified='2023-11-16 00:42:11',modified_user_id='1',created_by='1',title='Administrator',photo=NULL,department=NULL,phone_home=NULL,phone_mobile=NULL,phone_work=NULL,phone_other=NULL,phone_fax=NULL,status='Active',address_street=NULL,address_city=NULL,address_state=NULL,address_country=NULL,address_postalcode=NULL,portal_only=0,show_on_employees=1,employee_status='Active',messenger_id=NULL,messenger_type=NULL,reports_to_id='',is_group=0,factor_auth=0,factor_auth_interface=NULL,sa_outlook_sync_date='1970-01-01',sa_outlook_folders=NULL,sa_outlook_enable=0,sa_outlook_is_licensed=0
WHERE users.id = '1' AND deleted=0: MySQL error 1054: Unknown column 'sa_outlook_sync_date' in 'field list'
Thu Nov 16 00:42:11 2023 [1667][1][FATAL] Exception handling in /var/www/suitecrm/public/legacy/include/MVC/Controller/SugarController.php:397
Thu Nov 16 00:42:11 2023 [1667][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
- Most Recent Love from Users
rimacoca- Ricardo Cairello
- marcusvsgimenes
- Ricardo Cairello
- thermoprintix
- clientes
5 months ago
It seems as though the users table was supposed to be modified at install and wasn't. Did I miss a step, did a script not run, or could my install be incorrectly configured?
5 months ago
Hi there,
Could you please confirm if you ran a Quick Repair and Rebuild after installing the plugin before you continued on with the set-up?
Thanks, The Outlook Plugin Team
5 months ago
I did... or so I thought. Looking further I didn't execute at the bottom. New to SuiteCRM so thank you for teaching me!
5 months ago
Hi there,
Did running a quick repair and rebuild and then executing below resolve your issue?
Thanks, The Outlook Plugin Team