# Segment Tab doesn't Open and i can't save campaigns

**URL:** <https://forum.mautic.org/t/segment-tab-doesnt-open-and-i-cant-save-campaigns/24893>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [July 27, 2022, 2:05pm UTC](https://forum.mautic.org/t/segment-tab-doesnt-open-and-i-cant-save-campaigns/24893 "2022-07-27T14:05:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![darey](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/darey/32/6497_2.png) [@darey](https://forum.mautic.org/u/darey)\
**Post date:** [July 27, 2022, 2:05pm UTC](https://forum.mautic.org/t/segment-tab-doesnt-open-and-i-cant-save-campaigns/24893/1 "2022-07-27T14:05:04Z")

</div>

**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}

 ![mautic](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/1/1ef41ada7d340462971e7791764bc43b8b0e790a.png)

_My problem is_ : i installed mautic via cyberpanel on a vps host, but the segment tab and i can’t also save campaigns

 ![mautic](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/1/1ef41ada7d340462971e7791764bc43b8b0e790a.png)

_Steps I have tried to fix the problem_ :  
i have deleted the cache

---

<div class="post-metadata">

**Author:** ![techbill](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/techbill/32/8325_2.png) [@techbill](https://forum.mautic.org/u/techbill)\
**Post date:** [July 27, 2022, 2:40pm UTC](https://forum.mautic.org/t/segment-tab-doesnt-open-and-i-cant-save-campaigns/24893/2 "2022-07-27T14:40:44Z")

</div>

Cyberpanel uses it own customized web server. It’s possible it’s not playing nicely with Mautic.

---

<div class="post-metadata">

**Author:** ![darey](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/darey/32/6497_2.png) [@darey](https://forum.mautic.org/u/darey)\
**Post date:** [July 27, 2022, 3:48pm UTC](https://forum.mautic.org/t/segment-tab-doesnt-open-and-i-cant-save-campaigns/24893/3 "2022-07-27T15:48:43Z")

</div>

hello,

Pls what would you suggest as a solution…i have been able to create contacts…the issue is with saving campaigns and opening segment
