Problem with send form

Product Support
1

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
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 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

2

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?

3

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

4

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

5

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

6

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/
Click on server requirements on the left.
I hope this helps.

1 Like
7

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
i have mautic for 3 years and no problem till the last monthes
thank you very much

8

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

9

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”, “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)”}

10

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…

11

do you have any idea what the problem is?

12

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”, “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 \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:"Having trouble reading this email? Click here.”;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)”}

13

Since the error seems to be:

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 :slight_smile:

1 Like