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

XF 1.2 Xenforo error message

Discussion in 'Troubleshooting and Problems' started by DRaver, Nov 4, 2013.

  1. DRaver

    DRaver Active Member

    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?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Can you post the entire contents of the error message?
     
  3. DRaver

    DRaver Active Member

    Sure:

    Code:
    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"
      }
     
  4. Mike

    Mike XenForo Developer Staff Member

    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.
     
  5. Chris D

    Chris D XenForo Developer Staff Member

    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?
     
  6. DRaver

    DRaver Active Member

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

    Chris D XenForo Developer Staff Member

    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.
     
  8. DRaver

    DRaver Active Member

    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

    Code:
    #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"
      }
    }
     
  9. Jeremy

    Jeremy XenForo Moderator Staff Member

    StopHumanSpam appears to be the culprit.
     

Share This Page