Import Contact : Unable to read the imported csv file

Product Support
1

Your software
My Mautic version is: Latest
My PHP version is: PHP Version 7.3.28
My Database type and version is: Mariadb

Your problem
My problem is:

Unable to read the imported csv file.

These errors are showing in the log:

[2022-12-21 01:10:17] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)“}
[2022-12-21 01:42:51] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)”}
[2022-12-21 03:10:21] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)“}
[2022-12-21 03:14:28] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)”}
[2022-12-21 03:52:33] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)“}
[2022-12-21 05:30:47] mautic.ERROR: An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2022-12-21 05:30:47”, null, null, null, null, null, null, “200”, null, null, null, null, null, null, “a:0:{}”, “i2kxd9b3se0z0x364o23z02”, null, null, “a:9:{s:10:"page_title";s:62:"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered";s:13:"page_language";s:5:"en-IN";s:13:"page_referrer";s:16:"www.google.co.in";s:8:"page_url";s:42:"https://abanahomes.com/banyan-bonsai-tree/";s:7:"counter";s:1:"0";s:15:"timezone_offset";s:4:"-330";s:10:"resolution";s:7:"414x896";s:8:"platform";s:5:"MacOS";s:12:"do_not_track";s:5:"false";}”, null, null, null, null, 259361, “195928”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 {“exception”:”[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2022-12-21 05:30:47", null, null, null, null, null, null, "200", null, null, null, null, null, null, "a:0:{}", "i2kxd9b3se0z0x364o23z02", null, null, "a:9:{s:10:\"page_title\";s:62:\"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered\";s:13:\"page_language\";s:5:\"en-IN\";s:13:\"page_referrer\";s:16:\"www.google.co.in\";s:8:\"page_url\";s:42:\"https:\/\/abanahomes.com\/banyan-bonsai-tree\/\";s:7:\"counter\";s:1:\"0\";s:15:\"timezone_offset\";s:4:\"-330\";s:10:\"resolution\";s:7:\"414x896\";s:8:\"platform\";s:5:\"MacOS\";s:12:\"do_not_track\";s:5:\"false\";}", null, null, null, null, 259361, "195928"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)“}
[2022-12-21 05:30:47] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\ORMException: “The EntityManager is closed.” at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php line 144 {“exception”:”[object] (Doctrine\ORM\ORMException(code: 0): The EntityManager is closed. at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144)“}
[2022-12-21 11:00:48] mautic.ERROR: An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2022-12-21 05:30:48”, null, null, null, null, null, null, “200”, null, null, null, null, null, null, “a:0:{}”, “i2kxd9b3se0z0x364o23z02”, null, null, “a:9:{s:10:"page_title";s:62:"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered";s:13:"page_language";s:5:"en-IN";s:13:"page_referrer";s:16:"www.google.co.in";s:8:"page_url";s:42:"https://abanahomes.com/banyan-bonsai-tree/";s:7:"counter";s:1:"0";s:15:"timezone_offset";s:4:"-330";s:10:"resolution";s:7:"414x896";s:8:"platform";s:5:"MacOS";s:12:"do_not_track";s:5:"false";}”, null, null, null, null, 259361, “195928”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 {“exception”:”[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2022-12-21 05:30:48", null, null, null, null, null, null, "200", null, null, null, null, null, null, "a:0:{}", "i2kxd9b3se0z0x364o23z02", null, null, "a:9:{s:10:\"page_title\";s:62:\"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered\";s:13:\"page_language\";s:5:\"en-IN\";s:13:\"page_referrer\";s:16:\"www.google.co.in\";s:8:\"page_url\";s:42:\"https:\/\/abanahomes.com\/banyan-bonsai-tree\/\";s:7:\"counter\";s:1:\"0\";s:15:\"timezone_offset\";s:4:\"-330\";s:10:\"resolution\";s:7:\"414x896\";s:8:\"platform\";s:5:\"MacOS\";s:12:\"do_not_track\";s:5:\"false\";}", null, null, null, null, 259361, "195928"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)“}
[2022-12-21 11:00:48] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\ORMException: “The EntityManager is closed.” at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php line 144 {“exception”:”[object] (Doctrine\ORM\ORMException(code: 0): The EntityManager is closed. at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144)“}
[2022-12-21 05:32:00] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)”}
[2022-12-21 05:50:10] mautic.ERROR: An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2022-12-21 05:50:10”, null, null, null, null, null, null, “200”, null, null, null, null, null, null, “a:0:{}”, “d3gpkrewau3pyw0a1fzclix”, null, null, “a:9:{s:10:"page_title";s:62:"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered";s:13:"page_language";s:5:"en-US";s:13:"page_referrer";s:14:"www.google.com";s:8:"page_url";s:42:"https://abanahomes.com/banyan-bonsai-tree/";s:7:"counter";s:1:"0";s:15:"timezone_offset";s:4:"-330";s:10:"resolution";s:9:"1280x1024";s:8:"platform";s:7:"Windows";s:12:"do_not_track";s:5:"false";}”, null, null, null, null, 259380, “195935”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2022-12-21 05:50:10", null, null, null, null, null, null, "200", null, null, null, null, null, null, "a:0:{}", "d3gpkrewau3pyw0a1fzclix", null, null, "a:9:{s:10:\"page_title\";s:62:\"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered\";s:13:\"page_language\";s:5:\"en-US\";s:13:\"page_referrer\";s:14:\"www.google.com\";s:8:\"page_url\";s:42:\"https:\/\/abanahomes.com\/banyan-bonsai-tree\/\";s:7:\"counter\";s:1:\"0\";s:15:\"timezone_offset\";s:4:\"-330\";s:10:\"resolution\";s:9:\"1280x1024\";s:8:\"platform\";s:7:\"Windows\";s:12:\"do_not_track\";s:5:\"false\";}", null, null, null, null, 259380, "195935"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}
[2022-12-21 05:50:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\ORMException: “The EntityManager is closed.” at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php line 144 {“exception”:“[object] (Doctrine\ORM\ORMException(code: 0): The EntityManager is closed. at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144)”}
[2022-12-21 11:20:10] mautic.ERROR: An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2022-12-21 05:50:10”, null, null, null, null, null, null, “200”, null, null, null, null, null, null, “a:0:{}”, “d3gpkrewau3pyw0a1fzclix”, null, null, “a:9:{s:10:"page_title";s:62:"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered";s:13:"page_language";s:5:"en-US";s:13:"page_referrer";s:14:"www.google.com";s:8:"page_url";s:42:"https://abanahomes.com/banyan-bonsai-tree/";s:7:"counter";s:1:"0";s:15:"timezone_offset";s:4:"-330";s:10:"resolution";s:9:"1280x1024";s:8:"platform";s:7:"Windows";s:12:"do_not_track";s:5:"false";}”, null, null, null, null, 259380, “195935”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2022-12-21 05:50:10", null, null, null, null, null, null, "200", null, null, null, null, null, null, "a:0:{}", "d3gpkrewau3pyw0a1fzclix", null, null, "a:9:{s:10:\"page_title\";s:62:\"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered\";s:13:\"page_language\";s:5:\"en-US\";s:13:\"page_referrer\";s:14:\"www.google.com\";s:8:\"page_url\";s:42:\"https:\/\/abanahomes.com\/banyan-bonsai-tree\/\";s:7:\"counter\";s:1:\"0\";s:15:\"timezone_offset\";s:4:\"-330\";s:10:\"resolution\";s:9:\"1280x1024\";s:8:\"platform\";s:7:\"Windows\";s:12:\"do_not_track\";s:5:\"false\";}", null, null, null, null, 259380, "195935"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}
[2022-12-21 11:20:10] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\ORMException: “The EntityManager is closed.” at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php line 144 {“exception”:“[object] (Doctrine\ORM\ORMException(code: 0): The EntityManager is closed. at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144)”}
[2022-12-21 06:19:01] mautic.ERROR: An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2022-12-21 06:19:01”, null, null, null, null, null, null, “200”, null, null, null, null, null, null, “a:0:{}”, “t91ccyqz1l2l5l0fe1ylamc”, null, null, “a:9:{s:10:"page_title";s:62:"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered";s:13:"page_language";s:5:"en-US";s:13:"page_referrer";s:14:"www.google.com";s:8:"page_url";s:42:"https://abanahomes.com/banyan-bonsai-tree/";s:7:"counter";s:1:"0";s:15:"timezone_offset";s:4:"-330";s:10:"resolution";s:8:"1440x900";s:8:"platform";s:5:"MacOS";s:12:"do_not_track";s:4:"true";}”, null, null, null, null, 259401, “195950”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2022-12-21 06:19:01", null, null, null, null, null, null, "200", null, null, null, null, null, null, "a:0:{}", "t91ccyqz1l2l5l0fe1ylamc", null, null, "a:9:{s:10:\"page_title\";s:62:\"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered\";s:13:\"page_language\";s:5:\"en-US\";s:13:\"page_referrer\";s:14:\"www.google.com\";s:8:\"page_url\";s:42:\"https:\/\/abanahomes.com\/banyan-bonsai-tree\/\";s:7:\"counter\";s:1:\"0\";s:15:\"timezone_offset\";s:4:\"-330\";s:10:\"resolution\";s:8:\"1440x900\";s:8:\"platform\";s:5:\"MacOS\";s:12:\"do_not_track\";s:4:\"true\";}", null, null, null, null, 259401, "195950"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}
[2022-12-21 06:19:01] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\ORMException: “The EntityManager is closed.” at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php line 144 {“exception”:“[object] (Doctrine\ORM\ORMException(code: 0): The EntityManager is closed. at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144)”}
[2022-12-21 11:49:02] mautic.ERROR: An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“2022-12-21 06:19:02”, null, null, null, null, null, null, “200”, null, null, null, null, null, null, “a:0:{}”, “t91ccyqz1l2l5l0fe1ylamc”, null, null, “a:9:{s:10:"page_title";s:62:"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered";s:13:"page_language";s:5:"en-US";s:13:"page_referrer";s:14:"www.google.com";s:8:"page_url";s:42:"https://abanahomes.com/banyan-bonsai-tree/";s:7:"counter";s:1:"0";s:15:"timezone_offset";s:4:"-330";s:10:"resolution";s:8:"1440x900";s:8:"platform";s:5:"MacOS";s:12:"do_not_track";s:4:"true";}”, null, null, null, null, 259401, “195950”]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 {“exception”:“[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO mautipage_hits (date_hit, date_left, country, region, city, isp, organization, code, referer, url, url_title, user_agent, remote_host, page_language, browser_languages, tracking_id, source, source_id, query, page_id, redirect_id, email_id, lead_id, ip_id, device_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params ["2022-12-21 06:19:02", null, null, null, null, null, null, "200", null, null, null, null, null, null, "a:0:{}", "t91ccyqz1l2l5l0fe1ylamc", null, null, "a:9:{s:10:\"page_title\";s:62:\"Buy Banyan Tree Bonsai \ud83c\udf33 in India, 50,000+ Plants Delivered\";s:13:\"page_language\";s:5:\"en-US\";s:13:\"page_referrer\";s:14:\"www.google.com\";s:8:\"page_url\";s:42:\"https:\/\/abanahomes.com\/banyan-bonsai-tree\/\";s:7:\"counter\";s:1:\"0\";s:15:\"timezone_offset\";s:4:\"-330\";s:10:\"resolution\";s:8:\"1440x900\";s:8:\"platform\";s:5:\"MacOS\";s:12:\"do_not_track\";s:4:\"true\";}", null, null, null, null, 259401, "195950"]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\xB3 i…’ for column bitnami_mautic.mautipage_hits.query at row 1 at /opt/bitnami/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}
[2022-12-21 11:49:02] mautic.CRITICAL: Uncaught PHP Exception Doctrine\ORM\ORMException: “The EntityManager is closed.” at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php line 144 {“exception”:“[object] (Doctrine\ORM\ORMException(code: 0): The EntityManager is closed. at /opt/bitnami/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144)”}
[2022-12-21 06:38:32] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)“}
[2022-12-21 06:42:58] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)”}
[2022-12-21 06:44:04] mautic.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\HttpException: “Key ‘Type’ not found in payload " at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php line 81 {“exception”:”[object] (Symfony\Component\HttpKernel\Exception\HttpException(code: 0): Key ‘Type’ not found in payload at /opt/bitnami/mautic/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php:81)"}

Steps I have tried to fix the problem:

tried changing the file permissions of /var/tmp but unsuccessful.