#3000 - Tables missing in Mautic
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
7 years ago
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
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
7 years ago
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
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
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
7 years ago
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
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.
7 years ago
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
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.
7 years ago
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
6 years ago
[Doctrine\ORM\ORMException] Unknown Entity namespace alias 'maubg_MauticCampaignBundle'.
On running command php app/console evolpe:sync:campaign
6 years ago
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