Mautic Community Forums

2.9.1 Released

We’re happy to announce that the 2.9.1 has been released! Read the full release notes here.



If upgrading from earlier than 2.6.0:

If you are have access to SSH, we highly recommend that you use the update script. Download it to the root of your Mautic installation and run it from SSH/CLI with php upgrade.php. If you are on a VPS, be aware of the user used to execute that command as you may have to fix the owner to be that of your web user. Be sure to remove this file once the upgrade is complete.



If upgrading from 2.6.0 or 2.6.1:

Since this does not include any schema changes, the update process built into Mautic’s front-end will suffice in updating. Simply log out, back in, and you should see the upgrade notification similar to:



update_available.png



Click Update Now and follow the prompts.



If you have any issues - be sure to checkout John’s post.



Happy Marketing!



The Mautic Team

We’re happy to announce that the 2.9.1 has been released! Read the full release notes here.

If upgrading from earlier than 2.6.0:
If you are have access to SSH, we highly recommend that you use the update script. Download it to the root of your Mautic installation and run it from SSH/CLI with php upgrade.php. If you are on a VPS, be aware of the user used to execute that command as you may have to fix the owner to be that of your web user. Be sure to remove this file once the upgrade is complete.

If upgrading from 2.6.0 or 2.6.1:
Since this does not include any schema changes, the update process built into Mautic’s front-end will suffice in updating. Simply log out, back in, and you should see the upgrade notification similar to:

Click Update Now and follow the prompts.

If you have any issues - be sure to checkout John’s post.

Happy Marketing!

The Mautic Team

[2017-07-27 14:00:56] mautic.ERROR: An error occurred while attempting to fetch updates: Couldn’t resolve host ‘updates.mautic.org’ [] []
[2017-07-27 18:08:40] 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-27 18:08:40] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations Migrating up to 20170725155053 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.57s) 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.54s) 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.59s) 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.8s) 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] [–] [] [] []
[2017-07-27 18:11:26] 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-27 18:11:26] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations Migrating up to 20170725155053 from 20160926000001 ++ 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] [–] [] [] []

My last update (via shell because the native interface gave me a partial update and even the shell update only gave me a partial update, but more stable than the UI) was from 2.82 to 2.9 and it didnt go down without errors, but ran stable and fixed critical bugs in 2.8.2 so I kept 2.9. Today I saw 2.9.1 was available and figured I would try to upgrade to that hoping it would be a successful update from beginning to end; however, it had errors as well. See above. Also, I cannot run update/schema, i get an error message

I just reverted back to a backup from Tuesday and tried to install 2.9 to 2.9.1 via shell and got this error:

[2017-07-27 22:29:08] 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

I just upgraded from 2.8.1 but noticed that this caused another bug that has been decribed by more people: after submitting a form the submit button changes to ‘Please wait’ and then just stays there. In the mean time the data is stored as contact in Mautic, no problem there. Just the message or redirect does not work.

Restoring my previous version solved the problem but now I can’t use the awesome 2-way SugarCRM integration!

Some threads suggested clearing the cache, but that didn’t solve the problem. It also doesn’t matter whether I’m logged in in Mautic or not.
https://www.mautic.org/community/index.php/7710-form-button-stuck-on-please-wait-while-adding-contact-into-maut/0
https://www.mautic.org/community/index.php/6961-please-wait-on-form-submission/0
https://www.mautic.org/community/index.php/5798-form-actions-do-not-trigger/0
Is also seems different than github #4349 as suggested here: https://github.com/mautic/mautic/issues/4473. There is no error 500, just nothing happens.

Can anyone help me out

That, How vTiger contacts can sync in mautic and vice a versa?

What i need , People who are added to Vtiger should get added to Mautic and Vice Versa.

Thanks in advance

Kishan Kumawat

Great work. The update works for me.

You could do a validation to know if apache has write permission on all the necessary folders, because I had this problem. Other than that, all right.

Form submitting problem has not been resolved yet :(. It happened since ver 2.9.0. Please fix

[quote=24709:@DutchAlfred]I just upgraded from 2.8.1 but noticed that this caused another bug that has been decribed by more people: after submitting a form the submit button changes to ‘Please wait’ and then just stays there. In the mean time the data is stored as contact in Mautic, no problem there. Just the message or redirect does not work.

Restoring my previous version solved the problem but now I can’t use the awesome 2-way SugarCRM integration!

Some threads suggested clearing the cache, but that didn’t solve the problem. It also doesn’t matter whether I’m logged in in Mautic or not.
https://www.mautic.org/community/index.php/7710-form-button-stuck-on-please-wait-while-adding-contact-into-maut/0
https://www.mautic.org/community/index.php/6961-please-wait-on-form-submission/0
https://www.mautic.org/community/index.php/5798-form-actions-do-not-trigger/0
Is also seems different than github #4349 as suggested here: https://github.com/mautic/mautic/issues/4473. There is no error 500, just nothing happens.[/quote]
Same problem after updating to mautic 2.9.0 :frowning: Now 2.9.1 form problem is still staying there!!!

ERROR Message:

“The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.
System administrators, check server logs for errors.”

It apper after I upgrade to 2.9.0 and continue on 2.9.1 upgrade.

When I login to Mautic and access a landing page the message above appers.

When. I am not logged in on Mautic the message did not apper and I can access the Landing Page very well.

I have cheched file and folder permissions and is ALL Fine recursevelly.

Please any recommendation?

My error LOG:


[2017-07-30 22:08:39] mautic.ERROR: PHP Error: Call to a member function getFieldValue() on null - in file /var/www/mydomain-websites/m.mydomain.com/website/app/bundles/FormBundle/Model/FormModel.php - at line 765 [] []

[2017-07-30 22:08:39] mautic.ERROR: SymfonyComponentDebugExceptionFatalErrorException: Error: Call to a member function getFieldValue() on null - in file /var/www/mydomain-websites/m.mydomain.com/website/app/bundles/FormBundle/Model/FormModel.php - at line 765 [] []

[2017-07-30 22:08:56] mautic.ERROR: PHP Error: Call to a member function getFieldValue() on null - in file /var/www/mydomain-websites/m.mydomain.com/website/app/bundles/FormBundle/Model/FormModel.php - at line 765 [] []

[2017-07-30 22:08:56] mautic.ERROR: SymfonyComponentDebugExceptionFatalErrorException: Error: Call to a member function getFieldValue() on null - in file /var/www/mydomain-websites/m.mydomain.com/website/app/bundles/FormBundle/Model/FormModel.php - at line 765 [] []

[2017-07-31 11:26:43] mautic.ERROR: PHP Error: Call to a member function getFieldValue() on null - in file /var/www/mydomain-websites/m.mydomain.com/website/app/bundles/FormBundle/Model/FormModel.php - at line 765 [] []

[2017-07-31 11:26:43] mautic.ERROR: SymfonyComponentDebugExceptionFatalErrorException: Error: Call to a member function getFieldValue() on null - in file /var/www/mydomain-websites/m.mydomain.com/website/app/bundles/FormBundle/Model/FormModel.php - at line 765 [] []

PLEASE, HELP me.

Any solution to the Submit button being stuck on Please Wait… It seems like the problem is common but I can’t seem to find any solutions.