Strange Issue with Upgrading from 3.2.4 to 4.1.0

Product Support Mautic 4 Install/Upgrade Support
6

So happy days. Thanks to two main factors:

  1. @rcheesley initial suggestion and
  2. I contacted a development house that often pastes here - I won’t mention any names and was quoted 40 hours to fix the problem which would equate to $720!!

So how did I fix it ?

First I did everything above, then I went and ran the following command:

sudo -u www-data php /var/www/mautic/bin/console doctrine:migration:migrate

Which provided me with a detailed output:

image
image1557×385 137 KB

I then went and searched the mautic directory for where the code is calling this “generated_email_domain”

grep -R "generated_email" /var/www/mautic/*

And was provided with the file that is taking care of this call
/var/www/mautic/app/bundles/LeadBundle/EventListener/GeneratedColumnSubscriber.php: ‘generated_email_domain’

I then went and made a backup of the file GeneratedColumnSubscriber.php and then went into the file to edit it.
NOTE: I am not a developer, but I know how to read, and that’s all you really need to know :slight_smile:

On Line 43 of this file is the problem (and this is where Ruth’s suggestion did the trick)

40         $emailDomain = new GeneratedColumn(
 41             'leads',
 42             'generated_email_domain',
 43             'VARCHAR(255)',
 44             'SUBSTRING(email, LOCATE("@", email) + 1)'

I went and changed VARCHAR to TEXT, saved the file and re-ran the doctrine migrate

sudo -u www-data php /var/www/mautic/bin/console doctrine:migration:migrate

And like magic it all worked well!!

All in all I think this exercise took about 4 hours or my time. It is proof of the strength of the community and the want for people to support and help each other!!

So a big thanks to @rcheesley for initial suggestion

2 Likes