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.