Your software Mautic version v4.4.0 -Litespeed 1.71.6
My PHP version is : 7.4.2
My MySQL/MariaDB version is 10.4.25-MariaDB
Updating/Installing Errors
*I installed mautic
These errors are showing in the Mautic log :[2022-07-27 02:07:28] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2022-07-27 02:07:28”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing 'INSERT INTO leads (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_ounull, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing 'INSERT INTO leads (from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2022-07-27 02:07:35", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nSQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 02:07:35] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing 'INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?,storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 02:07:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2022-07-27 02:07:36”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2022-07-27 02:07:36", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nSQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 02:07:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2022-07-27 02:07:36”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2022-07-27 02:07:36", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nSQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 02:07:36] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2022-07-27 02:07:36”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2022-07-27 02:07:36", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nSQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 02:07:37] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 02:07:37] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2022-07-27 02:07:37”, null, null, null, null, null, null, null, null, 0, null, “a:0:{}”, “a:0:{}”, null, “gravatar”, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2022-07-27 02:07:37", null, null, null, null, null, null, null, null, 0, null, "a:0:{}", "a:0:{}", null, "gravatar", null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]:\n\nSQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1467 Failed to read auto-increment value from storage engine at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:523396}
[2022-07-27 06:24:58] 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, l0_.last_built_date AS last_built_date_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.date_modified DESC) dctrn_result) dctrn_table’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’" at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“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, l0_.last_built_date AS last_built_date_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.date_modified DESC) dctrn_result) dctrn_table’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”} {“hostname”:“pedicel-vps.server”,“pid”:529921}
[2022-07-27 11:35:18] 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, l0_.last_built_date AS last_built_date_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.date_modified DESC) dctrn_result) dctrn_table’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’" at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“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, l0_.last_built_date AS last_built_date_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.date_modified DESC) dctrn_result) dctrn_table’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”} {“hostname”:“pedicel-vps.server”,“pid”:537063}
[2022-07-27 11:35:43] 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, l0_.last_built_date AS last_built_date_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.date_modified DESC) dctrn_result) dctrn_table’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’" at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“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, l0_.last_built_date AS last_built_date_18 FROM lead_lists l0_ LEFT JOIN categories c1_ ON l0_.category_id = c1_.id ORDER BY l0_.date_modified DESC) dctrn_result) dctrn_table’:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0_.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)”} {“hostname”:“pedicel-vps.server”,“pid”:537078}
[2022-07-27 11:38:58] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.is_published AS is_published_1, t0.date_added AS date_added_2, t0.created_by AS created_by_3, t0.created_by_user AS created_by_user_4, t0.date_modified AS date_modified_5, t0.modified_by AS modified_by_6, t0.modified_by_user AS modified_by_user_7, t0.checked_out AS checked_out_8, t0.checked_out_by AS checked_out_by_9, t0.checked_out_by_user AS checked_out_by_user_10, t0.id AS id_11, t0.name AS name_12, t0.description AS description_13, t0.alias AS alias_14, t0.public_name AS public_name_15, t0.filters AS filters_16, t0.is_global AS is_global_17, t0.is_preference_center AS is_preference_center_18, t0.last_built_date AS last_built_date_19, t0.category_id AS category_id_20 FROM lead_lists t0 WHERE t0.id = ?’ with params [6]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last_built_date’ in ‘field list’” at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {“exception”:“[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.is_published AS is_published_1, t0.date_added AS date_added_2, t0.created_by AS created_by_3, t0.created_by_user AS created_by_user_4, t0.date_modified AS date_modified_5, t0.modified_by AS modified_by_6, t0.modified_by_user AS modified_by_user_7, t0.checked_out AS checked_out_8, t0.checked_out_by AS checked_out_by_9, t0.checked_out_by_user AS checked_out_by_user_10, t0.id AS id_11, t0.name AS name_12, t0.description AS description_13, t0.alias AS alias_14, t0.public_name AS public_name_15, t0.filters AS filters_16, t0.is_global AS is_global_17, t0.is_preference_center AS is_preference_center_18, t0.last_built_date AS last_built_date_19, t0.category_id AS category_id_20 FROM lead_lists t0 WHERE t0.id = ?’ with params [6]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\DBAL\Driver\PDO\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.last_built_date’ in ‘field list’ at /home/crmpedicel.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“pedicel-vps.server”,“pid”:537155}
My problem is : i installed mautic via cyberpanel on a vps host, but the segment tab and i can’t also save campaigns
Steps I have tried to fix the problem :
i have deleted the cache