homeofeconomy Posted January 17, 2016 Share Posted January 17, 2016 Hello all, On our upgraded (from 3.4.8 to 4.1.x) gallery and on a fresh 4.1.7 test install, an upload to the gallery never makes it past step 2 (the spinning wheel of "working"). The .sql record of what happened shows what appears to be a 52 character long session key being used. The upload_session column is a VARCHAR(32). Am I correct in guessing that we're over the limit by 20 characters? If so, what should be done about this? Thank you for your time. -Rob Quote Data too long for column 'upload_session' at row 1 I N S E R T INTO `gallery_images_uploads` ( `upload_session`, `upload_member_id`, `upload_location`, `upload_file_name`, `upload_date` ) VALUES ( ?, ?, ?, ?, ? ) Array ( [0] => hbeb91pm9jddsq4irbdajqahiqeblecored9hnen7454q3qohck0 [1] => 1 [2] => monthly_2016_01/HOE-Logo-Round-RGB.png.6addbbe57827829438f47858714877cb.png [3] => HOE-Logo-Round-RGB.png [4] => 1452984402 ) | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 414 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Db.php | [IPS\_Db].preparedQuery | 645 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/gallery/modules/front/gallery/submit.php | [IPS\_Db].insert | 337 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\gallery\modules\front\gallery\_submit]._stepUploadImages | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Helpers/Wizard/Wizard.php | [].call_user_func | 156 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Theme/Theme.php(692) : eval()'d code | [IPS\Helpers\_Wizard].__toString | 209 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\Theme\class_core_front_global].blankTemplate | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Theme/SandboxedTemplate.php | [].call_user_func_array | 57 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\Theme\_SandboxedTemplate].__call | 144 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\Theme\SandboxedTemplate].blankTemplate | 144 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Standard.php | [IPS\_Dispatcher].finish | 101 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Front.php | [IPS\Dispatcher\_Standard].finish | 554 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\Dispatcher\_Front].finish | 131 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /index.php | [IPS\_Dispatcher].run | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ------------------------------------------------------------------------ Link to comment Share on other sites More sharing options...
homeofeconomy Posted January 18, 2016 Author Share Posted January 18, 2016 Altering the gallery_images_uploads "uploads_session" column to be a Varchar 64 (instead of varchar 32) has allowed this to work. I have verified that varchar(32) is the default for this column in a fresh install of 4.1.7. This seems to me to be a bug. Where does one file a bug report now? Link to comment Share on other sites More sharing options...
Mark H Posted January 18, 2016 Share Posted January 18, 2016 The bug tracker for version 4 can be found here: https://community.invisionpower.com/4bugtrack/active-reports/ I'd suggest filing a ticket to support as well, however, so they can examine the install to make sure this wasn't a symptom of a larger issue. Link to comment Share on other sites More sharing options...
homeofeconomy Posted January 19, 2016 Author Share Posted January 19, 2016 Hi Mark, The support ticket was closed with a resolution that the upload_session column would be increased to a varchar(128) in future versions. -Rob Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.