![](https://www.gravatar.com/avatar/8a071282ab04aa281656c43d2b34b92f?d=https%3A%2F%2Fstore.suitecrm.com%2Fassets%2Fimg%2Favatars%2Fdefault.png)
-
Display Namejasonc
-
Member SinceDecember 22nd, 2020
-
Last SeenFebruary 17th, 2021
jasonc does not have any add-ons for sale.
-
Support February 19th, 2021 @ 2:06 pm
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.
View Comment
-
Support February 17th, 2021 @ 3:02 pm
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.
View Comment
-
Support February 4th, 2021 @ 6:16 pm
Sorry, the following is also related to the quick repair & rebuild of the database.
View CommentThu 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}
-
Support February 4th, 2021 @ 6:14 pm
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
View Comment
-
Support February 1st, 2021 @ 11:59 pm
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.
View Comment
-
Support January 26th, 2021 @ 1:18 pm
On top of the error we get in Outlook, we get the error mentioned in the suitecrm.log when trying to install the plugin.
View Comment
jasonc has not rated any add-ons.
jasonc has not verified any add-ons.
jasonc has not created any Wanted Add-ons.