# Problem with send form

**URL:** <https://forum.mautic.org/t/problem-with-send-form/30043>\
**Category:** Product Support\
**Created:** [November 26, 2023, 7:22pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043 "2023-11-26T19:22:50Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 26, 2023, 7:22pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/1 "2023-11-26T19:22:50Z")

</div>

**Your software**  
My Mautic version is: 3.3.4  
My PHP version is: 7.4.33  
My Database type and version is: mysql 3.7

**Your problem**  
My problem is: submit form not working - only send the form to mautic but not open thankyou page and send no mail  
here is an example for a form not wotking  
[https://bkalut.co.il/mailme/s/forms/preview/11](https://bkalut.co.il/mailme/s/forms/preview/11)  
These errors are showing in the log:  
in the browser console there is error  
POST [https://www.bkalut.co.il/mailme/form/submit?formId=11](https://www.bkalut.co.il/mailme/form/submit?formId=11) 500 (Internal Server Error)

in the log file i see this error don’t knoe if there is any connection  
[2023-11-26 19:15:02] console.ERROR: Error thrown while running command “mautic:segments:update”. Message: “An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory” {“exception”:“[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:93, Doctrine\DBAL\Driver\PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31, PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27)”,“command”:“mautic:segments:update”,“message”:“An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory”}

Steps I have tried to fix the problem: clear cache, reinstall mysql ,reboot server

---

<div class="post-metadata">

**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:** [November 27, 2023, 5:55am UTC](https://forum.mautic.org/t/problem-with-send-form/30043/2 "2023-11-27T05:55:04Z")

</div>

Hello all these errors are connected with you MySql being not available. How large is your db (number of contacts) how many cores you have and what is your ram like?

Also maybe your Mautic install is broken - missing drivers?

---

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 27, 2023, 6:31am UTC](https://forum.mautic.org/t/problem-with-send-form/30043/3 "2023-11-27T06:31:31Z")

</div>

i have 2289 contacts. 1024 ram 75% used. how can i know if my mautic missing or broken? it works fine till now nd sometimes return to work when i do nothing and again stop working

---

<div class="post-metadata">

**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:** [November 27, 2023, 3:14pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/4 "2023-11-27T15:14:12Z")

</div>

> [@mtnlvy](#):
>
> ver: SQLSTATE[HY000] [2002]

Ok. Depends what you are trying to do with your 2000 contacts.  
For me it seems mysql is unstable.

---

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 27, 2023, 5:45pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/5 "2023-11-27T17:45:21Z")

</div>

so how can i solve it. mysql working for me fine in all other apps in my server!

---

<div class="post-metadata">

**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:** [November 28, 2023, 5:55am UTC](https://forum.mautic.org/t/problem-with-send-form/30043/6 "2023-11-28T05:55:21Z")

</div>

Well,

Mautic is really not like other software, don’t even compare it with wordpress for example.

I can see, that your Mautic is not happy when you try to update your segments.  
Mysql is going away.during this activity. How heavy the load is when you try to recalculate your segments, depends on the number of contacts (you mentioned it’s around 2000) and the amount and structure of your segments.  
For example if you have filters which includes “contain” rules, then it is more resource intensive as a simple “starts with” rule. If you have many filters in your segement, that can also lead to issues. If you have many segments for your 2k contacts, that is also mysql db heavy.  
When you say your Memory is 75% used, that is just a snaphot of your memory. In real life this is fluctuating. When you tell your DB to recalculate all contacts in the system, a chain of querries are launched, which can cause 10x larger load on your memory and processor. If mysql doesn’t hope for a response during this over demanding task, then just throws away everything, and times out.  
I have installed Mautic on a Raspberry PI 3 before, and did some benchmarking. It is very slow, even I didn’t have any other software running on it.  
Your best way to move forward is to get a better server. Here are the minimum requirements according to my experience:  
[https://joeykeller.com/docs/self-hosted-mautic/getting-started/general/](https://joeykeller.com/docs/self-hosted-mautic/getting-started/general/)  
Click on server requirements on the left.  
I hope this helps.

---

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 28, 2023, 6:57am UTC](https://forum.mautic.org/t/problem-with-send-form/30043/7 "2023-11-28T06:57:37Z")

</div>

thank you very much.  
what about my other problem - form not post - only send data to mautic but no mail beind sent. in the broser console i see error 500.

www.bkalut.co.il/mailme/form/submit?formId=13:1

```
   POST https://www.bkalut.co.il/mailme/form/submit?formId=13 500 (Internal Server Error)

```

you can see it yourself in this example  
[https://bkalut.co.il/example.php](https://bkalut.co.il/example.php)  
i have mautic for 3 years and no problem till the last monthes  
thank you very much

---

<div class="post-metadata">

**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:** [November 28, 2023, 11:48am UTC](https://forum.mautic.org/t/problem-with-send-form/30043/8 "2023-11-28T11:48:00Z")

</div>

Check the relevant logs in /var/logs  
We need to see what is the issue with that form

---

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 28, 2023, 1:45pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/9 "2023-11-28T13:45:26Z")

</div>

thank you very much  
the relevant error in log is  
[2023-11-28 15:44:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO email\_stats (email\_address, date\_sent, is\_read, is\_failed, viewed\_in\_browser, date\_read, tracking\_hash, retry\_count, source, source\_id, tokens, open\_count, last\_opened, open\_details, email\_id, lead\_id, list\_id, ip\_id, copy\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“[mtnlvys@gmail.com](mailto:mtnlvys@gmail.com)”, “2023-11-28 13:44:10”, 0, 0, 0, null, “6565eeaa207f3300027740”, 0, “form”, 13, “a:18:{s:14:"{formfield=sm}";s:19:"\u05d0\u05dc\u05d9\u05e9\u05d1\u05e2 \u05dc\u05d5\u05d9";s:17:"{formfield=ymyyl}";s:17:"mtnlvys@gmail.com";s:17:"{formfield=tlpwn}";s:8:"02222222";s:16:"{formfield=page}";s:31:"ttps://bkalut.co.il/example.php";s:19:"{formfield=twr\_qzr}";s:10:"\u05d1\u05d3\u05d9\u05d7\u05d4";s:36:"{dynamiccontent="Dynamic Content 1"}";s:23:"Default Dynamic Content";s:18:"{unsubscribe\_text}";s:293:"\<a href="https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740"\>\u05d4\u05e1\u05e8 \u05d0\u05d5\u05ea\u05d9 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8\</a\> \u05dc\u05d0 \u05de\u05e2\u05d5\u05e0\u05d9\u05d9\u05e0\u05d9\u05dd \u05dc\u05e7\u05d1\u05dc \u05de\u05de\u05e0\u05d9 \u05de\u05d9\u05d9\u05dc\u05d9\u05dd \u05d0\u05d9\u05df \u05d1\u05e2\u05d9\u05d4 \u05d0\u05e0\u05d9 \u05dc\u05d0 \u05e0\u05e2\u05dc\u05d1 \u05e8\u05e7 \u05dc\u05dc\u05d7\u05d5\u05e5 \u05db\u05dc \u05d4\u05e7\u05d9\u05e9\u05d5\u05e8 \u05d5\u05ea\u05d5\u05e1\u05e8\u05d5 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8";s:17:"{unsubscribe\_url}";s:72:"https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740";s:14:"{webview\_text}";s:126:"\<a href="https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740"\>Having trouble reading this email? Click here.\</a\>";s:13:"{webview\_url}";s:65:"https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740";s:11:"{signature}";s:27:"Best regards, \u05de\u05ea\u05df \u05dc\u05d5\u05d9";s:9:"{subject}";s:45:"\u05d4\u05e4\u05e0\u05d9\u05d9\u05d4 \u05e9\u05dc\u05da \u05d4\u05ea\u05e7\u05d1\u05dc\u05d4 \u05d1\u05d4\u05e6\u05dc\u05d7\u05d4";s:18:"{ownerfield=email}";s:0:"";s:22:"{ownerfield=firstname}";s:0:"";s:21:"{ownerfield=lastname}";s:0:"";s:21:"{ownerfield=position}";s:0:"";s:22:"{ownerfield=signature}";s:0:"";s:16:"{tracking\_pixel}";s:64:"https://www.bkalut.co.il/mailme/email/6565eeaa207f3300027740.gif";}”, 0, null, “a:0:{}”, 2, “5138”, null, null, “75a88c9c51e8eb3b99a1aa2224fd2282”]: SQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value” at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 {“exception”:“[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO email\_stats (email\_address, date\_sent, is\_read, is\_failed, viewed\_in\_browser, date\_read, tracking\_hash, retry\_count, source, source\_id, tokens, open\_count, last\_opened, open\_details, email\_id, lead\_id, list\_id, ip\_id, copy\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["mtnlvys@gmail.com", "2023-11-28 13:44:10", 0, 0, 0, null, "6565eeaa207f3300027740", 0, "form", 13, "a:18:{s:14:\"{formfield=sm}\";s:19:\"\u05d0\u05dc\u05d9\u05e9\u05d1\u05e2 \u05dc\u05d5\u05d9\";s:17:\"{formfield=ymyyl}\";s:17:\"mtnlvys@gmail.com\";s:17:\"{formfield=tlpwn}\";s:8:\"02222222\";s:16:\"{formfield=page}\";s:31:\"ttps:\/\/bkalut.co.il\/example.php\";s:19:\"{formfield=twr\_qzr}\";s:10:\"\u05d1\u05d3\u05d9\u05d7\u05d4\";s:36:\"{dynamiccontent=\"Dynamic Content 1\"}\";s:23:\"Default Dynamic Content\";s:18:\"{unsubscribe\_text}\";s:293:\"\<a href=\"https:\/\/www.bkalut.co.il\/mailme\/email\/unsubscribe\/6565eeaa207f3300027740\"\>\u05d4\u05e1\u05e8 \u05d0\u05d5\u05ea\u05d9 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8\<\/a\> \u05dc\u05d0 \u05de\u05e2\u05d5\u05e0\u05d9\u05d9\u05e0\u05d9\u05dd \u05dc\u05e7\u05d1\u05dc \u05de\u05de\u05e0\u05d9 \u05de\u05d9\u05d9\u05dc\u05d9\u05dd \u05d0\u05d9\u05df \u05d1\u05e2\u05d9\u05d4 \u05d0\u05e0\u05d9 \u05dc\u05d0 \u05e0\u05e2\u05dc\u05d1 \u05e8\u05e7 \u05dc\u05dc\u05d7\u05d5\u05e5 \u05db\u05dc \u05d4\u05e7\u05d9\u05e9\u05d5\u05e8 \u05d5\u05ea\u05d5\u05e1\u05e8\u05d5 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8\";s:17:\"{unsubscribe\_url}\";s:72:\"https:\/\/www.bkalut.co.il\/mailme\/email\/unsubscribe\/6565eeaa207f3300027740\";s:14:\"{webview\_text}\";s:126:\"\<a href=\"https:\/\/www.bkalut.co.il\/mailme\/email\/view\/6565eeaa207f3300027740\"\>Having trouble reading this email? Click here.\<\/a\>\";s:13:\"{webview\_url}\";s:65:\"https:\/\/www.bkalut.co.il\/mailme\/email\/view\/6565eeaa207f3300027740\";s:11:\"{signature}\";s:27:\"Best regards, \u05de\u05ea\u05df \u05dc\u05d5\u05d9\";s:9:\"{subject}\";s:45:\"\u05d4\u05e4\u05e0\u05d9\u05d9\u05d4 \u05e9\u05dc\u05da \u05d4\u05ea\u05e7\u05d1\u05dc\u05d4 \u05d1\u05d4\u05e6\u05dc\u05d7\u05d4\";s:18:\"{ownerfield=email}\";s:0:\"\";s:22:\"{ownerfield=firstname}\";s:0:\"\";s:21:\"{ownerfield=lastname}\";s:0:\"\";s:21:\"{ownerfield=position}\";s:0:\"\";s:22:\"{ownerfield=signature}\";s:0:\"\";s:16:\"{tracking\_pixel}\";s:64:\"https:\/\/www.bkalut.co.il\/mailme\/email\/6565eeaa207f3300027740.gif\";}", 0, null, "a:0:{}", 2, "5138", null, null, "75a88c9c51e8eb3b99a1aa2224fd2282"]:\n\nSQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}

---

<div class="post-metadata">

**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:** [November 28, 2023, 3:09pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/10 "2023-11-28T15:09:59Z")

</div>

> [@mtnlvy](#):
>
> generated\_sent\_date’ doesn’t have a default value

Your Mautic cannot add a new line to sent emails.  
I checked my Mautic, and I also don’t have default there, but it works for me…

---

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 28, 2023, 5:41pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/11 "2023-11-28T17:41:04Z")

</div>

do you have any idea what the problem is?

---

<div class="post-metadata">

**Author:** ![mtnlvy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mtnlvy/32/6490_2.png) [@mtnlvy](https://forum.mautic.org/u/mtnlvy)\
**Post date:** [November 30, 2023, 7:04am UTC](https://forum.mautic.org/t/problem-with-send-form/30043/12 "2023-11-30T07:04:10Z")

</div>

anyone have a solution?  
here is the log  
[2023-11-28 15:44:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO email\_stats (email\_address, date\_sent, is\_read, is\_failed, viewed\_in\_browser, date\_read, tracking\_hash, retry\_count, source, source\_id, tokens, open\_count, last\_opened, open\_details, email\_id, lead\_id, list\_id, ip\_id, copy\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“[mtnlvys@gmail.com](mailto:mtnlvys@gmail.com)”, “2023-11-28 13:44:10”, 0, 0, 0, null, “6565eeaa207f3300027740”, 0, “form”, 13, “a:18:{s:14:“{formfield=sm}”;s:19:“\u05d0\u05dc\u05d9\u05e9\u05d1\u05e2 \u05dc\u05d5\u05d9”;s:17:“{formfield=ymyyl}”;s:17:"mtnlvys@gmail.com";s:17:“{formfield=tlpwn}”;s:8:“02222222”;s:16:“{formfield=page}”;s:31:“ttps://bkalut.co.il/example.php”;s:19:“{formfield=twr\_qzr}”;s:10:“\u05d1\u05d3\u05d9\u05d7\u05d4”;s:36:“{dynamiccontent=“Dynamic Content 1”}”;s:23:“Default Dynamic Content”;s:18:“{unsubscribe\_text}”;s:293:“[\u05d4\u05e1\u05e8 \u05d0\u05d5\u05ea\u05d9 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8](https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740) \u05dc\u05d0 \u05de\u05e2\u05d5\u05e0\u05d9\u05d9\u05e0\u05d9\u05dd \u05dc\u05e7\u05d1\u05dc \u05de\u05de\u05e0\u05d9 \u05de\u05d9\u05d9\u05dc\u05d9\u05dd \u05d0\u05d9\u05df \u05d1\u05e2\u05d9\u05d4 \u05d0\u05e0\u05d9 \u05dc\u05d0 \u05e0\u05e2\u05dc\u05d1 \u05e8\u05e7 \u05dc\u05dc\u05d7\u05d5\u05e5 \u05db\u05dc \u05d4\u05e7\u05d9\u05e9\u05d5\u05e8 \u05d5\u05ea\u05d5\u05e1\u05e8\u05d5 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8”;s:17:“{unsubscribe\_url}”;s:72:“[https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740";s:14:“{webview\_text}”;s:126:"](https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740%22;s:14:%22%7Bwebview_text%7D%22;s:126:%22)[Having trouble reading this email? Click here.](https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740)”;s:13:“{webview\_url}”;s:65:“[https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740";s:11:“{signature}”;s:27:"Best](https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740%22;s:11:%22%7Bsignature%7D%22;s:27:%22Best) regards, \u05de\u05ea\u05df \u05dc\u05d5\u05d9”;s:9:“{subject}”;s:45:“\u05d4\u05e4\u05e0\u05d9\u05d9\u05d4 \u05e9\u05dc\u05da \u05d4\u05ea\u05e7\u05d1\u05dc\u05d4 \u05d1\u05d4\u05e6\u05dc\u05d7\u05d4”;s:18:“{ownerfield=email}”;s:0:“”;s:22:“{ownerfield=firstname}”;s:0:“”;s:21:“{ownerfield=lastname}”;s:0:“”;s:21:“{ownerfield=position}”;s:0:“”;s:22:“{ownerfield=signature}”;s:0:“”;s:16:“{tracking\_pixel}”;s:64:“[https://www.bkalut.co.il/mailme/email/6565eeaa207f3300027740.gif](https://www.bkalut.co.il/mailme/email/6565eeaa207f3300027740.gif)”;}”, 0, null, “a:0:{}”, 2, “5138”, null, null, “75a88c9c51e8eb3b99a1aa2224fd2282”]: SQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value” at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 {“exception”:“[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO email\_stats (email\_address, date\_sent, is\_read, is\_failed, viewed\_in\_browser, date\_read, tracking\_hash, retry\_count, source, source\_id, tokens, open\_count, last\_opened, open\_details, email\_id, lead\_id, list\_id, ip\_id, copy\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“[mtnlvys@gmail.com](mailto:mtnlvys@gmail.com)”, “2023-11-28 13:44:10”, 0, 0, 0, null, “6565eeaa207f3300027740”, 0, “form”, 13, “a:18:{s:14:"{formfield=sm}";s:19:"\u05d0\u05dc\u05d9\u05e9\u05d1\u05e2 \u05dc\u05d5\u05d9";s:17:"{formfield=ymyyl}";s:17:"mtnlvys@gmail.com";s:17:"{formfield=tlpwn}";s:8:"02222222";s:16:"{formfield=page}";s:31:"ttps://bkalut.co.il/example.php";s:19:"{formfield=twr\_qzr}";s:10:"\u05d1\u05d3\u05d9\u05d7\u05d4";s:36:"{dynamiccontent="Dynamic Content 1"}";s:23:"Default Dynamic Content";s:18:"{unsubscribe\_text}";s:293:"\<a href="https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740"\>\u05d4\u05e1\u05e8 \u05d0\u05d5\u05ea\u05d9 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8\</a\> \u05dc\u05d0 \u05de\u05e2\u05d5\u05e0\u05d9\u05d9\u05e0\u05d9\u05dd \u05dc\u05e7\u05d1\u05dc \u05de\u05de\u05e0\u05d9 \u05de\u05d9\u05d9\u05dc\u05d9\u05dd \u05d0\u05d9\u05df \u05d1\u05e2\u05d9\u05d4 \u05d0\u05e0\u05d9 \u05dc\u05d0 \u05e0\u05e2\u05dc\u05d1 \u05e8\u05e7 \u05dc\u05dc\u05d7\u05d5\u05e5 \u05db\u05dc \u05d4\u05e7\u05d9\u05e9\u05d5\u05e8 \u05d5\u05ea\u05d5\u05e1\u05e8\u05d5 \u05de\u05e8\u05e9\u05d9\u05de\u05ea \u05d4\u05d3\u05d9\u05d5\u05d5\u05e8";s:17:"{unsubscribe\_url}";s:72:"https://www.bkalut.co.il/mailme/email/unsubscribe/6565eeaa207f3300027740";s:14:"{webview\_text}";s:126:"\<a href="https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740"\>Having trouble reading this email? Click here.\</a\>";s:13:"{webview\_url}";s:65:"https://www.bkalut.co.il/mailme/email/view/6565eeaa207f3300027740";s:11:"{signature}";s:27:"Best regards, \u05de\u05ea\u05df \u05dc\u05d5\u05d9";s:9:"{subject}";s:45:"\u05d4\u05e4\u05e0\u05d9\u05d9\u05d4 \u05e9\u05dc\u05da \u05d4\u05ea\u05e7\u05d1\u05dc\u05d4 \u05d1\u05d4\u05e6\u05dc\u05d7\u05d4";s:18:"{ownerfield=email}";s:0:"";s:22:"{ownerfield=firstname}";s:0:"";s:21:"{ownerfield=lastname}";s:0:"";s:21:"{ownerfield=position}";s:0:"";s:22:"{ownerfield=signature}";s:0:"";s:16:"{tracking\_pixel}";s:64:"https://www.bkalut.co.il/mailme/email/6565eeaa207f3300027740.gif";}”, 0, null, “a:0:{}”, 2, “5138”, null, null, “75a88c9c51e8eb3b99a1aa2224fd2282”]:\n\nSQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1364 Field ‘generated\_sent\_date’ doesn’t have a default value at /home/mtnlvy/public\_html/bkalut.co.il/mailme/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}

---

<div class="post-metadata">

**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:** [November 30, 2023, 12:54pm UTC](https://forum.mautic.org/t/problem-with-send-form/30043/13 "2023-11-30T12:54:48Z")

</div>

Since the error seems to be:

> [@mtnlvy](#):
>
> Field ‘generated\_sent\_date’ doesn’t have a default value

I would proceed with this mysql command:

`ALTER TABLE email_stats ALTER COLUMN generated_sent_date SET DEFAULT NULL;`

Plz make a backup before, but you shuld be fine. Plz anyone feel free to yell at me if I’m wrong, but this is what I would do 🙂