Problem with last version 4

[rogerio-pereira]

Issue on mautic/mautic repository https://github.com/mautic/mautic/issues/11446

Using Docker-compose Image mautic/mautic:v4 The problem happens when running migrations:

1. with flag MAUTIC_RUN_MIGRATIONS=true on docker-compose
2. or without the flag when setting up database in mautic (first screen on web installer)

In AbstractMySQLDriver.php line 79:

  An exception occurred while executing 'ALTER TABLE leads ADD generated_emai
  l_domain VARCHAR(255) AS (SUBSTRING(email, LOCATE("@", email) + 1)) COMMENT
   '(DC2Type:generated)';
              ALTER TABLE leads ADD INDEX `generated_email_domain`(generated_
  email_domain)':

  SQLSTATE[42S22]: Column not found: 1054 Unknown column '@' in 'generated co
  lumn function'


In Exception.php line 18:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column '@' in 'generated co
  lumn function'


In PDOConnection.php line 141:

  SQLSTATE[42S22]: Column not found: 1054 Unknown column '@' in 'generated co
  lumn function'