This topic contains 3 replies, has 2 voices, and was last updated by Mike Kudelya 7 years, 7 months ago.
- Topic
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.
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.