Error with OroCRM Mailchimp Integration "Error occurred during layout update."

We would welcome any advice in getting MailChimp integration to work with OroCRM. We have installed the MailChimp by typing the following command from within our web root:

composer require oro/crm-mail-chimp

We also followed some other instructions about flushing caches and so forth.

However, inside the control panel under System -> Integrations -> Manage Integrations, Then Create Integration button, we receive an error message in the control panel at the top (shown in red with a red triangle) “Error occurred during layout update. Please contact system administrator.”

tail of the app/logs/prod.log shows:

request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: “No route found for “GET /bundles/orocrmmailchimp/js/app/components/api-key-component.js” (from “http://orocrm.domain.com/integration/create”)” at /var/www/orocrm.domain.com/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/EventListener/RouterListener.php line 176 {“exception”:”[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException: No route found for \”GET /bundles/orocrmmailchimp/js/app/components/api-key-component.js\” (from \”http://orocrm.domain.com/integration/create\”) at /var/www/orocrm.domain.com/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/EventListener/RouterListener.php:176, Symfony\\Component\\Routing\\Exception\\ResourceNotFoundException: at /var/www/orocrm.domain.com/app/cache/prod/appProdUrlMatcher.php:8979)”} []

If we ignore this error and attempt to add our MailChimp API key and hit save, we get an additional control panel error message shown in red that reads “Sorry, page was not loaded correctly“. Then in the app/logs/prod.log show two additional error lines:

[2016-09-06 10:42:40] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘INSERT INTO oro_integration_transport (orocrm_mailchimp_apikey, orocrm_mailchimp_act_up_int, type) VALUES (?, ?, ?)’ with params [“e0fc6b25e8f92e6d8a1264acd3bfa2e0-us6”, 90, “mailchimptransport”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘orocrm_mailchimp_apikey’ in ‘field list'” at /var/www/orocrm.domain.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:”[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException: An exception occurred while executing ‘INSERT INTO oro_integration_transport (orocrm_mailchimp_apikey, orocrm_mailchimp_act_up_int, type) VALUES (?, ?, ?)’ with params [\”e0fc6b25e8f92e6d8a1264acd3bfa2e0-us6\”, 90, \”mailchimptransport\”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘orocrm_mailchimp_apikey’ in ‘field list’ at /var/www/orocrm.domain.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘orocrm_mailchimp_apikey’ in ‘field list’ at /var/www/orocrm.domain.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘orocrm_mailchimp_apikey’ in ‘field list’ at /var/www/orocrm.domain.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)”} []
[2016-09-06 10:42:40] request.CRITICAL: Exception thrown when handling an exception (Oro\Bundle\SecurityBundle\Exception\OrganizationAccessDeniedException: at /var/www/orocrm.domain.com/app/cache/prod/classes.php line 2171) {“exception”:”[object] (Oro\\Bundle\\SecurityBundle\\Exception\\OrganizationAccessDeniedException: at /var/www/orocrm.domain.com/app/cache/prod/classes.php:2171)”} []

Additional Info:

Running Ubuntu 16.04 LTS on AWS instance with Apache2/2.4.18 (Ubuntu) and PHP 7.0.8. MySql 5.6.x on separate RDS instance.

Topic

[Mike KudelyaParticipant]

Hi,

Are you sure that you ran platform update in depends of your env (dev/prod) ?

Shell

app/console oro:platform:update --env dev --force

1	app/console oro:platform:update --env dev --force

After you run this command, migration “OroCRM\Bundle\MailChimpBundle\Migrations\Schema\OroCRMMailChimpBundleInstaller” must be executed

[mrdeveloperParticipant]

Many thanks. Running app/console oro:platform:update --env dev --force seems to have stopped the errors from appearing and we were able to add a MailChimp API Key.

Does this mean the system has run the installer for us?

What is the correct process to run the OroCRMMailCrhimpBundlerInstall.php and where do I find the instructions for this. I don’t see anything written about this in the GitHub repository- unless I missed it.

[Mike KudelyaParticipant]

Sorry, the OroCRMMailCrhimpBundlerInstall.php runs when you install new system from scratch (so to not run a lot of migrations). When you run platform update, files like *Install.php is ignoring and is running all migrations, in your case there. For now all your migrations were executed and system works as expected.

[Author]

Replies