Your software
My Mautic version is: 4.0.0
My PHP version is: 7.4.23
My Database type and version is: mysql Ver 15.1 Distrib 10.2.40-MariaDB, for Linux (x86_64)
Your problem
My problem is: exception when running social:monitoring command
These errors are showing in the log:
/usr/bin/php /var/www/html/mautic/bin/console mautic:social:monitoring -vvv
Executing Monitor Item 1
No new tweets
Result Code: 0
Executing Monitor Item 2
Creating new lead
An exception occurred while executing 'INSERT INTO leads (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, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?,
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x8C\x8D \x0A…’ for column mautic.leads.social_cache at row 1
In ORMException.php line 145:
[Doctrine\ORM\ORMException]
The EntityManager is closed.
Exception trace:
at /var/www/html/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:145
Doctrine\ORM\ORMException::entityManagerClosed() at /var/www/html/mautic/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:809
Steps I have tried to fix the problem:
disable twitter hashtags monitoring