# Error 500 on creating a new email **URL:** \ **Category:** Product Support\ **Created:** [July 21, 2015, 6:17am UTC](https://forum.mautic.org/t/error-500-on-creating-a-new-email/1445 "2015-07-21T06:17:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)\ **Post date:** [July 21, 2015, 6:17am UTC](https://forum.mautic.org/t/error-500-on-creating-a-new-email/1445/1 "2015-07-21T06:17:30Z")
I’ve just updated to Mautic 1.1.3. I’m not entirely sure the update ran succesfull although Mautic said it has. When trying to create a new e-mail in mautic I get an error 500. This error might have been around since before the update to 1.1.3, I’m not sure. The error log states the following: Code: [2015-07-21 07:11:29] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: "An exception occurred while executing 'SELECT COUNT(\*) AS dctrn\_count FROM (SELECT DISTINCT id10 FROM (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\_.title AS title11, m0\_.alias AS alias12, m0\_.template AS template13, m0\_.lang AS lang14, m0\_.custom\_html AS custom\_html15, m0\_.content AS content16, m0\_.publish\_up AS publish\_up17, m0\_.publish\_down AS publish\_down18, m0\_.hits AS hits19, m0\_.unique\_hits AS unique\_hits20, m0\_.variant\_hits AS variant\_hits21, m0\_.revision AS revision22, m0\_.meta\_description AS meta\_description23, m0\_.redirect\_type AS redirect\_type24, m0\_.redirect\_url AS redirect\_url25, m0\_.variant\_settings AS variant\_settings26, m0\_.variant\_start\_date AS variant\_start\_date27 FROM maroc1\_pages m0\_ LEFT JOIN maroc1\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL ORDER BY m0\_.title ASC) dctrn\_result) dctrn\_table': Unknown column 'm0\_.redirect\_type' in 'field list'" at /var/www/vhosts/roc-nijmegen.nl/httpdocs/mautic.mydomain.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {"exception":"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing 'SELECT COUNT(\*) AS dctrn\_count FROM (SELECT DISTINCT id10 FROM (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\_.title AS title11, m0\_.alias AS alias12, m0\_.template AS template13, m0\_.lang AS lang14, m0\_.custom\_html AS custom\_html15, m0\_.content AS content16, m0\_.publish\_up AS publish\_up17, m0\_.publish\_down AS publish\_down18, m0\_.hits AS hits19, m0\_.unique\_hits AS unique\_hits20, m0\_.variant\_hits AS variant\_hits21, m0\_.revision AS revision22, m0\_.meta\_description AS meta\_description23, m0\_.redirect\_type AS redirect\_type24, m0\_.redirect\_url AS redirect\_url25, m0\_.variant\_settings AS variant\_settings26, m0\_.variant\_start\_date AS variant\_start\_date27 FROM maroc1\_pages m0\_ LEFT JOIN maroc1\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL ORDER BY m0\_.title ASC) dctrn\_result) dctrn\_table':nnUnknown column 'm0\_.redirect\_type' in 'field list' at /var/www/vhosts/roc-nijmegen.nl/httpdocs/mautic.mydomain.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 1054): Unknown column 'm0\_.redirect\_type' in 'field list' at /var/www/vhosts/roc-nijmegen.nl/httpdocs/mautic.mydomain.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} [] ---
**Author:** ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)\ **Post date:** [July 21, 2015, 6:28am UTC](https://forum.mautic.org/t/error-500-on-creating-a-new-email/1445/2 "2015-07-21T06:28:12Z")
Never mind. Fixed by reading this git issue: [https://github.com/mautic/mautic/issues/303](https://github.com/mautic/mautic/issues/303) [quote]… You can try running from the command line, ```auto php app/console doctrine:migrations:migrate --env=prod ``` ---
**Author:** ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)\ **Post date:** [July 21, 2015, 6:17am UTC](https://forum.mautic.org/t/error-500-on-creating-a-new-email/1445/3 "2015-07-21T06:17:30Z")
I’ve just updated to Mautic 1.1.3. I’m not entirely sure the update ran succesfull although Mautic said it has. When trying to create a new e-mail in mautic I get an error 500. This error might have been around since before the update to 1.1.3, I’m not sure. The error log states the following: ```auto [2015-07-21 07:11:29] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: "An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id10 FROM (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_.title AS title11, m0_.alias AS alias12, m0_.template AS template13, m0_.lang AS lang14, m0_.custom_html AS custom_html15, m0_.content AS content16, m0_.publish_up AS publish_up17, m0_.publish_down AS publish_down18, m0_.hits AS hits19, m0_.unique_hits AS unique_hits20, m0_.variant_hits AS variant_hits21, m0_.revision AS revision22, m0_.meta_description AS meta_description23, m0_.redirect_type AS redirect_type24, m0_.redirect_url AS redirect_url25, m0_.variant_settings AS variant_settings26, m0_.variant_start_date AS variant_start_date27 FROM maroc1_pages m0_ LEFT JOIN maroc1_categories m1_ ON m0_.category_id = m1_.id WHERE m0_.variant_parent_id IS NULL ORDER BY m0_.title ASC) dctrn_result) dctrn_table': Unknown column 'm0_.redirect_type' in 'field list'" at /var/www/vhosts/roc-nijmegen.nl/httpdocs/mautic.mydomain.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {"exception":"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id10 FROM (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_.title AS title11, m0_.alias AS alias12, m0_.template AS template13, m0_.lang AS lang14, m0_.custom_html AS custom_html15, m0_.content AS content16, m0_.publish_up AS publish_up17, m0_.publish_down AS publish_down18, m0_.hits AS hits19, m0_.unique_hits AS unique_hits20, m0_.variant_hits AS variant_hits21, m0_.revision AS revision22, m0_.meta_description AS meta_description23, m0_.redirect_type AS redirect_type24, m0_.redirect_url AS redirect_url25, m0_.variant_settings AS variant_settings26, m0_.variant_start_date AS variant_start_date27 FROM maroc1_pages m0_ LEFT JOIN maroc1_categories m1_ ON m0_.category_id = m1_.id WHERE m0_.variant_parent_id IS NULL ORDER BY m0_.title ASC) dctrn_result) dctrn_table':nnUnknown column 'm0_.redirect_type' in 'field list' at /var/www/vhosts/roc-nijmegen.nl/httpdocs/mautic.mydomain.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 1054): Unknown column 'm0_.redirect_type' in 'field list' at /var/www/vhosts/roc-nijmegen.nl/httpdocs/mautic.mydomain.nl/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:89)"} [] ``` ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [February 2, 2020, 10:59pm UTC](https://forum.mautic.org/t/error-500-on-creating-a-new-email/1445/4 "2020-02-02T22:59:09Z")