View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
05540Bug reportsSurvey editingpublic2011-10-28 20:12
Reporteruser16297Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionwon't fix 
Product Version1.91+ 
Summary05540: Multiple Choice with Comments limited to 5 characters - See bug 05157 for similar issue
Description

A survey was created with question type "Multiple Choice with Comments". The comments are being truncated to 5 characters with no apparent problem reported to the user. In the database, the field type is set to VarChar(5).

Steps To Reproduce

Create an question with : Multiple answers with comments.
Active yours survey
Choose a response and write a comments with a minimum of 6 characters.
View the response and only five characters show up

Additional Information

If this bug has previously been fixed for MySQL, it is not correcting previously built questionnaires.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)11232
I will donate to the project if issue is resolvedNo
BrowserIE, Chrome - Doesn't seem to be browser specific
Database type & versionMySQL 5.0.92, 5.0.77
Server OS (if known)Centos 5
Webserver software & version (if known)Apache 2.0.63, 2.2.3
PHP Version5.1.6, 5.2.13
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-10-28 17:18

administrator   ~16555

You are right. In that case please just change the type on your database field to TEXT.
I am sorry but this bug has only been in effect for a couple builds so we will not create a special fix routine for that.

user16297

2011-10-28 19:46

  ~16559

Ummm .... Yeah. Not to be critical or anything, but this is why Upper Management doesn't like Open Source software. I can understand there there probably aren't a ton of people affected, but I've got 20+ different surveys to search through and try to figure out which ones are broken by a weird off the wall bug in a minor update. It's not exactly an easy or quick fix when you don't even know where to start looking.

For others who are having the same issue, here's the SQL to at least find the offending tables:

SELECT * FROM information_schema.COLUMNS C WHERE table_schema = 'INSERT_YOUR_TABLE_NAME_HERE' AND column_name LIKE '%comment' AND data_type = 'varchar' ;

Sorry, but since SQL isn't my only deal I'm not sure what the syntax would look like to do a find and fix in one line.

Thanks

user16297

2011-10-28 19:51

  ~16560

Also, you'll want to reset the Text field size to be 65535 to match what Lime Survey is setting it as.

c_schmitz

c_schmitz

2011-10-28 20:12

administrator   ~16562

Thank you for your solution.

Upper management is always invited to spend money on a support contract that would take care of such things (for example with one of our LimeSurvey Partners - see http://www.limesurvey.com ). I am sorry that this issue affected you but it's not like we have unlimited resources to spend for free - at least not yet :-).

Issue History

Date Modified Username Field Change
2011-10-28 16:05 user16297 New Issue
2011-10-28 16:07 user16297 Issue Monitored: user16297
2011-10-28 17:18 c_schmitz Note Added: 16555
2011-10-28 17:18 c_schmitz Status new => closed
2011-10-28 17:18 c_schmitz Assigned To => c_schmitz
2011-10-28 17:18 c_schmitz Resolution open => won't fix
2011-10-28 19:46 user16297 Note Added: 16559
2011-10-28 19:46 user16297 Status closed => feedback
2011-10-28 19:46 user16297 Resolution won't fix => reopened
2011-10-28 19:51 user16297 Note Added: 16560
2011-10-28 19:51 user16297 Status feedback => assigned
2011-10-28 20:12 c_schmitz Note Added: 16562
2011-10-28 20:12 c_schmitz Status assigned => closed
2011-10-28 20:12 c_schmitz Resolution reopened => won't fix
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing