1. REGISTRATION REQUIREMENTS:

    Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to 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 SQL Error

Discussion in 'Pickem Resolved Bug Reports' started by BamaStangGuy, Nov 27, 2012.

  1. BamaStangGuy

    BamaStangGuy Member SC Premium UBS Premium Pickem

    When updating week name on this page:

    Screen Shot 2012-11-27 at 1.24.26 PM.png

    Code:
    Server Error
     
    Mysqli statement execute error : Data too long for column 'week_name' at row 1
     
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632
    Zend_Db_Adapter_Abstract->update() in XenForo/DataWriter.php at line 1607
    XenForo_DataWriter->_update() in XenForo/DataWriter.php at line 1576
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
    XenForo_DataWriter->save() in NFLJ/Pickem/ControllerAdmin/Week.php at line 74
    NFLJ_Pickem_ControllerAdmin_Week->actionSave() in XenForo/FrontController.php at line 310
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /home/sec/www/admin.php at line 13
     
  2. Bob

    Bob Developer Staff Member

    field is only char(20). If you want longer weeknames, you will need to change the field type for the week_name field on the xf_nflj_pickem_week table. You know how to do that right? simple with phpMyAdmin.
     
  3. Bob

    Bob Developer Staff Member

    Im going to change this in the next version (which should be out today). Going to change it to a varchar(50) and change the DW to throw an error @50 instead of 100 (I had the dw set @100 instead of 20, thats the the dw (datawriter) didn't throw an error).

    I had it set low because the length of the title effects the layout in certain places (like the leaderboard) as well as widgets and blocks that are in this next version.
     
  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.