Your software
My Mautic version is:
My PHP version is: 7.4.26
My Database type and version is: My sql
Your problem
My problem is: 500 Internal Server Error while sending mails
These errors are showing in the log:
Steps I have tried to fix the problem:
Post your log here from Gear icon > System > Log
This is my error log from mautic
[2022-01-06 05:12:51] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO audit_log (user_id, user_name, bundle, object, object_id, action, details, date_added, ip_address) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “Days CRM”, “user”, “security”, 1, “login”, “a:1:{s:8:“username”;s:20:“days@mautic.dgcrm.in”;}”, “2022-01-06 05:12:49”, “171.76.43.24”]: SQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full” at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO audit_log (user_id, user_name, bundle, object, object_id, action, details, date_added, ip_address) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “Days CRM”, “user”, “security”, 1, “login”, “a:1:{s:8:\“username\”;s:20:\“days@mautic.dgcrm.in\”;}”, “2022-01-06 05:12:49”, “171.76.43.24”]:\n\nSQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} [2022-01-06 10:50:58] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO audit_log (user_id, user_name, bundle, object, object_id, action, details, date_added, ip_address) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “Days CRM”, “user”, “security”, 1, “login”, “a:1:{s:8:“username”;s:20:“days@mautic.dgcrm.in”;}”, “2022-01-06 05:20:58”, “171.76.43.24”]: SQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full” at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO audit_log (user_id, user_name, bundle, object, object_id, action, details, date_added, ip_address) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “Days CRM”, “user”, “security”, 1, “login”, “a:1:{s:8:\“username\”;s:20:\“days@mautic.dgcrm.in\”;}”, “2022-01-06 05:20:58”, “171.76.43.24”]:\n\nSQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘audit_log’ is full at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} [2022-01-06 10:53:56] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “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 [“pegcoms1020@gmail.com”, “2022-01-06 05:23:55”, 0, 0, 0, null, “61d67ce66859a409968340”, 0, “email”, 16, “a:25:{s:36:”{dynamiccontent=“Dynamic Content 1”}”;s:23:“Default Dynamic Content”;s:18:"{unsubscribe_text}";s:127:“Unsubscribe</a> to no longer receive emails from us.";s:17:"{unsubscribe_url}";s:64:“https://mautic.dgcrm.in/email/unsubscribe/61d67ce66859a409968340”;s:14:"{webview_text}";s:118:"[Having trouble reading this email? Click here.</a>”;s:13:"{webview_url}";s:57:“https://mautic.dgcrm.in/email/view/61d67ce66859a409968340";s:11:"{signature}";s:27:"Best regards, Resume Writer”;s:9:"{subject}";s:39:“Top 5 Resume Writing Companies In India”;s:18:"{ownerfield=email}";s:20:“rwi1@mautic.dgcrm.in”;s:22:"{ownerfield=firstname}";s:6:“Resume”;s:21:"{ownerfield=lastname}";s:6:“Writer”;s:21:"{ownerfield=position}";s:0:"";s:22:"{ownerfield=signature}";s:96:“Best regards,
\r\nResume Writer India
\r\n+91 9941266601
\r\nwww.resumewriterindia.com”;s:37:"{trackable=790d5ab057473e0267345eb7a}";s:280:“https://mautic.dgcrm.in/r/790d5ab057473e0267345eb7a?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&";s:37:"{trackable=e0ad4ff62884bbb4912c5c9f4}";s:280:“https://mautic.dgcrm.in/r/e0ad4ff62884bbb4912c5c9f4?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=74ecced907f1bebedb36c4971}";s:280:“https://mautic.dgcrm.in/r/74ecced907f1bebedb36c4971?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=a44d70faa4955ef5740d3d748}";s:280:“https://mautic.dgcrm.in/r/a44d70faa4955ef5740d3d748?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=f58c35556b33b645912e86a66}";s:280:“https://mautic.dgcrm.in/r/f58c35556b33b645912e86a66?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=7d9dacac5aee78cc8b65e2124}";s:280:“https://mautic.dgcrm.in/r/7d9dacac5aee78cc8b65e2124?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=861c724271157ec2e40c6c6b8}";s:280:“https://mautic.dgcrm.in/r/861c724271157ec2e40c6c6b8?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=d735c19622fab2ed1c10e48b7}";s:280:“https://mautic.dgcrm.in/r/d735c19622fab2ed1c10e48b7?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=bf1b5ca2ca664b483f93beca7}";s:280:“https://mautic.dgcrm.in/r/bf1b5ca2ca664b483f93beca7?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=d92eff38eb7e967e4b71b1e52}";s:280:“https://mautic.dgcrm.in/r/d92eff38eb7e967e4b71b1e52?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=01a30dccbee4a50e67fd896fe}";s:280:“https://mautic.dgcrm.in/r/01a30dccbee4a50e67fd896fe?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:37:"{trackable=dfaa8d25f0c60ab262e6ba5fe}";s:280:“https://mautic.dgcrm.in/r/dfaa8d25f0c60ab262e6ba5fe?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTY7fXM6NToiZW1haWwiO2k6MTY7czo0OiJzdGF0IjtzOjIyOiI2MWQ2N2NlNjY4NTlhNDA5OTY4MzQwIjtzOjQ6ImxlYWQiO3M6NToiMzQ4NzEiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE2O319&”;s:16:"{tracking_pixel}";s:56:“https://mautic.dgcrm.in/email/61d67ce66859a409968340.gif”;}", 0, null, “a:0:{}”, 16, “34871”, 17, null, null]: SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full” at /home/dgcrm/domains/mautic.dgcrm.in/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(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 “pegcoms1020@gmail.com”, “2022-01-06 05:23:55”, 0, 0, 0, null, “61d67ce66859a409968340”, 0, “email”, 16, “a:25:{s:36:\”{dynamiccontent=\“Dynamic Content 1\”}\";s:23:\“Default Dynamic Content\”;s:18:\"{unsubscribe_text}\";s:127:\"[Unsubscribe<\/a> to no longer receive emails from us.\";s:17:\"{unsubscribe_url}\";s:64:\“https:\/\/mautic.dgcrm.in\/email\/unsubscribe\/61d67ce66859a409968340\”;s:14:\"{webview_text}\";s:118:\"](file:///%22https://////mautic.dgcrm.in///email///unsubscribe///61d67ce66859a409968340///%22)[Having trouble reading this email? Click here.<\/a>\";s:13:\"{webview_url}\";s:57:\“https:\/\/mautic.dgcrm.in\/email\/view\/61d67ce66859a409968340\”;s:11:\"{signature}\";s:27:\“Best regards, Resume Writer\”;s:9:\"{subject}\";s:39:\“Top 5 Resume Writing Companies In India\”;s:18:\"{ownerfield=email}\";s:20:\“rwi1@mautic.dgcrm.in\”;s:22:\"{ownerfield=firstname}\";s:6:\“Resume\”;s:21:\"{ownerfield=lastname}\";s:6:\“Writer\”;s:21:\"{ownerfield=position}\";s:0:\"\";s:22:\"{ownerfield=signature}\";s:96:\"Best regards, ](file:///%22https://////mautic.dgcrm.in///email///view///61d67ce66859a409968340///%22)
To start with:
update your server (apt update / apt upgrade)
and restart mysql and your webserver
I tried as you said but still the error is showing
Okay.
Then let’s see what other forum visitors are saying.
