by eVolpe Consulting Group

Are you facing difficulties trying to coordinate efforts between marketing and sales? The Mautic Integrator for Sugar/SuiteCRM by eVolpe is the best solution that will help you solve this issue. TRY IT NOW FOR FREE!

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3000 - Tables missing in Mautic

Closed Bug? created by mhoffmann 7 years ago

Hi,

We have just tried installing and configuring the Mautic connector with Sugar Ent (Mautic 2.7..1 Sugar Ent 7.8.1) but we can't get the connector to work. When the scheduler runs the sync job we are getting the following message, why hasn't this table been created?

[Doctrine\DBAL\Exception\TableNotFoundException]
An exception occurred while executing 'SELECT e0_.id AS id_0, e0_.type AS type_1, e0_.data AS data_2, e0_.module AS module_3, e0_.module_id AS module_id
4 FROM ev_integration_queue e0 WHERE e0_.sync_date IS NULL ORDER BY e0_.insert_date ASC':
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.ev_integration_queue' doesn't exist

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.ev_integration_queue' doesn't exist

[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic.ev_integration_queue' doesn't exist

We have a problem when setting the Sugar system settings and mapping the fields. If we don't reenter the Sugar user password each time we do not seem to see the contact mapping section. We are not sure if these settings are saved.

Regards Malcolm

  1. eVolpe_Consulting_Group-primary-contact member avatar

    Dear Malcolm, are you sure that you have run through last steps of Mautic side installation: - Run this formula in console : php -f app/console doctrine:schema:update –force - Again clear Mautic cache: delete folder app/cache/prod

    While running the formula in result the missing table should have been created. Try doing that and please tell us if it has fixed both your problems.

    Best Regards eVolpe Support Team

    • aravinth member avatar

      aravinth

      7 years ago

      Hi When run this one "php -f app/console doctrine:schema:update –force"

      produce the following error.

      PHP Warning: Declaration of MauticPlugin\EVolpeMarketingAutomationBundle\EVolpeMarketingAutomationBundle::onPluginInstall($plugin, $factory, $metadata = NULL, $installedSchema = NULL) should be compatible with Mautic\PluginBundle\Bundle\PluginBundleBase::onPluginInstall(Mautic\PluginBundle\Entity\Plugin $plugin, Mautic\CoreBundle\Factory\MauticFactory $factory, $metadata = NULL, $installedSchema = NULL) in /mymauticpath/plugins/EVolpeMarketingAutomationBundle/EVolpeMarketingAutomationBundle.php on line 23

    • eVolpe_Consulting_Group-primary-contact member avatar

      Dear aravinth,

      We know this. This is just a warning, not an error. You can use our application without any difficulties and do not bother with this warning. This does not affect the operation of the program. This doesn't affect integration in any way.

      Best Regards, eVolpe Support Team

  2. aravinth member avatar

    aravinth

    7 years ago

    Hi,

    Thanks for your reply,

    But I can't continue. Clear the mautic cache and delete the prod folder. Then run this command,

    "php app/console mautic:evolpe:sync"

    Get the following errors

    PHP Warning: Declaration of MauticPlugin\EVolpeMarketingAutomationBundle\EVolpeMarketingAutomationBundle::onPluginInstall($plugin, $factory, $metadata = NULL, $installedSchema = NULL) should be compatible with Mautic\PluginBundle\Bundle\PluginBundleBase::onPluginInstall(Mautic\PluginBundle\Entity\Plugin $plugin, Mautic\CoreBundle\Factory\MauticFactory $factory, $metadata = NULL, $installedSchema = NULL) in /home/vds/mautic.avalia.no/plugins/EVolpeMarketingAutomationBundle/EVolpeMarketingAutomationBundle.php on line 23 EVolpe Sync Start

    [Doctrine\DBAL\Exception\TableNotFoundException]
    An exception occurred while executing 'SELECT e0_.id AS id_0, e0_.type AS type_1, e0_.data AS data_2, e0_.module AS module_3, e0_.module_id AS module_id_4 FROM ev_in
    tegration_queue e0_ WHERE e0_.sync_date IS NULL ORDER BY e0_.insert_date ASC':
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic_avalia_no.ev_integration_queue' doesn't exist

    [Doctrine\DBAL\Driver\PDOException]
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic_avalia_no.ev_integration_queue' doesn't exist

    [PDOException]
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mautic_avalia_no.ev_integration_queue' doesn't exist

    • aravinth member avatar

      aravinth

      7 years ago

      Hi somehow the above error are resolved, But now this one

      [Symfony\Component\Debug\Exception\FatalThrowableError]
      Type error: Argument 1 passed to MauticPlugin\EVolpeMarketingAutomationBundle\Api\CrmApi::__construct() must be an instance of MauticPlugin\EVolpeMarketingAutomation
      Bundle\Integration\EVolpeMarketingAutomationIntegration, boolean given, called in /home/vds/mautic.avalia.no/plugins/EVolpeMarketingAutomationBundle/Command/EVolpeHi
      storyActivityCommand.php on line 54

    • eVolpe_Consulting_Group-primary-contact member avatar

      Dear aravinth,

      Please try the following steps: - check in database if in table lead_fields there exists a record with alias crm_type, if so please delete it: "DELETE FROM lead_fields WHERE alias='crm_type'" - change owner of all files in your mautic instance directory "sudo chown www-data:www-data -R [your_instance_dir]" - clear cache folder - run command "php app/console doctrine:schema:update –force" in instance directory again and then check in database if tables "ev_history_activity_queue", "ev_integration_queue" have been finally created. - if not please sent us information about Mautic version and php_info() data from your server

      Best Regards, eVolpe Support Team

    • aravinth member avatar

      aravinth

      7 years ago

      Hi,

      Thanks for your reply.

      Instead of this "php app/console doctrine:schema:update --force" I use this one "doctrine:schema:update --dump-sql".

      Now tables are created.

      Now I able to sync the contacts from CRM to Mautic but Mautic to CRM is not working.

    • eVolpe_Consulting_Group-primary-contact member avatar

      Hi,

      Do you have any created campaigns or actions in Mautic which uses the action "Push contact to integration"?

      And also did you set up Cron tasks?

      Best regards, eVolpe Support Team

    • aravinth member avatar

      aravinth

      7 years ago

      Hi,

      Do you have any created campaigns or actions in Mautic which uses the action "Push contact to integration"? No.

      And also did you set up Cron tasks? Followed this one for setup the CRON jobs in mautic https://www.mautic.org/getting-started/.

      And also when i click Synchronize records with Mautic nothing happen, it simply reload the page(I am expecting all my contacts to sync, am I right?). When I edit or add contact from CRM that time only I am able to sync.

  3. eVolpe_Consulting_Group-primary-contact member avatar

    Dear aravinth,

    With regards to synchronizing records from Mautic: not all Mautic contacts are automatically synchronized to Sugar. It is up to you to configure in Mautic which contacts will be pushed to Sugar. You can for instance create a campaign that will push all contacts from given segment to Sugar, or you might decide that all those contacts that have reached 100 points in Mautic are interesting enough to push them to Sugar or even, you can create a landing page with form that uses the "push to integration" action. So there are a lot of possibilities to create a custom process.

    If you done this than make sure that you have added all standard mautic jobs to crontab as well as our custom jobs * * * * * /YOUR_MAUTIC_INSTANCE_PATH/app/console mautic:evolpe:historyactivity * * * * * /YOUR_MAUTIC_INSTANCE_PATH/app/console mautic:evolpe:sync

    As for SugarCRM side. The action "Synchronize records with Mautic", since it may take some time, also utilize cron. In order to run Sugar Schedulers, add the following line to the crontab file: * * * * * cd YOUR_SUGAR_INSTANCE_PATH; php -f cron.php > /dev/null 2>&1

    Best regards, eVolpe Support Team

  4. jyotijsr1993 member avatar

    jyotijsr1993

    6 years ago

    [Doctrine\ORM\ORMException] Unknown Entity namespace alias 'maubg_MauticCampaignBundle'.

    On running command php app/console evolpe:sync:campaign

    • eVolpe_Consulting_Group-primary-contact member avatar

      Dear jyotijsr1993,

      thanks for informing us about this problem that oucers when using db prefixes for mautic db tables.

      Please download the newer version of Mautic part of the integrator eVolpe_Mautic_CRM_3.7.86.zip , CRM part does not need changes.

      Best regards, eVolpe Support Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Works very well. Support has been very respectful and fast, when it was required." - BradLohoar

    Read More Reviews