View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
11995Bug reportsOtherpublic2017-06-15 15:54
Reporterbdeprez Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.57.x 
Fixed in Version2.65.x 
Summary11995: Removing language from global settings produces fatal error
Description

When removing a language from "Global Settings" - Language - Available languages, you get a fatal error:

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'stg_value' at row 1

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

Steps To Reproduce

Global Settings - Language - Available Languages

Select any language

Click Remove

Click Save

TagsNo tags attached.
Attached Files
error.tiff (53,408 bytes)   
error.tiff (53,408 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)2.57.1
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMariaDB 10.1.18
Server OS (if known)Windows 2008
Webserver software & version (if known)Apache 2.4.18
PHP Version5.6.19

Users monitoring this issue

There are no users monitoring this issue.

Activities

bdeprez

bdeprez

2016-12-08 23:44

reporter   ~42485

Apologies - I'm on 2.57 (not 2.57.1) - just tried the same on a different box with 2.57 and there it works... Must be something on my windows server...

DenisChenu

DenisChenu

2016-12-09 08:28

developer   ~42486

On this windows server : can you activate debug http://manual.limesurvey.org/Debug_mode and test again ? We have more information about the data truncated.

c_schmitz

c_schmitz

2017-06-13 12:48

administrator   ~43891

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=22958

Related Changesets

LimeSurvey: master 2eaef45c

2017-06-13 12:48:03

c_schmitz

Details Diff
Fixed issue 11995: Removing language from global settings produces fatal error Affected Issues
11995
mod - application/config/version.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File
mod - installer/sql/create-mssql.sql Diff File
mod - installer/sql/create-mysql.sql Diff File
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2016-12-08 23:36 bdeprez New Issue
2016-12-08 23:36 bdeprez File Added: error.tiff
2016-12-08 23:44 bdeprez Note Added: 42485
2016-12-09 08:28 DenisChenu Note Added: 42486
2017-06-13 12:33 c_schmitz Product Version => 2.57.x
2017-06-13 12:48 c_schmitz Changeset attached => LimeSurvey master 2eaef45c
2017-06-13 12:48 c_schmitz Note Added: 43891
2017-06-13 12:48 c_schmitz Assigned To => c_schmitz
2017-06-13 12:48 c_schmitz Resolution open => fixed
2017-06-13 12:49 c_schmitz Status new => resolved
2017-06-13 12:49 c_schmitz Fixed in Version => 2.65.x
2017-06-15 15:54 c_schmitz Status resolved => closed