My Mautic version is: v2.16.2
My PHP version is 7.1.33 :
My MySQL/MariaDB version is (delete as applicable): MariaDB 10.1
I click on “Landing Pages”.
These errors are showing at the website :
Nothing happens, I can’t go to this section. The rest of sections work properly.
Log of Mautic:
[2020-08-04 11:13:32] 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 i0_.is_published AS is_published_0, i0_.date_added AS date_added_1, i0_.created_by AS created_by_2, i0_.created_by_user AS created_by_user_3, i0_.date_modified AS date_modified_4, i0_.modified_by AS modified_by_5, i0_.modified_by_user AS modified_by_user_6, i0_.checked_out AS checked_out_7, i0_.checked_out_by AS checked_out_by_8, i0_.checked_out_by_user AS checked_out_by_user_9, i0_.id AS id_10, i0_.title AS title_11, i0_.alias AS alias_12, i0_.template AS template_13, i0_.custom_html AS custom_html_14, i0_.content AS content_15, i0_.publish_up AS publish_up_16, i0_.publish_down AS publish_down_17, i0_.hits AS hits_18, i0_.unique_hits AS unique_hits_19, i0_.variant_hits AS variant_hits_20, i0_.revision AS revision_21, i0_.meta_description AS meta_description_22, i0_.redirect_type AS redirect_type_23, i0_.redirect_url AS redirect_url_24, i0_.is_preference_center AS is_preference_center_25, i0_.no_index AS no_index_26, i0_.lang AS lang_27, i0_.variant_settings AS variant_settings_28, i0_.variant_start_date AS variant_start_date_29 FROM inb_pages i0_ LEFT JOIN inb_categories i1_ ON i0_.category_id = i1_.id WHERE i0_.variant_parent_id IS NULL AND i0_.translation_parent_id IS NULL ORDER BY i0_.title DESC) dctrn_result) dctrn_table’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘i0_.no_index’ in ‘field list’" at /home/inbautenticonuevayork/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“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 i0_.is_published AS is_published_0, i0_.date_added AS date_added_1, i0_.created_by AS created_by_2, i0_.created_by_user AS created_by_user_3, i0_.date_modified AS date_modified_4, i0_.modified_by AS modified_by_5, i0_.modified_by_user AS modified_by_user_6, i0_.checked_out AS checked_out_7, i0_.checked_out_by AS checked_out_by_8, i0_.checked_out_by_user AS checked_out_by_user_9, i0_.id AS id_10, i0_.title AS title_11, i0_.alias AS alias_12, i0_.template AS template_13, i0_.custom_html AS custom_html_14, i0_.content AS content_15, i0_.publish_up AS publish_up_16, i0_.publish_down AS publish_down_17, i0_.hits AS hits_18, i0_.unique_hits AS unique_hits_19, i0_.variant_hits AS variant_hits_20, i0_.revision AS revision_21, i0_.meta_description AS meta_description_22, i0_.redirect_type AS redirect_type_23, i0_.redirect_url AS redirect_url_24, i0_.is_preference_center AS is_preference_center_25, i0_.no_index AS no_index_26, i0_.lang AS lang_27, i0_.variant_settings AS variant_settings_28, i0_.variant_start_date AS variant_start_date_29 FROM inb_pages i0_ LEFT JOIN inb_categories i1_ ON i0_.category_id = i1_.id WHERE i0_.variant_parent_id IS NULL AND i0_.translation_parent_id IS NULL ORDER BY i0_.title DESC) dctrn_result) dctrn_table’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘i0_.no_index’ in ‘field list’ at /home/inbautenticonuevayork/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘i0_.no_index’ in ‘field list’ at /home/inbautenticonuevayork/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘i0_.no_index’ in ‘field list’ at /home/inbautenticonuevayork/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)”}