View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05540 | Bug reports | Survey editing | public | 2011-10-28 16:05 | 2011-10-28 20:12 |
| Reporter | Assigned To | c_schmitz | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.91+ | ||||
| Summary | 05540: 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. | ||||
| Additional Information | If this bug has previously been fixed for MySQL, it is not correcting previously built questionnaires. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 11232 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | IE, Chrome - Doesn't seem to be browser specific | ||||
| Database type & version | MySQL 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 Version | 5.1.6, 5.2.13 | ||||
| Git branch / Pull Request URL | |||||
|
You are right. In that case please just change the type on your database field to TEXT. |
|
|
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. 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 |
|
|
Also, you'll want to reset the Text field size to be 65535 to match what Lime Survey is setting it as. |
|
|
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 :-). |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-10-28 16:05 |
|
New Issue | |
| 2011-10-28 16:07 |
|
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 |
|
Note Added: 16559 | |
| 2011-10-28 19:46 |
|
Status | closed => feedback |
| 2011-10-28 19:46 |
|
Resolution | won't fix => reopened |
| 2011-10-28 19:51 |
|
Note Added: 16560 | |
| 2011-10-28 19:51 |
|
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 |