Mautic Community Forums

Error 500 on creating a new email

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)"} []

Never mind. Fixed by reading this git issue:
https://github.com/mautic/mautic/issues/303

[quote]… You can try running from the command line,

php app/console doctrine:migrations:migrate --env=prod

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:

[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)"} []