My Mautic version is: 4.1.2
My PHP version is: 7.4
My Database type and version is: mySQL 8.0.27
This is a general problem. I had to restore the database from standard mySQL backup and it fails
The hosting company has restored it but sent this message (google translated from Spanish)
Currently the import of the backup has been able to be completed by the administrators. However, they inform us that until the error related to “GENERATED” columns on MySQL is solved, it will not be possible to carry out this type of exceptional imports.
Therefore, before executing a database export, we recommend that you check the database from PHPMyAdmin to edit those types of columns.
And these are the changes they have proposed in the Mautic DB structure
*sed -i ‘s/(
generated_sent_date date).+/\1,/’ dump.sql
**sed -i ‘s/(
generated_email_domain varchar(255)).+/\1,/’ dump.sql
I think this need to be changed to avoid restore problems