Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 3 replies, has 2 voices, and was last updated by Mike Kudelya Mike Kudelya 1 year, 2 months ago.

  • Creator
    Topic
  • #22439

    mrdeveloper
    Participant

    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #22499
    Mike Kudelya
    Mike Kudelya
    Oro Core

    Hi,

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

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

    #22766

    mrdeveloper
    Participant

    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.

    #22875
    Mike Kudelya
    Mike Kudelya
    Oro Core

    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.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

ssossossosso