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] [] [] []
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] [–] [] [] []
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
I also cannot look at the schema:
An error occurred while updating the database. Check log for more details.
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.
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
I upgraded from 2.9.0 to 2.9.2 and now my segment updates are not working anymore
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 [] []
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