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!
#4281 - Sync Contacts from Mautic to SuiteCRM not Working
Hi for all...Someone could help me?
We starting to use SuiteCRM+Mautic in aws, and I folowed instructions on support page and I think that all is correct. However, when I create one test contact in SuiteCRM, I got him quickly in Mautic, but When I create on mautic the test user isn't sync on SuiteCRM.
SuiteCRM.log:
Mon Dec 2 15:14:30 2019 [2563][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:31 2019 [1913][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:33 2019 [2561][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:35 2019 [1915][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:36 2019 [1916][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:38 2019 [2559][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:40 2019 [2556][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:41 2019 [1914][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:14:43 2019 [2563][6d128660-b1a9-2b93-100d-5d953d4985bd][FATAL] MAUTIC API ERROR, type: , code: 500, message: Looks like I encountered an error (error #500). If I do it again, please report me to the system administrator!
Mon Dec 2 15:15:33 2019 [2556][1][FATAL] Mysqli_query failed.
Mon Dec 2 15:15:33 2019 [2556][1][FATAL] Error running count query for Lead List: Query Failed: ( SELECT count(*) c FROM ev_mauticactivities INNER JOIN leads ev_mauticactivities_rel ON ev_mauticactivities.parent_id=ev_mauticactivities_rel.id AND ev_mauticactivities_rel.deleted=0
AND ev_mauticactivities.parent_type = 'Leads'
where (1=0) AND ev_mauticactivities.deleted=0 ): MySQL error 1267: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Mon Dec 2 15:15:33 2019 [2556][1][FATAL] Exception handling in /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php:400
Mon Dec 2 15:15:33 2019 [2556][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Mon Dec 2 15:15:33 2019 [2556][1][FATAL] backtrace:
#0 /opt/bitnami/apps/suitecrm/htdocs/include/database/DBManager.php(353): sugar_die('Database failur...')
#1 /opt/bitnami/apps/suitecrm/htdocs/include/database/DBManager.php(328): DBManager->registerError('Error running c...', 'Error running c...', true)
#2 /opt/bitnami/apps/suitecrm/htdocs/include/database/MysqliManager.php(179): DBManager->checkError('Error running c...', true)
#3 /opt/bitnami/apps/suitecrm/htdocs/data/SugarBean.php(1502): MysqliManager->query('( SELECT count(...', true, 'Error running c...')
#4 /opt/bitnami/apps/suitecrm/htdocs/data/SugarBean.php(1253): SugarBean->_get_num_rows_in_query('( SELECT count(...', false)
#5 /opt/bitnami/apps/suitecrm/htdocs/data/SugarBean.php(1008): SugarBean->process_union_list_query(Object(Lead), '(SELECT ev_maut...', 0, -1, 10, '', Object(aSubPanel), '( SELECT count(...', Array)
#6 /opt/bitnami/apps/suitecrm/htdocs/include/ListView/ListView.php(1152): SugarBean::get_union_related_list(Object(Lead), 'ev_mauticactivi...', 'asc', '', 0, -1, 10, '', Object(aSubPanel))
#7 /opt/bitnami/apps/suitecrm/htdocs/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(Lead), Object(aSubPanel), 'ev_mauticactivi...', false)
#8 /opt/bitnami/apps/suitecrm/htdocs/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('Leads', Object(Lead), Object(aSubPanel), false)
#9 /opt/bitnami/apps/suitecrm/htdocs/include/SubPanel/SubPanel.php(236): SubPanel->ProcessSubPanelListView('include/SubPane...', Array, false)
#10 /opt/bitnami/apps/suitecrm/htdocs/include/SubPanel/SubPanelViewer.php(96): SubPanel->display(false)
#11 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php(1087): require_once('/opt/bitnami/ap...')
#12 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php(468): SugarController->handleActionMaps()
#13 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/Controller/SugarController.php(373): SugarController->process()
#14 /opt/bitnami/apps/suitecrm/htdocs/include/MVC/SugarApplication.php(113): SugarController->execute()
#15 /opt/bitnami/apps/suitecrm/htdocs/index.php(55): SugarApplication->execute()
#16 {main}
**MAuticLog. **
2019-12-02 23:14:04] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4602]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4602]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:05] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4603]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4603]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:07] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4604]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4604]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:08] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4605]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4605]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4606]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4606]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:12] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4607]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4607]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:13] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4608]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4608]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:15] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4609]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4609]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:17] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4610]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4610]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:18] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4611]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4611]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:20] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4612]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4612]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:22] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4613]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4613]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:23] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4614]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4614]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:25] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4615]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4615]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:26] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4616]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4616]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:28] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4617]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4617]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:30] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4618]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4618]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:31] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4619]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4619]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:33] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4620]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4620]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:35] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4621]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4621]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4622]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4622]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:38] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4623]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4623]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:40] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4624]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4624]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:41] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4625]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4625]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
[2019-12-02 23:14:43] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params ["9", "http:\/\/21", "Potencial", "22", "23", "24", "25", "26", "27", "28", 4626]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'UPDATE ma_leads SET fax = ?, website = ?, crm_type = ?, facebook = ?, foursquare = ?, googleplus = ?, instagram = ?, linkedin = ?, skype = ?, twitter = ? WHERE id = ?' with params [\"9\", \"http:\\/\\/21\", \"Potencial\", \"22\", \"23\", \"24\", \"25\", \"26\", \"27\", \"28\", 4626]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list' at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []
****Enviroment: ** EC2 and AMI AWS images. SuiteCRM: 7.11.8 Mautic: 2.15.2**
4 years ago
Look, on SuiteCRM MauticURL give me NoAccess.
4 years ago
Hi HelpDeskWittel,
Thank you for inform us about your issues, We hope that below instructions will help you:
From first log:
MySQL error 1267: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
You have to unificate your database collation, because you have in some places utf8_unicode_ci and utf8_general_ci collations. It not depends by our package for CRM or plugin for Mautic but by Mautic instance upgrade failure. Similar problem is described here: https://forum.mautic.org/t/unsuccessful-2-9-update/9024/8
From second log:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax' in 'field list'"
The reason for this problem is similar to previous - Mautic instance upgrade failure. You don't have 'fax' column in 'ma_leads' table. You should make this instruction: https://www.mautic.org/docs/en/tips/update-failed.html (especially point 4.).
None of above problems is result by using our CRM package or Mautic plugin.
After fixing your instance, please inform us if everything works properly.