Mautic Community Forums

Unable to access certain parts of Mautic after upgrade to 3.3.4

Your software
My Mautic version is: 3.3.4
My PHP version is: 7.3.31
My Database type and version is: MySQL (sorry not sure of version)

Your problem
My problem is: I am unable to access certain pages (e.g. emails, contacts) after upgrading Mautic.

These errors are showing in the log:

[2021-10-07 11:13:45] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’” at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}
[2021-10-07 11:14:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’” at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}
[2021-10-07 11:14:06] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’” at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}
[2021-10-07 11:14:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’” at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.label AS label_11, l0_.alias AS alias_12, l0_.type AS type_13, l0_.field_group AS field_group_14, l0_.default_value AS default_value_15, l0_.is_required AS is_required_16, l0_.is_fixed AS is_fixed_17, l0_.is_visible AS is_visible_18, l0_.is_short_visible AS is_short_visible_19, l0_.is_listable AS is_listable_20, l0_.is_publicly_updatable AS is_publicly_updatable_21, l0_.is_unique_identifer AS is_unique_identifer_22, l0_.field_order AS field_order_23, l0_.object AS object_24, l0_.properties AS properties_25, l0_.column_is_not_created AS column_is_not_created_26, l0_.original_is_published_value AS original_is_published_value_27 FROM lead_fields l0_ WHERE l0_.is_published = ? AND l0_.object = ? ORDER BY l0_.field_order ASC’ with params [1, “lead”]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.column_is_not_created’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}
[2021-10-07 11:14:14] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.name AS name_11, l0_.description AS description_12, l0_.alias AS alias_13, l0_.public_name AS public_name_14, l0_.filters AS filters_15, l0_.is_global AS is_global_16, l0_.is_preference_center AS is_preference_center_17 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.name ASC) dctrn_result) dctrn_table’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.public_name’ in ‘field list’" at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.name AS name_11, l0_.description AS description_12, l0_.alias AS alias_13, l0_.public_name AS public_name_14, l0_.filters AS filters_15, l0_.is_global AS is_global_16, l0_.is_preference_center AS is_preference_center_17 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.name ASC) dctrn_result) dctrn_table’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.public_name’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.public_name’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.public_name’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)”}
[2021-10-07 11:14:19] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT f0_.is_published AS is_published_0, f0_.date_added AS date_added_1, f0_.created_by AS created_by_2, f0_.created_by_user AS created_by_user_3, f0_.date_modified AS date_modified_4, f0_.modified_by AS modified_by_5, f0_.modified_by_user AS modified_by_user_6, f0_.checked_out AS checked_out_7, f0_.checked_out_by AS checked_out_by_8, f0_.checked_out_by_user AS checked_out_by_user_9, f0_.id AS id_10, f0_.name AS name_11, f0_.description AS description_12, f0_.alias AS alias_13, f0_.form_attr AS form_attr_14, f0_.cached_html AS cached_html_15, f0_.post_action AS post_action_16, f0_.post_action_property AS post_action_property_17, f0_.publish_up AS publish_up_18, f0_.publish_down AS publish_down_19, f0_.template AS template_20, f0_.in_kiosk_mode AS in_kiosk_mode_21, f0_.render_style AS render_style_22, f0_.form_type AS form_type_23, f0_.no_index AS no_index_24, f0_.progressive_profiling_limit AS progressive_profiling_limit_25, (SELECT count(f1_.id) AS sclr_27 FROM form_submissions f1_ WHERE f1_.form_id = f0_.id) AS sclr_26 FROM forms f0_ LEFT JOIN categories c2_ ON f0_.category_id = c2_.id ORDER BY f0_.name ASC) dctrn_result) dctrn_table’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘f0_.progressive_profiling_limit’ in ‘field list’" at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT f0_.is_published AS is_published_0, f0_.date_added AS date_added_1, f0_.created_by AS created_by_2, f0_.created_by_user AS created_by_user_3, f0_.date_modified AS date_modified_4, f0_.modified_by AS modified_by_5, f0_.modified_by_user AS modified_by_user_6, f0_.checked_out AS checked_out_7, f0_.checked_out_by AS checked_out_by_8, f0_.checked_out_by_user AS checked_out_by_user_9, f0_.id AS id_10, f0_.name AS name_11, f0_.description AS description_12, f0_.alias AS alias_13, f0_.form_attr AS form_attr_14, f0_.cached_html AS cached_html_15, f0_.post_action AS post_action_16, f0_.post_action_property AS post_action_property_17, f0_.publish_up AS publish_up_18, f0_.publish_down AS publish_down_19, f0_.template AS template_20, f0_.in_kiosk_mode AS in_kiosk_mode_21, f0_.render_style AS render_style_22, f0_.form_type AS form_type_23, f0_.no_index AS no_index_24, f0_.progressive_profiling_limit AS progressive_profiling_limit_25, (SELECT count(f1_.id) AS sclr_27 FROM form_submissions f1_ WHERE f1_.form_id = f0_.id) AS sclr_26 FROM forms f0_ LEFT JOIN categories c2_ ON f0_.category_id = c2_.id ORDER BY f0_.name ASC) dctrn_result) dctrn_table’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘f0_.progressive_profiling_limit’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘f0_.progressive_profiling_limit’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘f0_.progressive_profiling_limit’ in ‘field list’ at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)”}
[2021-10-07 10:15:01] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘SELECT l0_.is_published AS is_published_0, l0_.date_added AS date_added_1, l0_.created_by AS created_by_2, l0_.created_by_user AS created_by_user_3, l0_.date_modified AS date_modified_4, l0_.modified_by AS modified_by_5, l0_.modified_by_user AS modified_by_user_6, l0_.checked_out AS checked_out_7, l0_.checked_out_by AS checked_out_by_8, l0_.checked_out_by_user AS checked_out_by_user_9, l0_.id AS id_10, l0_.name AS name_11, l0_.description AS description_12, l0_.alias AS alias_13, l0_.public_name AS public_name_14, l0_.filters AS filters_15, l0_.is_global AS is_global_16, l0_.is_preference_center AS is_preference_center_17, l0_.category_id AS category_id_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.name ASC’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.public_name’ in ‘field list’ (uncaught exception) at /var/www/vhosts/schoolsupport.org.uk/httpdocs/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 while running console command mautic:segments:update
[2021-10-07 10:15:01] mautic.WARNING: Command mautic:segments:update exited with status code 1

Steps I have tried to fix the problem: none yet as not sure what to do.

I have just tried visiting my-mautic-url/s/update/schema, but it has returned a message to say that the database schema is already up to date.

when you try go to one of the links (emails/contacts) inspect the page and have a look in console.

You can always just try and chown -R www-data:www-data /var/www/mautic/

Thanks Mike. It seems to have come back to life in another browser, so perhaps it was just a cacheing issue.

1 Like