by eVolpe Consulting Group

Are you facing difficulties trying to coordinate efforts between marketing and sales? The Sugar/SuiteCRM & Mautic Integrator 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

#4281 - Sync Contacts from Mautic to SuiteCRM not Working

Closed Installation created by HelpDeskWittel 2 years ago

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**

  1. HelpDeskWittel member avatar

    HelpDeskWittel

    2 years ago

    Look, on SuiteCRM MauticURL give me NoAccess.

  2. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 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.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "This works brilliantly! It is exactly what we were looking for."

    Read More Reviews