Server Error

[Kaiser]

I posted this in another thread but didnt get any help... My server error logs are filled with this one error

http://xenforo.com/community/threads/registered-feeds-spamming-same-post.14701/

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xD9\x8A\xD8\xB3\xD8\xB9...' for column 'message' at row 1 -library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 7 minutes ago

Stack Trace​

#0 /home/adminbbo/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array) #1 /home/adminbbo/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/adminbbo/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array) #3 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1500): Zend_Db_Adapter_Abstract->insert('xf_post', Array) #4 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1489): XenForo_DataWriter->_insert() #5 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1291): XenForo_DataWriter->_save() #6 /home/adminbbo/public_html/library/XenForo/DataWriter/Discussion.php(407): XenForo_DataWriter->save() #7 /home/adminbbo/public_html/library/XenForo/DataWriter/Discussion.php(355): XenForo_DataWriter_Discussion->_saveFirstMessageDw() #8 /home/adminbbo/public_html/library/XenForo/DataWriter.php(1295): XenForo_DataWriter_Discussion->_postSave() #9 /home/adminbbo/public_html/library/XenForo/Model/Feed.php(462): XenForo_DataWriter->save() #10 /home/adminbbo/public_html/library/XenForo/Model/Feed.php(496): XenForo_Model_Feed->_insertFeedEntry(Array, Array, Array) #11 /home/adminbbo/public_html/library/XenForo/Model/Feed.php(523): XenForo_Model_Feed->_insertFeedData(Array, Array) #12 /home/adminbbo/public_html/library/XenForo/Model/Feed.php(533): XenForo_Model_Feed->importFeedData(Array) #13 /home/adminbbo/public_html/library/XenForo/CronEntry/Feeder.php(15): XenForo_Model_Feed->scheduledImport() #14 /home/adminbbo/public_html/library/XenForo/Model/Cron.php(353): XenForo_CronEntry_Feeder::importFeeds() #15 /home/adminbbo/public_html/library/XenForo/Cron.php(29): XenForo_Model_Cron->runEntry(Array) #16 /home/adminbbo/public_html/library/XenForo/Cron.php(64): XenForo_Cron->run(Array) #17 /home/adminbbo/public_html/cron.php(12): XenForo_Cron::runAndOutput() #18 {main}

Request State​

array(3) { ["url"] => string(38) "http://adminbb.org/cron.php?1302942249" ["_GET"] => array(1) { [1302942249] => string(0) "" } ["_POST"] => array(0) { }

 

[Kaiser]

Everytime I try to add the vbulletin rss feeds to my vbulletin section, it gets spammed by the same posts.. and im guessing this error has to do with it as it mentions feeds.

It keeps posting the same content over and over.

 

[Jake Bunce]

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xD9\x8A\xD8\xB3\xD8\xB9...' for column 'message' at row 1 -library/Zend/Db/Statement/Mysqli.php:214

This looks like another manifestation of the collation problem I posted about before:

http://xenforo.com/community/thread...red-please-try-again-later.14832/#post-194621

All collations throughout your database should be "utf8_general_ci". That includes all tables and columns.

Everytime I try to add the vbulletin rss feeds to my vbulletin section, it gets spammed by the same posts.. and im guessing this error has to do with it as it mentions feeds.

It keeps posting the same content over and over.

I remember your other thread about this:

http://xenforo.com/community/threads/registered-feeds-spamming-same-post.14701/

Perhaps the database error is causing the problem with duplicate RSS posts. If the execution is interrupted after the post is made but before xf_feed_log is updated then that might explain the double posts. In that case you need to fix the collations in your database to fix both the database error and the double posts.

 

[Kaiser]

This looks like another manifestation of the collation problem I posted about before:

http://xenforo.com/community/thread...red-please-try-again-later.14832/#post-194621

All collations throughout your database should be "utf8_general_ci". That includes all tables and columns.

I remember your other thread about this:

http://xenforo.com/community/threads/registered-feeds-spamming-same-post.14701/

Perhaps the database error is causing the problem with duplicate RSS posts. If the execution is interrupted after the post is made but before xf_feed_log is updated then that might explain the double posts. In that case you need to fix the collations in your database to fix both the database error and the double posts.

I have no idea how to change it, is there a query I can run to change it?

 

[Jake Bunce]

I have no idea how to change it, is there a query I can run to change it?

Just posted in your other thread:

http://xenforo.com/community/thread...ease-try-again-later.14832/page-2#post-196557