# Unsuccessful 2.9 update
**URL:** https://forum.mautic.org/t/unsuccessful-2-9-update/9024
**Category:** Product Support
**Created:** [July 21, 2017, 9:01pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024 "2017-07-21T21:01:18Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [July 21, 2017, 9:01pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/1 "2017-07-21T21:01:18Z")
Given that I am having so many bugs right now, I figured i’d try and update to 2.9 and hopefully that update would remedy some of my issues:
Instead, the upgrade didnt happen properly and I got this error message:
[2017-07-21 17:56:37] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command `doctrine:migrations:migrate` [] []
[2017-07-21 17:56:37] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations Migrating up to 20170628191405 from 20160225000000 SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160615000000 -\> DROP INDEX MAP2q\_email\_date\_read ON MAP2q\_email\_stats -\> CREATE INDEX MAP2q\_email\_date\_read ON MAP2q\_email\_stats (date\_read) ++ migrated (0.55s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160712000000 -\> UPDATE MAP2q\_lead\_fields SET properties = ‘a:2:{s:9:“roundmode”;s:1:“4”;s:9:“precision”;s:1:“2”;}’ WHERE alias = ‘attribution’ ++ migrated (0.45s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160720000000 -\> DELETE FROM MAP2q\_lead\_utmtags WHERE utm\_campaign is null and utm\_content is null and utm\_medium is null and utm\_source is null and utm\_term is null ++ migrated (0.47s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160726000001 -\> ALTER TABLE MAP2q\_emails DROP FOREIGN KEY FK\_332899E39091A2FB -\> ALTER TABLE MAP2q\_emails ADD CONSTRAINT FK\_332899E39091A2FB FOREIGN KEY (translation\_parent\_id) REFERENCES MAP2q\_emails (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_emails DROP FOREIGN KEY FK\_332899E391861123 -\> ALTER TABLE MAP2q\_emails ADD CONSTRAINT FK\_332899E391861123 FOREIGN KEY (variant\_parent\_id) REFERENCES MAP2q\_emails (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_pages DROP FOREIGN KEY FK\_E308EF399091A2FB -\> ALTER TABLE MAP2q\_pages ADD CONSTRAINT FK\_E308EF399091A2FB FOREIGN KEY (translation\_parent\_id) REFERENCES MAP2q\_pages (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_pages DROP FOREIGN KEY FK\_E308EF3991861123 -\> ALTER TABLE MAP2q\_pages ADD CONSTRAINT FK\_E308EF3991861123 FOREIGN KEY (variant\_parent\_id) REFERENCES MAP2q\_pages (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_dynamic\_content DROP FOREIGN KEY FK\_371BB2CB9091A2FB -\> ALTER TABLE MAP2q\_dynamic\_content ADD CONSTRAINT FK\_371BB2CB9091A2FB FOREIGN KEY (translation\_parent\_id) REFERENCES MAP2q\_dynamic\_content (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_dynamic\_content DROP FOREIGN KEY FK\_371BB2CB91861123 -\> ALTER TABLE MAP2q\_dynamic\_content ADD CONSTRAINT FK\_371BB2CB91861123 FOREIGN KEY (variant\_parent\_id) REFERENCES MAP2q\_dynamic\_content (id) ON DELETE CASCADE ++ migrated (0.66s) SS skipped (Reason: Schema includes this migration) ++ migrating 20160731000000 -\> update MAP2q\_campaign\_lead\_event\_log log inner join MAP2q\_campaign\_events events on log.event\_id = events.id set log.metadata = ‘a:0:{}’ where events.type = ‘email.send’ and log.metadata = ‘a:2:{s:6:“failed”;i:1;s:6:“reason”;s:50:“mautic.notification.campaign.failed.not\_subscribed”;}’ ++ migrated (0.45s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160926182807 -\> insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null) Migration 20160926182807 failed during Execution. Error An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ [DoctrineDBALExceptionDriverException] An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ [DoctrineDBALDriverMysqliMysqliException] Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ doctrine:migrations:migrate ] ] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [-n|–no-interaction] [-s|–shell] [-e|–env ENV] [] [] []
---
### Author:  [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [July 21, 2017, 9:01pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/2 "2017-07-21T21:01:18Z")
Given that I am having so many bugs right now, I figured i’d try and update to 2.9 and hopefully that update would remedy some of my issues:
Instead, the upgrade didnt happen properly and I got this error message:
[2017-07-21 17:56:37] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ (uncaught exception) at /home/lead2crm/public\_html/map/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command `doctrine:migrations:migrate` [] []
[2017-07-21 17:56:37] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations Migrating up to 20170628191405 from 20160225000000 SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160615000000 -\> DROP INDEX MAP2q\_email\_date\_read ON MAP2q\_email\_stats -\> CREATE INDEX MAP2q\_email\_date\_read ON MAP2q\_email\_stats (date\_read) ++ migrated (0.55s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160712000000 -\> UPDATE MAP2q\_lead\_fields SET properties = ‘a:2:{s:9:“roundmode”;s:1:“4”;s:9:“precision”;s:1:“2”;}’ WHERE alias = ‘attribution’ ++ migrated (0.45s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160720000000 -\> DELETE FROM MAP2q\_lead\_utmtags WHERE utm\_campaign is null and utm\_content is null and utm\_medium is null and utm\_source is null and utm\_term is null ++ migrated (0.47s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160726000001 -\> ALTER TABLE MAP2q\_emails DROP FOREIGN KEY FK\_332899E39091A2FB -\> ALTER TABLE MAP2q\_emails ADD CONSTRAINT FK\_332899E39091A2FB FOREIGN KEY (translation\_parent\_id) REFERENCES MAP2q\_emails (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_emails DROP FOREIGN KEY FK\_332899E391861123 -\> ALTER TABLE MAP2q\_emails ADD CONSTRAINT FK\_332899E391861123 FOREIGN KEY (variant\_parent\_id) REFERENCES MAP2q\_emails (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_pages DROP FOREIGN KEY FK\_E308EF399091A2FB -\> ALTER TABLE MAP2q\_pages ADD CONSTRAINT FK\_E308EF399091A2FB FOREIGN KEY (translation\_parent\_id) REFERENCES MAP2q\_pages (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_pages DROP FOREIGN KEY FK\_E308EF3991861123 -\> ALTER TABLE MAP2q\_pages ADD CONSTRAINT FK\_E308EF3991861123 FOREIGN KEY (variant\_parent\_id) REFERENCES MAP2q\_pages (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_dynamic\_content DROP FOREIGN KEY FK\_371BB2CB9091A2FB -\> ALTER TABLE MAP2q\_dynamic\_content ADD CONSTRAINT FK\_371BB2CB9091A2FB FOREIGN KEY (translation\_parent\_id) REFERENCES MAP2q\_dynamic\_content (id) ON DELETE CASCADE -\> ALTER TABLE MAP2q\_dynamic\_content DROP FOREIGN KEY FK\_371BB2CB91861123 -\> ALTER TABLE MAP2q\_dynamic\_content ADD CONSTRAINT FK\_371BB2CB91861123 FOREIGN KEY (variant\_parent\_id) REFERENCES MAP2q\_dynamic\_content (id) ON DELETE CASCADE ++ migrated (0.66s) SS skipped (Reason: Schema includes this migration) ++ migrating 20160731000000 -\> update MAP2q\_campaign\_lead\_event\_log log inner join MAP2q\_campaign\_events events on log.event\_id = events.id set log.metadata = ‘a:0:{}’ where events.type = ‘email.send’ and log.metadata = ‘a:2:{s:6:“failed”;i:1;s:6:“reason”;s:50:“mautic.notification.campaign.failed.not\_subscribed”;}’ ++ migrated (0.45s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160926182807 -\> insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null) Migration 20160926182807 failed during Execution. Error An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ [DoctrineDBALExceptionDriverException] An exception occurred while executing ‘insert into MAP2q\_companies (companyname, is\_published) (SELECT DISTINCT TRIM(company), 1 from MAP2q\_leads l left join MAP2q\_companies c ON l.company = c.companyname where company IS NOT NULL and company \<\> ‘’ and c.companyname is null)’: Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ [DoctrineDBALDriverMysqliMysqliException] Illegal mix of collations (utf8\_unicode\_ci,IMPLICIT) and (utf8\_general\_ci,IMPLICIT) for operation ‘=’ doctrine:migrations:migrate [–write-sql] [–dry-run] [–query-time] [–allow-no-migration] [–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] [-s|–shell] [–process-isolation] [-e|–env ENV] [–no-debug] [–] [] [] []
---
### Author:  [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [July 21, 2017, 9:02pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/3 "2017-07-21T21:02:30Z")
The update wizard is stuck here:
Updating Mautic
Step Status
Downloading Package Success
Extracting Package Success
Moving Package Contents Success
Clearing Application Cache In Progress
---
### Author:  [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [July 21, 2017, 9:04pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/4 "2017-07-21T21:04:50Z")
I also cannot look at the schema:
An error occurred while updating the database. Check log for more details.
---
### Author:  [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [July 21, 2017, 9:24pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/5 "2017-07-21T21:24:59Z")
It looks like I received a partial update. I can see some features that werent there in the version lower than 2.9; for instance under the import contact wizard there are new features to import in the background or in the browser; however, when I tried “in the browser” i got a Internal 500 error.
Also, now my SEGEMENTS work. In previous threads, my segments were not working, now they are.
However, i need to resolve this partial update. I can load schema, Im not confident in it’s condition right now as now Im getting new errors (see above) so far.
---
### Author:  [@lead2crm](https://forum.mautic.org/u/lead2crm)
#### Post date: [July 21, 2017, 10:33pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/6 "2017-07-21T22:33:12Z")
I restored a back up of my web server from yesterday and this brought me back to version 2.8.2 of mautic. I saw my segments still worked and had correct counts. I then backed up my database to yesterday and the segments are broken again and back to zero
I’ll just have to wait until I get feedback here or until a later version comes out with a more stable upgrade process
---
### Author:  [@cpotter](https://forum.mautic.org/u/cpotter)
#### Post date: [August 13, 2017, 3:28pm UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/7 "2017-08-13T15:28:50Z")
I upgraded from 2.9.0 to 2.9.2 and now my segment updates are not working anymore
---
### Author:  [@theatereleven](https://forum.mautic.org/u/theatereleven)
#### Post date: [August 16, 2017, 12:28am UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/8 "2017-08-16T00:28:51Z")
Tried to upgrade to 2.9.2 using the update.php file today. CRASHED and burned.
Now my log is saying this:
[2017-08-16 01:25:28] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘SELECT COLUMN\_NAME AS Field, COLUMN\_TYPE AS Type, IS\_NULLABLE AS `Null`, COLUMN\_KEY AS `Key`, COLUMN\_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN\_COMMENT AS Comment, CHARACTER\_SET\_NAME AS CharacterSet, COLLATION\_NAME AS Collation FROM information\_schema.COLUMNS WHERE TABLE\_SCHEMA = ‘oilygurusm’ AND TABLE\_NAME = ‘ogasset\_downloads’’: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine (uncaught exception) at /var/www/oilygurus.com/public\_html/content/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command `doctrine:schema:update` [] []
---
### Author:  [@theatereleven](https://forum.mautic.org/u/theatereleven)
#### Post date: [August 16, 2017, 6:12am UTC](https://forum.mautic.org/t/unsuccessful-2-9-update/9024/9 "2017-08-16T06:12:47Z")
I restored mautic back to 2.4 from a backup (including the db). Tried again, but this time from within the GUI admin, even though instructions with 2.9.2 release notes say to use the update script from the command line. The admin upgrade worked until the last step and went to an “page not found” message. I jumped out to the command line, cleared cache, forced DB migrations and updated schema. Seems good so far.
This article helped a lot: [https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful](https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful)