Mautic Community Forums

Campaign trigger cron producing null error

Hello,



We have setup a new instance using the new version and had everything setup properly. We have one campaign, and some contacts that has filtered into the segment for this campaign. All contacts got added to the campaign, but for some reason the error below keeps showing in the logs:



Any thoughts on what could this be? There is nothing in the campaign that creates a new stage so we are unsure what is would trigger an Insert into Stages. The first list of actions are add tags, and schedule 5 emails after 30 minutes, 7 days, 14 days etc… One action will come at the end of the sequence, which is change contact stage but that won’t trigger till later, and again its just a normal action and all looks correct.

This is the same campaign formula we use with another client so the logic hasn’t changed. We double checked all the stages, and they all look correct. Also all contacts have emails and all look correct. Unsure what is causing this.



Below is the log:



[2017-08-17 19:30:07] mautic.NOTICE: DoctrineDBALExceptionNotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO db_stages (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, weight, publish_up, publish_down, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘name’ cannot be null (uncaught exception) at /home/lamasa/public_html/db/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 while running console command mautic:campaigns:trigger [] []

[2017-08-17 19:40:05] mautic.NOTICE: DoctrineDBALExceptionNotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO db_stages (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, weight, publish_up, publish_down, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘name’ cannot be null (uncaught exception) at /home/lamasa/public_html/db/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 while running console command mautic:campaigns:trigger [] []

[2017-08-17 19:50:06] mautic.NOTICE: DoctrineDBALExceptionNotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO db_stages (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, weight, publish_up, publish_down, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘name’ cannot be null (uncaught exception) at /home/lamasa/public_html/db/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 while running console command mautic:campaigns:trigger [] []

Hello,

We have setup a new instance using the new version and had everything setup properly. We have one campaign, and some contacts that has filtered into the segment for this campaign. All contacts got added to the campaign, but for some reason the error below keeps showing in the logs:

Any thoughts on what could this be? There is nothing in the campaign that creates a new stage so we are unsure what is would trigger an Insert into Stages. The first list of actions are add tags, and schedule 5 emails after 30 minutes, 7 days, 14 days etc… One action will come at the end of the sequence, which is change contact stage but that won’t trigger till later, and again its just a normal action and all looks correct.
This is the same campaign formula we use with another client so the logic hasn’t changed. We double checked all the stages, and they all look correct. Also all contacts have emails and all look correct. Unsure what is causing this.

Below is the log:

[2017-08-17 19:30:07] mautic.NOTICE: DoctrineDBALExceptionNotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO db_stages (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, weight, publish_up, publish_down, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘name’ cannot be null (uncaught exception) at /home/lamasa/public_html/db/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 while running console command mautic:campaigns:trigger [] []
[2017-08-17 19:40:05] mautic.NOTICE: DoctrineDBALExceptionNotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO db_stages (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, weight, publish_up, publish_down, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘name’ cannot be null (uncaught exception) at /home/lamasa/public_html/db/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 while running console command mautic:campaigns:trigger [] []
[2017-08-17 19:50:06] mautic.NOTICE: DoctrineDBALExceptionNotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO db_stages (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, weight, publish_up, publish_down, category_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘name’ cannot be null (uncaught exception) at /home/lamasa/public_html/db/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 while running console command mautic:campaigns:trigger [] []