Official SuiteCRM Outlook Plugin

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!

Cancel at any time!
Free Trial

#3304 - Cannot install Outlook plugin v4

Closed Installation created by jasonc 3 years ago

When I try to install the plugin I get the following errors in the suitecrm.log

MySQL error 1071: Specified key was too long; max key length is 767 bytes

I am running the installation in AWS with an EC2 frontend for the web application and a separate RDS instance running mysql for the database.

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 years ago

    Hi there,

    Can you confirm you are attempting to install the V4 plugin? Do you get any errors on screen at the same time?

    • invera member avatar

      invera Verified Purchase

      3 years ago

      Yes V4

    • invera member avatar

      invera Verified Purchase

      3 years ago

      we are getting this error in outlook (see image attached)

    • invera member avatar

      invera Verified Purchase

      3 years ago

      "An unknown error has occurred, please check input and try again.

  2. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 years ago

    Can you confirm you are using the correct API Key?

    • jasonc member avatar

      jasonc

      3 years ago

      Hello, we did follow the instructions and found the api key in the suite crm. But I feel like the issue is with the module installation on the server side. Doesn't that part have to be done before adding the plugin to outlook.

  3. jasonc member avatar

    jasonc

    3 years ago

    On top of the error we get in Outlook, we get the error mentioned in the suitecrm.log when trying to install the plugin.

  4. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 years ago

    Hi there,

    Yes the installation of the plugin in suite is critical, can you uninstall the plugin if it already exists then run a Quick Repair and Rebuild and then try installing again. It may be worth re-downloading the package from the downloads page to ensure there's nothing missing.

    Let me know how you get on, Thanks!

  5. jasonc member avatar

    jasonc

    3 years ago

    I did try that, this is the results when I do that. The Repair and Rebuild doesn't work and fails.

    First I get

    "Differences found between database and vardefs"

    I am provided with a script to run against the database or have the SuiteCRM Application run it. I execute the script from SuiteCRM and get

    "Database failure. Please refer to suitecrm.log for details."

    The suitecrm.log has the following,

    Thu Feb  4 18:07:17 2021 [30130][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Feb  4 18:07:17 2021 [30130][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] backtrace:
#0 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/database/DBManager.php(328): DBManager->registerError('Executing repai...', 'Executing repai...', true)
#2 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/database/MysqliManager.php(179): DBManager->checkError('Executing repai...', true)
#3 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/modules/Administration/repairDatabase.php(97): MysqliManager->query('ALTER TABLE fie...', true, 'Executing repai...')
#4 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/View/SugarView.php(839): include_once('/var/www/html/s...')
#5 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('modules/Adminis...')
#6 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/View/SugarView.php(226): ViewClassic->display()
#7 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/Controller/SugarController.php(435): SugarView->process()
#8 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/index.php(52): SugarApplication->execute()
#11 {main}
Thu Feb  4 18:07:44 2021 [29341][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Thu Feb  4 18:07:46 2021 [29341][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Thu Feb  4 18:07:47 2021 [29341][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] SugarBean::populateDefaultValues $field_defs should be an array

    I suspect that I cannot proceed to the Outlook plugin part of the setup until this database issue is resolved.

    Jason

    • jasonc member avatar

      jasonc

      3 years ago

      Sorry, the following is also related to the quick repair & rebuild of the database.

      Thu Feb  4 18:11:57 2021 [29342][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] Executing repair query:  Query Failed: ALTER TABLE fields_meta_data   modify COLUMN `id` varchar(255)  NOT NULL ,  DROP INDEX idx_meta_cm_del,  ADD INDEX idx_meta_cm_del (custom_module,deleted): MySQL error 1071: Specified key was too long; max key length is 767 bytes
Thu Feb  4 18:11:57 2021 [29342][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] Exception handling in /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/Controller/SugarController.php:400
Thu Feb  4 18:11:57 2021 [29342][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Feb  4 18:11:57 2021 [29342][e8fc3981-cd94-3833-b7a6-5e5fd0b4faa0][FATAL] backtrace:
#0 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/database/DBManager.php(328): DBManager->registerError('Executing repai...', 'Executing repai...', true)
#2 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/database/MysqliManager.php(179): DBManager->checkError('Executing repai...', true)
#3 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/modules/Administration/repairDatabase.php(97): MysqliManager->query('ALTER TABLE fie...', true, 'Executing repai...')
#4 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/View/SugarView.php(839): include_once('/var/www/html/s...')
#5 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('modules/Adminis...')
#6 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/View/SugarView.php(226): ViewClassic->display()
#7 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/Controller/SugarController.php(435): SugarView->process()
#8 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#9 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /var/www/html/suitecrm.invera.com/SuiteCRM-7.11.2/index.php(52): SugarApplication->execute()
#11 {main}

  6. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 years ago

    If you try running a repair and rebuild again does the issue reappear? If so can you copy it the script and run it manually via MySQL command line or preferably PHPMyAdmin where you will get better reporting.

    • jasonc member avatar

      jasonc

      3 years ago

      I tried that and here is what I got for one of the alter commands I was instructed to apply,

      mysql> ALTER TABLE leads   DROP INDEX idx_lead_acct_name_first,  ADD INDEX idx_lead_acct_name_first (account_name,deleted);
Query OK, 0 rows affected, 1 warning (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 1

mysql> show warnings;
+---------+------+---------------------------------------------------------+
| Level   | Code | Message                                                 |
+---------+------+---------------------------------------------------------+
| Warning | 1071 | Specified key was too long; max key length is 767 bytes |
+---------+------+---------------------------------------------------------+
1 row in set (0.00 sec)

      I then proceeded to try a few other alter commands and they all gave me the same warning.

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      3 years ago

      Thanks Jason,

      Could I get you to confirm a few extra things for us?

      What MySQL, PHP and Suite version are you using? Ignoring any of the issues mentioned above, when attempting to load the Suite side of the plugin (The .zip file) via the module loader, do you receive any errors directly on-screen/does the module finish the install and show as installed on the module loader screen? Secondly, can you access the Outlook Config menu at the bottom of the administration menu?

      This information will be helpful with debugging your issue further, Thanks, Mac

  7. jasonc member avatar

    jasonc

    3 years ago

    Hello, the mysql version is 5.6.44, PHP is version 7.2.24 and SuiteCRM is Version 7.11.18.

    When trying to install the SuiteCRM Outlook plugin I get the following:

    Including: cache/upgrades/temp/b0oB2G/scripts/pre_install.php
100%     

Display Log
Installing vardefs extension
Rebuilding ActionViewMap...
Rebuilding ActionFileMap...
Rebuilding ActionReMap...
Rebuilding Administration...
Rebuilding EntryPointRegistry...
Rebuilding Extensions...
Rebuilding FileAccessControlMap...
Rebuilding Layoutdefs...
Rebuilding GlobalLinks...
Rebuilding LogicHooks...
Rebuilding Menus...
Rebuilding Include...
Rebuilding ScheduledTasks...
Rebuilding UserPage...
Rebuilding Utils...
Rebuilding Vardefs...
Rebuilding JSGroupings...
Rebuilding Actions...
Including: cache/upgrades/temp/b0oB2G/scripts/post_install.php
Database failure. Please refer to suitecrm.log for details.

    I do see the Outlook plugin configuration menu in the Admin screen and can access it.

  8. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 years ago

    Hi there,

    Could you please confirm if this issue you are having still exists?

    Regards, Outlook Plug-in Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.10.10 to 8.6.1
Read Our Review

  • "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

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

Outlook 365 and SuiteCRM Integration

Make life easier by reducing the need to flip between apps. If you are using Outlook Web App, Outlook 2013, or Outlook 2016 connected to Office365 or Exchange Server 2013 then be sure to take advantage of this email and contact synchronization add-on. Smartly links emails to your SuiteCRM records an...

Rating

SuiteCRM Enterprise-Class Outlook Integration

Implicit FrontEnd provides deep integration with Microsoft Outlook. In addition to full two-way synchronization of Outlook data such as contacts and calendars, it allows you to sync CRM data including accounts, opportunities, quotes etc. so that you can do all your CRM work without leaving Outlook. ...

Rating
Featured
Integrations Productivity Sales outlook microsoft office email office 365