XF 1.5 Mysqli statement execute error : Incorrect string value: '\xF0\x9F\xA4\x94\xF0\x9F ...

[7emper5i]

Hello,

unfortunately I can't find a solution to my problem using google and the internal search.

I get the following error message:

How can I solve this problem?

Best regards,
Philipp

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF0\x9F\xA4\x94\xF0\x9F...' for column 'media_title' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generiert durch: Unbekanntes Benutzerkonto, Vor 7 Minuten
Stapelverfolgung
#0 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xe...', Array)
#3 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xengallery_medi...', Array)
#4 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(453): XenForo_DataWriter->save()
#7 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(494): Akinak_VideoFeed_Model_VideoFeed->_insertFeedEntry(Array, Array, Array)
#8 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(521): Akinak_VideoFeed_Model_VideoFeed->_insertFeedData(Array, Array)
#9 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(546): Akinak_VideoFeed_Model_VideoFeed->importFeedData(Array)
#10 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/CronEntry/VideoFeeder.php(11): Akinak_VideoFeed_Model_VideoFeed->scheduledImportTimeLimited(15)
#11 [internal function]: Akinak_VideoFeed_CronEntry_VideoFeeder::importVideoFeeds(Array)
#12 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
#13 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#14 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999949932098, '')
#15 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999949932098, '', false)
#16 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#17 /home/www/doc/26278/gsx-r1000.de/www/forum/deferred.php(23): XenForo_Model_Deferred->run(false)
#18 {main}
Benötigter Status
array(3) {
  ["url"] => string(37) "https://www.gsx-r1000.de/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(26) "/media/users/kahless.3103/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

or:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xF0\x9F\xA4\x94\xF0\x9F...' for column 'media_title' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

Generiert durch: Unbekanntes Benutzerkonto, Vor einem Moment
Stapelverfolgung

#0 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xe...', Array)
#3 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xengallery_medi...', Array)
#4 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(453): XenForo_DataWriter->save()
#7 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(494): Akinak_VideoFeed_Model_VideoFeed->_insertFeedEntry(Array, Array, Array)
#8 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(521): Akinak_VideoFeed_Model_VideoFeed->_insertFeedData(Array, Array)
#9 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/Model/VideoFeed.php(546): Akinak_VideoFeed_Model_VideoFeed->importFeedData(Array)
#10 /home/www/doc/26278/gsx-r1000.de/www/forum/library/Akinak/VideoFeed/CronEntry/VideoFeeder.php(11): Akinak_VideoFeed_Model_VideoFeed->scheduledImportTimeLimited(15)
#11 [internal function]: Akinak_VideoFeed_CronEntry_VideoFeeder::importVideoFeeds(Array)
#12 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Cron.php(357): call_user_func(Array, Array)
#13 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#14 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9999949932098, '')
#15 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9999949932098, '', false)
#16 /home/www/doc/26278/gsx-r1000.de/www/forum/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#17 /home/www/doc/26278/gsx-r1000.de/www/forum/deferred.php(23): XenForo_Model_Deferred->run(false)
#18 {main}
Benötigter Status
array(3) {
  ["url"] => string(37) "https://www.gsx-r1000.de/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfRequestUri"] => string(26) "/media/users/kahless.3103/"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Chris D]

Looks like something to do with the VideoFeed add on you’re using.

 

[Martok]

The error I believe is related to this add-on:

https://xenforo.com/community/threads/embed-video-from-feed-paid-deleted.92823/

A search on Incorrect string value: for column 'media_title' pulled up similar reports in that thread. It looks like the add-on has been withdrawn/abandoned.

 

[TPerry]

Is VideoFeed an add-on?
If so, you need to address that author.
That doesn't look like a standard part of XF 1.5... don't know about XF 2... but if you are on XF 2 you may need to make sure your DB is in UTF8MB4.

 

[7emper5i]

In Germany there is a proverb that says:

"You can't see the forest for all the trees."

Thank you guys,
just deleted this add-on.