View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05142 | Bug reports | Survey taking | public | 2011-05-02 14:52 | 2011-05-04 23:54 |
| Reporter | csnook | Assigned To | c_schmitz | ||
| Priority | high | Severity | partial_block | ||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.90+ | ||||
| Summary | 05142: Error 139 when database uses InnoDB tables | ||||
| Description | InnoDB has a maximum row length (not counting TEXT and BLOB) of about 8000 character. Attempting to enter sets of responses longer than this will fail. | ||||
| Steps To Reproduce | 1) Configure MySQL server to use InnoDB tables by default (this will be the default in future MySQL versions) | ||||
| Additional Information | Although this could probably be avoided by being more careful about using TEXT instead of VARCHAR fields, or by more thoroughly normalizing the database schema, MyISAM tables don't have this limitation, so explicitly setting the table type to MyISAM would be a quick fix. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 9642 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | various | ||||
| Database type & version | mysql-server-5.0.77-4.el5_5.5 | ||||
| Server OS (if known) | CentOS 5.6 | ||||
| Webserver software & version (if known) | httpd-2.2.3-45.el5.centos (Apache) | ||||
| PHP Version | php-5.1.6-27.el5_5.3 | ||||
