0

Invalid Datetime Format error

jimbob 1 year ago • 0

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?