0
Invalid Datetime Format error
When trying to reply to a pm / creating a pm, this happens:
/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x91\x80' for column `worldofpotter_com`.`pm_messages`.`message` at row 1
#0 /app/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() #1 /app/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException() #2 /app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2121): Doctrine\DBAL\DBALException::driverExceptionDuringQuery() #3 /app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(173): Doctrine\DBAL\Connection->handleExceptionDuringQuery() #4 /app/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(287): Doctrine\DBAL\Statement->execute() #5 /app/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1119): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() #6 /app/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(420): Doctrine\ORM\UnitOfWork->executeInserts() #7 /app/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(383): Doctrine\ORM\UnitOfWork->commit() #8 /app/vendor/eye4web/eye4web-zfc-user-pm/src/Eye4web/ZfcUser/Pm/Mapper/DoctrineORM/PmMapper.php(340): Doctrine\ORM\EntityManager->flush() #9 /app/vendor/eye4web/eye4web-zfc-user-pm/src/Eye4web/ZfcUser/Pm/Service/PmService.php(373): Eye4web\ZfcUser\Pm\Mapper\DoctrineORM\PmMapper->newMessage() #10 /app/vendor/eye4web/eye4web-zfc-user-pm/src/Eye4web/ZfcUser/Pm/Controller/PmController.php(171): Eye4web\ZfcUser\Pm\Service\PmService->newMessage() #11 /app/module/Application/src/Application/Controller/OwlsController.php(86): Eye4web\ZfcUser\Pm\Controller\PmController->readConversationAction() #12 /app/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Application\Controller\OwlsController->readConversationAction() #13 /app/vendor/laminas/laminas-eventmanager/src/EventManager.php(331): Laminas\Mvc\Controller\AbstractActionController->onDispatch() #14 /app/vendor/laminas/laminas-eventmanager/src/EventManager.php(188): Laminas\EventManager\EventManager->triggerListeners() #15 /app/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil() #16 /app/vendor/laminas/laminas-mvc/src/DispatchListener.php(138): Laminas\Mvc\Controller\AbstractController->dispatch() #17 /app/vendor/laminas/laminas-eventmanager/src/EventManager.php(331): Laminas\Mvc\DispatchListener->onDispatch() #18 /app/vendor/laminas/laminas-eventmanager/src/EventManager.php(188): Laminas\EventManager\EventManager->triggerListeners() #19 /app/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil() #20 /app/public/index.php(103): Laminas\Mvc\Application->run() #21 {main}
/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
etc. This has happened twice to me while attempting to owl people / reply to owls. I don't know if this is an already reported bug, just putting it out there 👀
OS: macOS Ventura 13.2.1
Browser: firefox 112.0.2 (64-bit)
To reproduce: Sending pms?
Customer support service by UserEcho