We’re happy to announce that 2.8.2 has been released! Read the full release notes here.
If upgrading from earlier than 2.8.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.8.0 or later:
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
We’re happy to announce that 2.8.2 has been released! Read the full release notes here.
If upgrading from earlier than 2.8.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.8.0 or later:
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
BOOM.
[2017-06-02 01:19:27] mautic.NOTICE: DoctrineDBALExceptionDriverException: An exception occurred while executing ‘insert into ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_companies c ON l.company = c.companyname where company IS NOT NULL and company <> ‘’ and c.companyname is null)’: SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 while running console command doctrine:migrations:migrate [] []
[2017-06-02 01:19:27] mautic.ERROR: [UPGRADE ERROR] Exit code 1; Mautic Migrations Migrating up to 20170506144649 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 ma_email_date_read ON ma_email_stats
-> CREATE INDEX ma_email_date_read ON ma_email_stats (date_read) ++ migrated (0.23s) 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 ma_lead_fields SET properties = ‘a:2:{s:9:“roundmode”;s:1:“4”;s:9:“precision”;s:1:“2”;}’ WHERE alias = ‘attribution’ ++ migrated (0.12s) SS skipped (Reason: Schema includes this migration) SS skipped (Reason: Schema includes this migration) ++ migrating 20160720000000
-> DELETE FROM ma_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.11s) 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 ma_emails DROP FOREIGN KEY FK_7FBA02D79091A2FB
-> ALTER TABLE ma_emails ADD CONSTRAINT FK_7FBA02D79091A2FB FOREIGN KEY (translation_parent_id) REFERENCES ma_emails (id) ON DELETE CASCADE
-> ALTER TABLE ma_emails DROP FOREIGN KEY FK_7FBA02D791861123
-> ALTER TABLE ma_emails ADD CONSTRAINT FK_7FBA02D791861123 FOREIGN KEY (variant_parent_id) REFERENCES ma_emails (id) ON DELETE CASCADE
-> ALTER TABLE ma_pages DROP FOREIGN KEY FK_188385189091A2FB
-> ALTER TABLE ma_pages ADD CONSTRAINT FK_188385189091A2FB FOREIGN KEY (translation_parent_id) REFERENCES ma_pages (id) ON DELETE CASCADE
-> ALTER TABLE ma_pages DROP FOREIGN KEY FK_1883851891861123
-> ALTER TABLE ma_pages ADD CONSTRAINT FK_1883851891861123 FOREIGN KEY (variant_parent_id) REFERENCES ma_pages (id) ON DELETE CASCADE
-> ALTER TABLE ma_dynamic_content DROP FOREIGN KEY FK_36E126B09091A2FB
-> ALTER TABLE ma_dynamic_content ADD CONSTRAINT FK_36E126B09091A2FB FOREIGN KEY (translation_parent_id) REFERENCES ma_dynamic_content (id) ON DELETE CASCADE
-> ALTER TABLE ma_dynamic_content DROP FOREIGN KEY FK_36E126B091861123
-> ALTER TABLE ma_dynamic_content ADD CONSTRAINT FK_36E126B091861123 FOREIGN KEY (variant_parent_id) REFERENCES ma_dynamic_content (id) ON DELETE CASCADE ++ migrated (1.45s) SS skipped (Reason: Schema includes this migration) ++ migrating 20160731000000
-> update ma_campaign_lead_event_log log inner join ma_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.11s) 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 ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_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 ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_companies c ON l.company = c.companyname where company IS NOT NULL and company <> ‘’ and c.companyname is null)’: SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value [DoctrineDBALExceptionDriverException] An exception occurred while executing ‘insert into ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_companies c ON l.company = c.companyname where company IS NOT NULL and company <> ‘’ and c.companyname is null)’: SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value [DoctrineDBALDriverPDOException] SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value [PDOException] SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value 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] [–] [] [] []
None of John’s tips worked for me…
[code]root@ma:/var/www/html# sudo -u www-data /usr/bin/php /var/www/html/app/console doctrine:migration:status
== Configuration
>> Name: Mautic Migrations
>> Database Driver: pdo_mysql
>> Database Name: mauticdb
>> Configuration Source: manually configured
>> Version Table Name: ma_migrations
>> Version Column Name: version
>> Migrations Namespace: MauticMigrations
>> Migrations Directory: /var/www/html/app/migrations
>> Previous Version: 2016-09-26 00:00:00 (20160926000000)
>> Current Version: 2016-09-26 00:00:01 (20160926000001)
>> Next Version: 2016-09-26 18:28:07 (20160926182807)
>> Latest Version: 2017-05-06 14:46:49 (20170506144649)
>> Executed Migrations: 46
>> Executed Unavailable Migrations: 0
>> Available Migrations: 77
>> New Migrations: 31[/code]
WARNING! You are about to execute a database migration that could result in schema changes and data lost. Are you sure you wish to continue? (y/n)y
Migrating up to 20170506144649 from 20160926000001
++ migrating 20160926182807
-> insert into ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_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 ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_companies c ON l.company = c.companyname where company IS NOT NULL and company <> ‘’ and c.companyname is null)’:
SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value
[DoctrineDBALExceptionDriverException]
An exception occurred while executing 'insert into ma_companies (companyname, is_published) (SELECT DISTINCT TRIM(company), 1 from ma_leads l left join ma_companies c ON l.company = c.companyname where company IS NOT NULL and company <> ‘’ and c.companyname is null)
':
SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value
[DoctrineDBALDriverPDOException]
SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value
[PDOException]
SQLSTATE[HY000]: General error: 1364 Field ‘score’ doesn’t have a default value
Aaaaand fuckit…on my knees to the ZFS Gods. Now back up and running on 2.8.1.
zfs rollback -r z1/snaps/vm-122-disk-1@preMautic2-8-2Was going through the release notes and found:
- #4090 Fixes menu structure on php 7.1 when in dev mode
Does this mean that PHP 7.1 is fully supported in 2.8.2?
What to do with this
Processing Database Updates undefined???
[2017-06-02 08:46:12] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead_count, max(l.id) as max_id FROM leads l INNER JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (ll.date_added <= ‘2017-06-02 08:46:12’) AND (ll.manually_added = ?) AND (ll.leadlist_id = 4) AND (l.id NOT IN (SELECT l.id FROM leads l INNER JOIN companies_leads cl ON l.id = cl.lead_id INNER JOIN companies comp ON cl.company_id = comp.id WHERE (comp.companyname = ?) AND (()) GROUP BY l.id))’ with params [0, “Educatecourse”]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command mautic:segments:update [] []
[2017-06-02 09:08:28] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead_count, max(l.id) as max_id FROM leads l INNER JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (ll.date_added <= ‘2017-06-02 09:08:28’) AND (ll.manually_added = ?) AND (ll.leadlist_id = 4) AND (l.id NOT IN (SELECT l.id FROM leads l INNER JOIN companies_leads cl ON l.id = cl.lead_id INNER JOIN companies comp ON cl.company_id = comp.id WHERE (comp.companyname = ?) AND (()) GROUP BY l.id))’ with params [0, “Educatecourse”]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command mautic:segments:update [] []
[2017-06-02 09:09:15] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead_count, max(l.id) as max_id FROM leads l INNER JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (ll.date_added <= ‘2017-06-02 09:09:15’) AND (ll.manually_added = ?) AND (ll.leadlist_id = 4) AND (l.id NOT IN (SELECT l.id FROM leads l INNER JOIN companies_leads cl ON l.id = cl.lead_id INNER JOIN companies comp ON cl.company_id = comp.id WHERE (comp.companyname = ?) AND (()) GROUP BY l.id))’ with params [0, “Educatecourse”]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command mautic:segments:update [] []
[2017-06-02 09:11:02] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead_count, max(l.id) as max_id FROM leads l INNER JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (ll.date_added <= ‘2017-06-02 09:11:02’) AND (ll.manually_added = ?) AND (ll.leadlist_id = 5) AND (l.id NOT IN (SELECT l.id FROM leads l INNER JOIN companies_leads cl ON l.id = cl.lead_id INNER JOIN companies comp ON cl.company_id = comp.id WHERE (comp.companyname = ?) AND (()) GROUP BY l.id))’ with params [0, “Invest”]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command mautic:segments:update [] []
[2017-06-02 09:11:16] mautic.NOTICE: DoctrineDBALExceptionSyntaxErrorException: An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead_count, max(l.id) as max_id FROM leads l INNER JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (ll.date_added <= ‘2017-06-02 09:11:16’) AND (ll.manually_added = ?) AND (ll.leadlist_id = 3) AND (l.id NOT IN (SELECT l.id FROM leads l INNER JOIN companies_leads cl ON l.id = cl.lead_id INNER JOIN companies comp ON cl.company_id = comp.id WHERE (comp.companyname = ?) AND (()) GROUP BY l.id))’ with params [0, “Coach4free”]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)) GROUP BY l.id))’ at line 1 (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 90 while running console command mautic:segments:update [] []
Damn… This
sounded soooo promising.
But a question in the round: Are there experiences with 2.8.2? I understand that an update is a tricky thing, but what if it works?
I just upgraded from 2.7.1 from the mautic brain dead install. It downloaded and automatically installed flawlessly. Campaign stuff now runs as it fixed a bug. Thank you team for your long hours on this bug fix release.
Upgraded via ssh from 2.7 with no problems. Nice work.
The manual form HTML is still using :
script.src = ‘http://www.site.com/ma/ma/media/js/mautic-form.js’;
When the url should be …www.site.com/ma/media/…
@mconner1 Try this: https://www.robertwent.com/blog/fixing-broken-email-template-images-when-running-mautic-in-a-folder/
[quote=23445:@a1exe1]What to do with this
Processing Database Updates undefined???[/quote]
Two questions:
- Did you upgrade from 2.8.1?
- Did you have custom fields? I have several that I’m testing in Core and Professional
-RB
My 2.8.2 is working perfectly fine.
The update from 2.8.1 using the php script worked perfectly fine.
Thanks guys for your hard work. mautic is a amazing tool.
@robwent said, ”@redneckbob you could try try the upgrade script. Upload it to the root of the site and browse to it: https://github.com/mautic/mautic/blob/staging/upgrade.php“.
I was on 2.8.1 and the upgrade.php cured my issue. On both Mautic installations.
Whoo hoo!
Just want to let everyone know that the upgrade.php script has worked for me
I successfully upgraded from 2.1.1 to 2.8.2 executing the script
At the end of the script execution it actually outputted to the console that it failed, but as soon as I executed the upgrade.php command again it said that upgrade was not necessary as was already in version 2.8.2, and after logging in to mautic in the browser, everything was working 
The update just brought down my entire website and mautic installation. Lovely…
Receiving the following error in the command line:
nginx-sp.service - nginx-sp
Loaded: loaded (/lib/systemd/system/nginx-sp.service; enabled; vendor preset: enabled)
Active: inactive (dead) (Result: exit-code) since Mon 2017-06-19 15:21:44 UTC; 2min 42s ago
Process: 3212 ExecStartPre=/opt/sp/nginx/sbin/nginx -t (code=exited, status=1/FAILURE)
[quote=23477:@mconner1]Upgraded via ssh from 2.7 with no problems. Nice work.
The manual form HTML is still using :
script.src = ‘http://www.site.com/ma/ma/media/js/mautic-form.js’;
When the url should be …www.site.com/ma/media/…[/quote]
Ohhhh … hope it will we fixed in next release … it is a sooo anoying bug …
As far as I could see some work is in progress in #4148