search

mautic / docker-mautic

Docker Image for Mautic
https://www.mautic.org
362 stars 274 forks source link

Problem with last version 4 #234

Closed rogerio-pereira closed 1 year ago

rogerio-pereira commented 2 years ago

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'
rogerio-pereira commented 1 year ago

Closed, the problem was using an external Mysql (external to Docker Container). Also Mysql version was 8, which seem to have an incompatibility with Mautic