# Unknown column 't0.public\_name' in 'field list'

**URL:** <https://forum.mautic.org/t/unknown-column-t0-public-name-in-field-list/18512>\
**Category:** Product Support\
**Created:** [March 10, 2021, 9:01am UTC](https://forum.mautic.org/t/unknown-column-t0-public-name-in-field-list/18512 "2021-03-10T09:01:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lctang](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lctang/32/1414_2.png) [@lctang](https://forum.mautic.org/u/lctang)\
**Post date:** [March 10, 2021, 9:01am UTC](https://forum.mautic.org/t/unknown-column-t0-public-name-in-field-list/18512/1 "2021-03-10T09:01:45Z")

</div>

**Your software**  
My Mautic version is: 3.2.5  
My PHP version is: 7.4.15  
My Database type and version is: mysqlnd 7.4.15

**Your problem**  
My problem is: When I click on “new campaign” → “launch campaign builder” → add sth inside → close campaign builder, it shows internal server error with code 500.

These errors are showing in the log:  
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 FROM maulj\_lead\_lists t0 WHERE t0.id = ?’ with params [1]: Unknown column ‘t0.public\_name’ in ‘field list’” at /home/holisti3/email.prohealth.guide/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 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 FROM maulj\_lead\_lists t0 WHERE t0.id = ?’ with params [1]:\n\nUnknown column ‘t0.public\_name’ in ‘field list’ at /home/holisti3/email.prohealth.guide/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t0.public\_name’ in ‘field list’ at /home/holisti3/email.prohealth.guide/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}

Steps I have tried to fix the problem:  
I guess I’m missing something from my MySQL database (because “Unknown column ‘t0.public\_name’ in ‘field list’” in error log), would like to know how should I get my MySQL database right.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [March 10, 2021, 11:53am UTC](https://forum.mautic.org/t/unknown-column-t0-public-name-in-field-list/18512/2 "2021-03-10T11:53:56Z")

</div>

Hi,  
What is the public name of that segment you are using?  
Thx,  
J