Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Fixed Description Error

Discussion in 'Showcase Resolved Bug Reports' started by DaveM, May 31, 2014.

  1. DaveM

    DaveM Member Showcase

    We seem to be running the following error lately

    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'description' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: wrrnj, Yesterday at 3:55 PM
    Stack Trace
    #0 /var/www/vhosts/triumphtalk.com/httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/vhosts/triumphtalk.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/vhosts/triumphtalk.com/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_nflj_showcas...', Array)
    #4 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
    #5 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /var/www/vhosts/triumphtalk.com/httpdocs/library/NFLJ/Showcase/ControllerPublic/Showcase.php(1141): XenForo_DataWriter->save()
    #7 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/FrontController.php(347): NFLJ_Showcase_ControllerPublic_Showcase->actionAddSave()
    #8 /var/www/vhosts/triumphtalk.com/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/vhosts/triumphtalk.com/httpdocs/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
      ["url"] => string(44) "http://www.triumphtalk.com/showcase/add-save"
      ["_GET"] => array(0) {
      ["_POST"] => array(17) {
        ["prefix_id"] => string(1) "0"
        ["item_name"] => string(57) "FS Joker Machine Clip ons, Top Clamp and BC Gauge Bracket"
        ["description"] => string(293) "1" Black Anodized Joker Machine clip ons, Top Clamp from early Thruxton and British Customs Lay Flat Gauge Bracket for sale. All have maybe 500 miles, cost me $400, I have decided to go to clubmans and put some of my stock stuff back on. Very nice parts, looking to get $250 plus $15 shipping "
        ["message_html"] => string(7) "<p></p>"
        ["_xfRelativeResolver"] => string(39) "http://www.triumphtalk.com/showcase/add"
        ["message_t2_html"] => string(7) "<p></p>"
        ["message_t3_html"] => string(7) "<p></p>"
        ["message_t4_html"] => string(7) "<p></p>"
        ["draft"] => string(1) "1"
        ["attachment_hash"] => string(32) "fc69ca8081252b721af9fab61ee7e37e"
        ["_xftoken"] => string(56) "2508,1401457778,d87baad1d3b950a64f396c7ab8e0cc84aff4c126"
        ["category_id"] => string(1) "4"
        ["require_item_image"] => string(1) "1"
        ["_xfRequestUri"] => string(13) "/showcase/add"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfToken"] => string(8) "********"
        ["_xfResponseType"] => string(4) "json"
  2. Bob

    Bob Developer Staff Member

    The description field is a varchar(255) and you can see that the string length trying to be added is string(293). I force maxlength="255" on the field on the forum, but let the DW fail silent on that field since its not critical. I guess I could increase it, but really, the description field (right now) is only used on the "lists" and for customization purposes (and is limited to displaying less then 255 characters on lists anyway).

    Im going to toss this over to the bugs forum so that I can tweak a few things pertaining to description anyway.
    C.Birch and DaveM like this.
  3. C.Birch

    C.Birch Member AMS Premium SC Premium UBS Premium

    I have started to get this error of late, it's only ever from one user, but it stops them for adding their showcase to i tell them they need to make their description shorter. But it's good that you are planning a fix :)
  4. Bob

    Bob Developer Staff Member

    This SHOULD be fixed now. The input box on the form is limited to 250 characters and I also added a validator to the DataWriter that will throw an error if more than 250 characters are submitted.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.