Fixed Description Error

[DaveM]

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"
  }
}

 

[Bob]

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]

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

 

[Bob]

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.