Myke623
Well-known member
What do you suggest is causing the following server error messages?With the newer versions, this issue is no longer relevant. Stream statuses are stored as blobs, which are do not have character set constraints.
Code:
Error Info:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF0\x9F\x98\x8EDE...' for column 'results' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Stack Trace:
#0 /home/foo/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/foo/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/foo/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `EWRport...', Array)
#3 /home/foo/public_html/library/XenForo/DataWriter.php(1654): Zend_Db_Adapter_Abstract->update('EWRporta_caches', Array, 'block_id = 'Str...')
#4 /home/foo/public_html/library/XenForo/DataWriter.php(1623): XenForo_DataWriter->_update()
#5 /home/foo/public_html/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/foo/public_html/library/EWRporta/Model/Caches.php(44): XenForo_DataWriter->save()
#7 /home/foo/public_html/library/EWRporta/Model/Blocks.php(122): EWRporta_Model_Caches->buildBlockCache(Array, 'a:2:{s:6:"optio...')
#8 /home/foo/public_html/library/EWRporta/ViewPublic/Custom.php(71): EWRporta_Model_Blocks->getBlockParams(Array, false)
#9 /home/foo/public_html/library/XenForo/ViewRenderer/Abstract.php(227): EWRporta_ViewPublic_Custom->renderHtml()
#10 /home/foo/public_html/library/XenForo/ViewRenderer/HtmlPublic.php(71): XenForo_ViewRenderer_Abstract->renderViewObject('XenForo_ViewPub...', 'Html', Array, 'thread_view')
#11 /home/foo/public_html/library/XenForo/FrontController.php(607): XenForo_ViewRenderer_HtmlPublic->renderView('XenForo_ViewPub...', Array, 'thread_view', NULL)
#12 /home/foo/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#13 /home/foo/public_html/index.php(13): XenForo_FrontController->run()
#14 {main}
The incorrect string value of \xF0\x9F\x98\x8E appears to be the byte value for the "smiling face with sunglasses" emoji, which made my think of a collation conflict, but after further inspection the issue seems to be more related to your (unmaintained) XenPorta block for XenRio (called StreamsLive). In table EWRporta_caches, the collation of the 'results' field is utf8_general_ci, but I'm exactly sure how/why an emoji is trying to get into this field?