Strange SQL Error when trying to create new custom field

Your software
My Mautic version is: 4.1.0
My PHP version is: 7.4
My Database type and version is: mariadb 10.3

Your problem
My problem is:
I am unable to create new custom fields, I know one issue is it is telling me sometimes that I have reached my limit and now I am getting an error

These errors are showing in the log:

[2021-12-23 09:13:21] mautic.WARNING: An exception occurred while executing 'ALTER TABLE leads ADD newtest VARCHAR(255) DEFAULT NULL':  SQLSTATE[42S22]: Column not found: 1054 Unknown column '`mautic`.`l`.`email`' in 'GENERATED ALWAYS' [] []
[2021-12-23 09:13:34] mautic.WARNING: An exception occurred while executing 'ALTER TABLE leads ADD newtest VARCHAR(255) DEFAULT NULL':  SQLSTATE[42S22]: Column not found: 1054 Unknown column '`mautic`.`l`.`email`' in 'GENERATED ALWAYS' [] []

Steps I have tried to fix the problem:
Nothing yet

I am also experiencing this issue with Mautic 4.2.2

Here’s my error when trying to create a select-multiple custom field:

 An exception occurred while executing 'ALTER TABLE leads ADD vol_type VARCHAR(255) DEFAULT NULL': SQLSTATE[42S22]: Column not found: 1054 Unknown column '`XXXXX`.`l`.`email`' in 'GENERATED ALWAYS' 

For other googlers, I found a solution here: Cannot Create New Custom Fields. SQLSTATE[42S22] Error - #11 by mikew

  1. Run alter table leads drop column generated_email_domain
  2. Re-run migrations: php bin/console doctrine:migration:migrate
1 Like