@Jaxel ive found this bug issue trying to upload a youtube that had a couple emojis in it.....removing them then the upload went thru...
- XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x94\x8D C...' for column
database_name
.ewr_medio_media
.media_description
at row 1
- src/XF/Db/AbstractStatement.php:230
- Feb 10, 2025 at 9:51 PM
Stack trace
INSERT INTO
ewr_medio_media
(
service_id
,
service_val1
,
service_val2
,
category_id
,
media_title
,
media_duration
,
media_description
,
user_id
,
username
,
media_date
,
media_state
,
media_comments
,
media_views
,
media_custom1
,
media_custom2
,
media_custom3
,
media_custom4
,
media_custom5
,
reaction_score
,
reactions
,
reaction_users
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `e...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1572): XF\Db\AbstractAdapter->insert('ewr_medio_media', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1300): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Mvc/FormAction.php(72): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Mvc/FormAction.php(190): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
#8 src/addons/EWR/Medio/Pub/Controller/Media.php(560): XF\Mvc\FormAction->run()
#9 src/XF/Mvc/Dispatcher.php(362): EWR\Medio\Pub\Controller\Media->actionSave(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('EWR\\Medio:Media', 'Save', Object(XF\Mvc\RouteMatch), Object(EWR\Medio\Pub\Controller\Media), NULL)
#11 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(EWR\Medio\Pub\Controller\Media), NULL)
#12 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#14 src/XF.php(806): XF\App->run()
#15 index.php(23): XF::runApp('XF\\Pub\\App')
#16 {main}