XF 1.2 Xenforo error message

[DRaver]

I have some MySQL erros in my ACP:

Incorrect string value: '\xE4t und...' for column 'message' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

How can I fix that?

 

[Paul B]

Can you post the entire contents of the error message?

 

[DRaver]

Sure:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\xE4t und...' for column 'message' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Erstellt von: Himbeerchen, Vor 55 Minuten
Stapelverfolgung
#0 /var/www/victu/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/victu/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/victu/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /var/www/victu/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_post', Array)
#4 /var/www/victu/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#5 /var/www/victu/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#6 /var/www/victu/library/XenForo/ControllerPublic/Thread.php(548): XenForo_DataWriter->save()
#7 /var/www/victu/library/Tac/StopHumanSpam/ControllerPublic/Thread.php(170): XenForo_ControllerPublic_Thread->actionAddReply()
#8 /var/www/victu/library/Tac/StopHumanSpam/ControllerPublic/Thread.php(85): Tac_StopHumanSpam_ControllerPublic_Thread->addReplyResponse(false)
#9 /var/www/victu/library/XenForo/FrontController.php(337): Tac_StopHumanSpam_ControllerPublic_Thread->actionAddReply()
#10 /var/www/victu/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /var/www/victu/index.php(13): XenForo_FrontController->run()
#12 {main}
Benötigter Status
array(3) {
  ["url"] => string(58) "http://www.mysite.net/themen/hanas-tagebuch.20130/add-reply"
  ["_GET"] => array(1) {
    ["/themen/hanas-tagebuch_20130/add-reply"] => string(0) ""
  }
  ["_POST"] => array(9) {
    ["message_html"] => string(685) "<p>Huhuu liebe hana <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie1" title="Smile    :)" alt=":)" data-smilie="yes">,</p><p>versuche mal, ob sich der Link für die Smileys hier einfügen lässt, per PN hab ich's nicht hinbekommen <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie72" title="Wide Eyed    :wideyed:" alt=":wideyed:" data-smilie="yes">.</p><p>http://www.my-site-2.de/misc.php?do=getsmilies&amp;editorid=vB_Editor_QR</p><p>Mal gucken, ob es sich hier verschicken lässt <img src="styles/default/xenforo/clear.png" class="mceSmilieSprite mceSmilie9" title="Eek!    :eek:" alt=":eek:" data-smilie="yes"><br></p>"
    ["_xfRelativeResolver"] => string(56) "http://www.mysite.net/themen/hanas-tagebuch.20130/page-53"
    ["attachment_hash"] => string(32) "fd412250b879a84a785c6c5d9b82d7d0"
    ["last_date"] => string(10) "1383563769"
    ["last_known_date"] => string(10) "1383563769"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(36) "/themen/hanas-tagebuch.20130/page-53"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }

 

[Mike]

I assume some of the text is being manipulated by an add-on -- possibly StopHumanSpam -- as the offending content isn't actually in the request itself. Might be best to ask in the add-on's thread.

 

[Chris D]

There's a chance my add-on that adds the page title to URLs during the _autoLink phase of the BB Code parser might have caused these errors too.

Are you using that? If so, what version of that add-on?

 

[DRaver]

Yes I us it in Version 1.0.6 and it´s not working correct for external links.

 

[Chris D]

Version 1.0.7 fixes most of those issues, but actually you should hold off until I release 1.0.8 as there was another case where that error might crop up. I'll be releasing that shortly.

 

[DRaver]

Today another error sounds like the same Problem:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect string value: '\x96 mich...' for column 'message' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

#0 /var/www/mysite/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/mysite/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/mysite/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /var/www/mysite/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xf_conversation...', Array)
#4 /var/www/mysite/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#5 /var/www/mysite/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#6 /var/www/mysite/library/XenForo/ControllerPublic/Conversation.php(1088): XenForo_DataWriter->save()
#7 /var/www/mysite/library/Tac/StopHumanSpam/ControllerPublic/Conversation.php(305): XenForo_ControllerPublic_Conversation->actionInsertReply()
#8 /var/www/mysite/library/XenForo/FrontController.php(337): Tac_StopHumanSpam_ControllerPublic_Conversation->actionInsertReply()
#9 /var/www/mysite/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/mysite/index.php(13): XenForo_FrontController->run()
#11 {main}
Benötigter Status
array(3) {
  ["url"] => string(59) "http://www.mysite.net/conversations/echo.103598/insert-reply"
  ["_GET"] => array(1) {
    ["/conversations/echo_103598/insert-reply"] => string(0) ""
  }
  ["_POST"] => array(9) {
    ["message_html"] => string(510) "<p>bla bla bla</p><p><br></p><p>bl bla.&nbsp;</p><p>Guggst du hier:&nbsp;<a href="http://www.chefkoch.de/rezepte/196071083164970/Fress-mich-dumm-Kuchen.html">http://www.chefkoch.de/rezepte/196071083164970/Fress-mich-dumm-Kuchen.html</a></p>"
    ["_xfRelativeResolver"] => string(54) "http://www.mysite.net/conversations/echo.103598/page-17"
    ["attachment_hash"] => string(32) "23f5ee9344d713607c28b97563719a89"
    ["last_date"] => string(10) "1384166004"
    ["last_known_date"] => string(0) ""
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(34) "/conversations/echo.103598/page-17"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Jeremy]

StopHumanSpam appears to be the culprit.