1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Server Error

Discussion in 'Troubleshooting and Problems' started by Kaiser, Apr 16, 2011.

  1. Kaiser

    Kaiser Well-Known Member

    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) { }
     
  2. Kaiser

    Kaiser Well-Known Member

    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.
     
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
  4. Kaiser

    Kaiser Well-Known Member

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

    Jake Bunce XenForo Moderator Staff Member

Share This Page