Your software My Mautic version is: 4.2.1 My PHP version is: 7.4 My Database type and version is: mariadb 10.04 Your problem My problem is: When trying to add a new custom field I am getting an error These errors are showing in the log: An exception occurred while executing 'ALTER TABLE lead…

WOW. Okay so this is what I did. I think that the culprit of all these bad database issues is the generated_email_domain column that I have not idea who puts in there or who is using it, but I went and dropped this table, then I was able to add more custom fields and also drop other unwanted colum…

Cannot Create New Custom Fields. SQLSTATE[42S22] Error

Product Support

mikew May 9, 2022, 12:51pm 11

HI @escopecz

thanks for the reply. Yes I definitely have the email column in the leads table.

Strange SQL Error when trying to create new custom field

Topic		Replies	Views
Strange SQL Error when trying to create new custom field Product Support	2	454	May 20, 2022
Unable to create new custom field Product Support mautic-4	0	182	December 1, 2022
Cannot create custom fields Product Support	12	534	May 23, 2023
Can't add additional custom fields --- Alter Table Error Product Support mautic-4	2	697	August 14, 2022
Error when deleting a custom field Product Support	0	354	December 22, 2020

Cannot Create New Custom Fields. SQLSTATE[42S22] Error

Related topics