Mautic Community Forums

Web Notification Broken

I updated of the Mautic version for 2.8, before this, all functions worked correctly, but after of actualization the web notifications stopped working.



I can’t create or using with campaings, same the web notifications that I had created before the actualization, don’t working.



My before version was 2.7.1.



Look this:

Screen%20Shot%202017-05-02%20at%2020.02.50.png



When I clicked on create, it breaks:

Screen%20Shot%202017-05-02%20at%2020.03.19.png



The log show this:

[2017-05-02 19:37:43] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionNotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO mautic_push_notifications (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, name, description, lang, url, heading, message, button, notification_type, publish_up, publish_down, read_count, sent_count, mobile, mobileSettings, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2017-05-02 22:37:43”, 1, “Vinicius Figueiru00f4a”, null, null, null, null, null, null, “teste3”, null, “en”, “http://asdasd”, “asda”, “asdsdad”, “asda”, “template”, null, null, 0, 0, null, “N;”, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null” at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 {“exception”:"[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO mautic_push_notifications (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, name, description, lang, url, heading, message, button, notification_type, publish_up, publish_down, read_count, sent_count, mobile, mobileSettings, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2017-05-02 22:37:43”, 1, “Vinicius Figueir\u00f4a”, null, null, null, null, null, null, “teste3”, null, “en”, “http://asdasd”, “asda”, “asdsdad”, “asda”, “template”, null, null, 0, 0, null, “N;”, null]:nnSQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112, Doctrine\DBAL\Driver\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []



Why its happens?

I updated of the Mautic version for 2.8, before this, all functions worked correctly, but after of actualization the web notifications stopped working.

I can’t create or using with campaings, same the web notifications that I had created before the actualization, don’t working.

My before version was 2.7.1.

Look this:

When I clicked on create, it breaks:

The log show this:
[2017-05-02 19:37:43] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionNotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO mautic_push_notifications (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, name, description, lang, url, heading, message, button, notification_type, publish_up, publish_down, read_count, sent_count, mobile, mobileSettings, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2017-05-02 22:37:43”, 1, “Vinicius Figueiru00f4a”, null, null, null, null, null, null, “teste3”, null, “en”, “http://asdasd”, “asda”, “asdsdad”, “asda”, “template”, null, null, 0, 0, null, “N;”, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null” at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 {“exception”:"[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO mautic_push_notifications (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, name, description, lang, url, heading, message, button, notification_type, publish_up, publish_down, read_count, sent_count, mobile, mobileSettings, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2017-05-02 22:37:43”, 1, “Vinicius Figueir\u00f4a”, null, null, null, null, null, null, “teste3”, null, “en”, “http://asdasd”, “asda”, “asdsdad”, “asda”, “template”, null, null, 0, 0, null, “N;”, null]:nnSQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112, Doctrine\DBAL\Driver\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘mobile’ cannot be null at /var/www/sistema.catchleads.com.br/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

Why its happens?

Hi, I want to you to ask - how did you start this option. I have only Focus item - it looks different than your version. Should I start some plugin?

I have the same problem… I added OneSignal.

I have the same problem. Was working correctly, will investigate further.

It works, update to 2.8.2