Mautic Community Forums

Can't send emails

Hello kind folks,



I’m having an issue were I can’t send emails. Below is my error log. Can anybody help me shine some light on this?



[2016-06-03 00:13:21] mautic.NOTICE: PHP Notice: Array to string conversion - in file /opt/bitnami/apps/mautic/htdocs/app/bundles/CoreBundle/Helper/InputHelper.php - at line 266 [] []

[2016-06-03 00:15:50] mautic.NOTICE: PHP Notice: Array to string conversion - in file /opt/bitnami/apps/mautic/htdocs/app/bundles/CoreBundle/Helper/InputHelper.php - at line 266 [] []



[2016-06-03 00:20:03] mautic.ERROR: DoctrineDBALDBALException: An exception occurred while executing ‘INSERT INTO ma_page_redirects (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, redirect_id, url, hits, unique_hits, email_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2016-06-03 00:20:03”, null, null, null, null, null, null, null, null, “e489f4c5621070d834ace156d”, “http://swgins.com/”, 0, 0, null]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘email_id’ in ‘field list’ (uncaught exception) at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 while running console command mautic:campaigns:trigger [] []



[2016-06-03 00:44:57] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT m0_.is_published AS is_published0, m0_.date_added AS date_added1, m0_.created_by AS created_by2, m0_.created_by_user AS created_by_user3, m0_.date_modified AS date_modified4, m0_.modified_by AS modified_by5, m0_.modified_by_user AS modified_by_user6, m0_.checked_out AS checked_out7, m0_.checked_out_by AS checked_out_by8, m0_.checked_out_by_user AS checked_out_by_user9, m0_.id AS id10, m0_.redirect_id AS redirect_id11, m0_.url AS url12, m0_.hits AS hits13, m0_.unique_hits AS unique_hits14, m0_.email_id AS email_id15 FROM ma_page_redirects m0_ WHERE m0_.url IN (?) AND m0_.email_id IS NULL’ with params [“http://swgins.com/”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m0_.email_id’ in ‘field list’” at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT m0_.is_published AS is_published0, m0_.date_added AS date_added1, m0_.created_by AS created_by2, m0_.created_by_user AS created_by_user3, m0_.date_modified AS date_modified4, m0_.modified_by AS modified_by5, m0_.modified_by_user AS modified_by_user6, m0_.checked_out AS checked_out7, m0_.checked_out_by AS checked_out_by8, m0_.checked_out_by_user AS checked_out_by_user9, m0_.id AS id10, m0_.redirect_id AS redirect_id11, m0_.url AS url12, m0_.hits AS hits13, m0_.unique_hits AS unique_hits14, m0_.email_id AS email_id15 FROM ma_page_redirects m0_ WHERE m0_.url IN (?) AND m0_.email_id IS NULL’ with params [“http://swgins.com/”]:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m0_.email_id’ in ‘field list’ at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m0_.email_id’ in ‘field list’ at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)"} []

Hello kind folks,

I’m having an issue were I can’t send emails. Below is my error log. Can anybody help me shine some light on this?

[2016-06-03 00:13:21] mautic.NOTICE: PHP Notice: Array to string conversion - in file /opt/bitnami/apps/mautic/htdocs/app/bundles/CoreBundle/Helper/InputHelper.php - at line 266 [] []
[2016-06-03 00:15:50] mautic.NOTICE: PHP Notice: Array to string conversion - in file /opt/bitnami/apps/mautic/htdocs/app/bundles/CoreBundle/Helper/InputHelper.php - at line 266 [] []

[2016-06-03 00:20:03] mautic.ERROR: DoctrineDBALDBALException: An exception occurred while executing ‘INSERT INTO ma_page_redirects (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, redirect_id, url, hits, unique_hits, email_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2016-06-03 00:20:03”, null, null, null, null, null, null, null, null, “e489f4c5621070d834ace156d”, “http://swgins.com/”, 0, 0, null]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘email_id’ in ‘field list’ (uncaught exception) at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 while running console command mautic:campaigns:trigger [] []

[2016-06-03 00:44:57] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT m0_.is_published AS is_published0, m0_.date_added AS date_added1, m0_.created_by AS created_by2, m0_.created_by_user AS created_by_user3, m0_.date_modified AS date_modified4, m0_.modified_by AS modified_by5, m0_.modified_by_user AS modified_by_user6, m0_.checked_out AS checked_out7, m0_.checked_out_by AS checked_out_by8, m0_.checked_out_by_user AS checked_out_by_user9, m0_.id AS id10, m0_.redirect_id AS redirect_id11, m0_.url AS url12, m0_.hits AS hits13, m0_.unique_hits AS unique_hits14, m0_.email_id AS email_id15 FROM ma_page_redirects m0_ WHERE m0_.url IN (?) AND m0_.email_id IS NULL’ with params [“http://swgins.com/”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m0_.email_id’ in ‘field list’” at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT m0_.is_published AS is_published0, m0_.date_added AS date_added1, m0_.created_by AS created_by2, m0_.created_by_user AS created_by_user3, m0_.date_modified AS date_modified4, m0_.modified_by AS modified_by5, m0_.modified_by_user AS modified_by_user6, m0_.checked_out AS checked_out7, m0_.checked_out_by AS checked_out_by8, m0_.checked_out_by_user AS checked_out_by_user9, m0_.id AS id10, m0_.redirect_id AS redirect_id11, m0_.url AS url12, m0_.hits AS hits13, m0_.unique_hits AS unique_hits14, m0_.email_id AS email_id15 FROM ma_page_redirects m0_ WHERE m0_.url IN (?) AND m0_.email_id IS NULL’ with params [“http://swgins.com/”]:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m0_.email_id’ in ‘field list’ at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘m0_.email_id’ in ‘field list’ at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)"} []

@escopecz any idea on this? I would greatly appreciate your input.

Thanks @MxyzptlkFishStix . Unfortunately I tried that but did not help. I ended up starting from scratch. Fortunately, I had to migrate the instance to another place, so I just started from scratch. Thank you for your help.