# Regarding issues on Mautic **URL:** \ **Category:** Product Support\ **Created:** [August 11, 2023, 11:19am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908 "2023-08-11T11:19:42Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![shekhar](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@shekhar](https://forum.mautic.org/u/shekhar)\ **Post date:** [August 11, 2023, 11:19am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/1 "2023-08-11T11:19:43Z")
**Your software** My Mautic version is: 4.4.9 My PHP version is: 8.0.29 My Database type and version is: 5.7.23- |Doctrine driver|pdo\_mysql| **Your problem** My problem is: we have make some cmapaign workflow which execute based on a segment filter on eveyhour. But problem is that our complex workflow throwing 500 internal server error sometimes during execution of the workflow. So If we move to another hosting like Mautic hosting so our campaign will work there fine? Here is some error logs we received on mautic error logs: [2023-08-11 00:00:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionLost: “An exception occurred while executing ‘SELECT u0\_.is\_published AS is\_published\_0, u0\_.date\_added AS date\_added\_1, u0\_.created\_by AS created\_by\_2, u0\_.created\_by\_user AS created\_by\_user\_3, u0\_.date\_modified AS date\_modified\_4, u0\_.modified\_by AS modified\_by\_5, u0\_.modified\_by\_user AS modified\_by\_user\_6, u0\_.checked\_out AS checked\_out\_7, u0\_.checked\_out\_by AS checked\_out\_by\_8, u0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, u0\_.id AS id\_10, u0\_.username AS username\_11, u0\_.password AS password\_12, u0\_.first\_name AS first\_name\_13, u0\_.last\_name AS last\_name\_14, u0\_.email AS email\_15, u0\_.position AS position\_16, u0\_.timezone AS timezone\_17, u0\_.locale AS locale\_18, u0\_.last\_login AS last\_login\_19, u0\_.last\_active AS last\_active\_20, u0\_.preferences AS preferences\_21, u0\_.signature AS signature\_22, r1\_.is\_published AS is\_published\_23, r1\_.date\_added AS date\_added\_24, r1\_.created\_by AS created\_by\_25, r1\_.created\_by\_user AS created\_by\_user\_26, r1\_.date\_modified AS date\_modified\_27, r1\_.modified\_by AS modified\_by\_28, r1\_.modified\_by\_user AS modified\_by\_user\_29, r1\_.checked\_out AS checked\_out\_30, r1\_.checked\_out\_by AS checked\_out\_by\_31, r1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_32, r1\_.id AS id\_33, r1\_.name AS name\_34, r1\_.description AS description\_35, r1\_.is\_admin AS is\_admin\_36, r1\_.readable\_permissions AS readable\_permissions\_37, u0\_.role\_id AS role\_id\_38 FROM users u0\_ LEFT JOIN roles r1\_ ON u0\_.role\_id = r1\_.id WHERE (u0\_.username = ? OR u0\_.email = ?) AND u0\_.is\_published = ?’ with params [“admin”, “admin”, 1]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:“[object] (Doctrine\DBAL\Exception\ConnectionLost(code: 0): An exception occurred while executing ‘SELECT u0\_.is\_published AS is\_published\_0, u0\_.date\_added AS date\_added\_1, u0\_.created\_by AS created\_by\_2, u0\_.created\_by\_user AS created\_by\_user\_3, u0\_.date\_modified AS date\_modified\_4, u0\_.modified\_by AS modified\_by\_5, u0\_.modified\_by\_user AS modified\_by\_user\_6, u0\_.checked\_out AS checked\_out\_7, u0\_.checked\_out\_by AS checked\_out\_by\_8, u0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, u0\_.id AS id\_10, u0\_.username AS username\_11, u0\_.password AS password\_12, u0\_.first\_name AS first\_name\_13, u0\_.last\_name AS last\_name\_14, u0\_.email AS email\_15, u0\_.position AS position\_16, u0\_.timezone AS timezone\_17, u0\_.locale AS locale\_18, u0\_.last\_login AS last\_login\_19, u0\_.last\_active AS last\_active\_20, u0\_.preferences AS preferences\_21, u0\_.signature AS signature\_22, r1\_.is\_published AS is\_published\_23, r1\_.date\_added AS date\_added\_24, r1\_.created\_by AS created\_by\_25, r1\_.created\_by\_user AS created\_by\_user\_26, r1\_.date\_modified AS date\_modified\_27, r1\_.modified\_by AS modified\_by\_28, r1\_.modified\_by\_user AS modified\_by\_user\_29, r1\_.checked\_out AS checked\_out\_30, r1\_.checked\_out\_by AS checked\_out\_by\_31, r1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_32, r1\_.id AS id\_33, r1\_.name AS name\_34, r1\_.description AS description\_35, r1\_.is\_admin AS is\_admin\_36, r1\_.readable\_permissions AS readable\_permissions\_37, u0\_.role\_id AS role\_id\_38 FROM users u0\_ LEFT JOIN roles r1\_ ON u0\_.role\_id = r1\_.id WHERE (u0\_.username = ? OR u0\_.email = ?) AND u0\_.is\_published = ?’ with params ["admin", "admin", 1]:\n\nSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“vultr”,“pid”:688990} [2023-08-11 01:00:03] mautic.WARNING: MaxMind license key is required. {“hostname”:“vultr”,“pid”:812813} [2023-08-11 01:00:03] mautic.ERROR: Failed to fetch remote IP data: URI must be a string or UriInterface {“hostname”:“vultr”,“pid”:812813} [2023-08-11 01:00:03] mautic.WARNING: MaxMind license key is required. {“hostname”:“vultr”,“pid”:812813} [2023-08-11 04:21:26] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps\_files\_cleanup\_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/html/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {“hostname”:“vultr”,“pid”:808037} [2023-08-11 05:11:34] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps\_files\_cleanup\_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/html/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {“hostname”:“vultr”,“pid”:808049} [2023-08-11 05:59:06] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 32 {“hostname”:“vultr”,“pid”:808041} [2023-08-11 05:59:06] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 33 {“hostname”:“vultr”,“pid”:808041} [2023-08-11 05:59:06] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 34 {“hostname”:“vultr”,“pid”:808041} [2023-08-11 05:59:06] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 35 {“hostname”:“vultr”,“pid”:808041} [2023-08-11 05:59:49] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 32 {“hostname”:“vultr”,“pid”:808037} [2023-08-11 05:59:49] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 33 {“hostname”:“vultr”,“pid”:808037} [2023-08-11 05:59:49] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 34 {“hostname”:“vultr”,“pid”:808037} [2023-08-11 05:59:49] mautic.WARNING: PHP Warning - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/CampaignBundle/Controller/EventController.php - at line 35 {“hostname”:“vultr”,“pid”:808037} [2023-08-11 07:56:07] mautic.WARNING: PHP Warning - Undefined array key “path” - in file /var/www/html/app/bundles/CoreBundle/Controller/ExceptionController.php - at line 111 {“hostname”:“vultr”,“pid”:847399} [2023-08-11 09:05:31] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO sms\_messages (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, message, sms\_type, publish\_up, publish\_down, sent\_count, category\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2023-08-11 09:05:31”, 1, “Wake Admin”, null, null, null, null, null, null, “Day 5 SMS1”, null, “en”, null, “template”, null, null, 0, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 125 {“exception”:“[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO sms\_messages (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, message, sms\_type, publish\_up, publish\_down, sent\_count, category\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2023-08-11 09:05:31", 1, "Wake Admin", null, null, null, null, null, null, "Day 5 SMS1", null, "en", null, "template", null, null, 0, null]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:125, Doctrine\DBAL\Driver\PDO\Exception(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“vultr”,“pid”:820385} [2023-08-11 09:06:03] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO sms\_messages (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, message, sms\_type, publish\_up, publish\_down, sent\_count, category\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2023-08-11 09:06:03”, 1, “Wake Admin”, null, null, null, null, null, null, “Day 5 SMS1”, null, “en”, null, “template”, null, null, 0, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 125 {“exception”:“[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO sms\_messages (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, message, sms\_type, publish\_up, publish\_down, sent\_count, category\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, "2023-08-11 09:06:03", 1, "Wake Admin", null, null, null, null, null, null, "Day 5 SMS1", null, "en", null, "template", null, null, 0, null]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:125, Doctrine\DBAL\Driver\PDO\Exception(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”} {“hostname”:“vultr”,“pid”:817219} and Here is attached screenshots of my campaigns workflow ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/8/83c13b402f30fed07d74c4d1c2c25a69d8403742.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/208900d1a7ac2b9f9af02323a14219f4ce6485a1.png) ---
**Author:** ![ekke](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ekke/32/296_2.png) [@ekke](https://forum.mautic.org/u/ekke)\ **Post date:** [August 13, 2023, 6:49pm UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/2 "2023-08-13T18:49:47Z")
sounds like you are trying to send an empty SMS text message? This should be caught by Mautic but obviously is not, but an empty SMS does not make sense anyway 🙂 ---
**Author:** ![shekhar](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@shekhar](https://forum.mautic.org/u/shekhar)\ **Post date:** [August 14, 2023, 2:53am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/3 "2023-08-14T02:53:16Z")
Hi @ekke Thanks for the reply of my forum. So Is it a reason of throwing errors of 500 internal server? or is there a specific step we need to fix? Hope to hear from you soon. Regards Shekhar ---
**Author:** ![ekke](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ekke/32/296_2.png) [@ekke](https://forum.mautic.org/u/ekke)\ **Post date:** [August 14, 2023, 6:21am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/4 "2023-08-14T06:21:58Z")
Yes, this portion seems to be the root cause to me: > [@](#): > > mautic.CRITICAL: Uncaught PHP Exception … while executing ‘INSERT INTO sms\_messages … SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘message’ cannot be null” Do you happen to have any SMS templates with no content? ---
**Author:** ![shekhar](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@shekhar](https://forum.mautic.org/u/shekhar)\ **Post date:** [August 14, 2023, 6:24am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/5 "2023-08-14T06:24:24Z")
Hi @ekke We have make some templates for testing purpose only with the content like this Hello {contactfield=firstname}, Revitalist here. We’ve received your Home Therapy free assessment request. Reply ‘HOME’ and we will call you. ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [August 14, 2023, 8:56am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/6 "2023-08-14T08:56:25Z")
Hi, i think @ekke is right here. Its worth exploring why the sms messages that you try to send / insert into the table have message attribute null. ---
**Author:** ![shekhar](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@shekhar](https://forum.mautic.org/u/shekhar)\ **Post date:** [August 14, 2023, 9:20am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/7 "2023-08-14T09:20:06Z")
Hi @mzagmajster Thanks for the clarifying about this. I am new to Mautic so having a difficult time to understand all of this actions. Could you please tell me what is the difference between these two? ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/2fa7b187dbb77515e87751d72c719c8199cfe4fb.png) ---
**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\ **Post date:** [August 14, 2023, 10:45am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/8 "2023-08-14T10:45:27Z")
It’s actually written there: 1. Template you can use in campaigns 2. List you can use for 1x scheduled sms blast ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [August 14, 2023, 11:49am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/9 "2023-08-14T11:49:23Z")
If you are sure you are not sending empty messages by mistake, ti could be that the issue lies else where. I would debug SMS transport (plugin you use to send sms) and try to figure out how it comes to the conclusion the message is null. ---
**Author:** ![shekhar](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@shekhar](https://forum.mautic.org/u/shekhar)\ **Post date:** [August 16, 2023, 3:05am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/10 "2023-08-16T03:05:00Z")
Hi @mzagmajster Yes sure you can have a look with me and connect through any desk or TeamViewer so I will walk you through my workflow diagram I made if that’s possible by you? Many thanks. ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [August 16, 2023, 5:33am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/11 "2023-08-16T05:33:38Z")
Hi @shekar, I can look into it, but not before Friday. Please send me PM with your email so I can schedule a short meeting on Friday (if you don’t solve the problem by then). Regards, M. ---
**Author:** ![shekhar](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@shekhar](https://forum.mautic.org/u/shekhar)\ **Post date:** [August 16, 2023, 6:09am UTC](https://forum.mautic.org/t/regarding-issues-on-mautic/28908/12 "2023-08-16T06:09:09Z")
Hi @mzagmajster, Thanks for the reply. Yes I am trying to resolve the things asap. Thanks