I was attempting to migrate from mautic 3.x to mautic 4.x using the update in the web console. That didn’t complete. So I dropped down and performed the steps outlined here - Mautic update failed - how to recover | Mautic
This is where I am stuck:
autopilot.coolreturns.ca > php bin/console doctrine:migration:migrate
++ adding generated column generated_email_domain
→ ALTER TABLE mauo1la_leads ADD generated_email_domain VARCHAR(255) AS (SUBSTRING(email, LOCATE("@", email) + 1)) COMMENT ‘(DC2Type:generated)’;
ALTER TABLE mauo1la_leads ADD INDEX mauo1la_generated_email_domain
(generated_email_domain)
In AbstractMySQLDriver.php line 98:
An exception occurred while executing ‘ALTER TABLE mauo1la_leads ADD generated_email_domain VARCHAR(255) AS (SUBSTRING(email, LOCATE("@", email) + 1
)) COMMENT ‘(DC2Type:generated)’;
ALTER TABLE mauo1la_leads ADD INDEX mauo1la_generated_email_domain
(generated_email_domain)’:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE m
auo1la_leads ADD INDEX mauo1la_generated_email_domain
(generated_e’ at line 2
In ConnectionError.php line 21:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ALTER TABLE m
auo1la_leads ADD INDEX mauo1la_generated_email_domain
(generated_e’ at line 2
doctrine:migrations:migrate [–write-sql [WRITE-SQL]] [–dry-run] [–query-time] [–allow-no-migration] [–all-or-nothing [ALL-OR-NOTHING]] [–configuration [CONFIGURATION]] [–db-configuration [DB-CONFIGURATION]] [–db DB] [–em EM] [–shard SHARD] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–] []
What do I do to resolve this?