View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
12854Bug reportsSurvey participants (Tokens)public2017-10-31 09:592018-02-05 14:01
Reporterboggiano Assigned Toc_schmitz  
PrioritynoneSeverityblock 
Status closedResolutionwon't fix 
Product Version2.7x.x 
Summary12854: Can't use more than 62 attributes
Description

If I try to create more than 62 attributes, i get this error:
"
SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The
maximum row size for the used table type, not counting BLOBs, is 65535. You have
to change some columns to TEXT or BLOBs
"
Same thing if I try to add one attribute to my 62 already existing attributes.

Steps To Reproduce

Go to "Survey partecipants"
Go to "Manage attrbutes"
Enter the value "63" in the "Number of attribute fields to add" textfield
Click on "Add fields"

Additional Information

In the previous versions 2.0+ it was possible.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)Version 2.72.2+171017
I will donate to the project if issue is resolvedNo
BrowserAny
Database type & versionMariaDB 5.5.56
Server OS (if known)CentOS Linux release 7.4.1708
Webserver software & version (if known)Apache/2.4.6 (CentOS)
PHP VersionPHP 5.4.16 (cli) (built: Nov 6 2016 00:29:02)

Users monitoring this issue

boggiano

Activities

LouisGac

LouisGac

2017-11-01 18:58

developer   ~44924

it's a SQL error, so it's thrown by the sql server... I doubt it's related to LimeSurvey version

Issue History

Date Modified Username Field Change
2017-10-31 09:59 boggiano New Issue
2017-10-31 10:00 boggiano Issue Monitored: boggiano
2017-11-01 18:58 LouisGac Note Added: 44924
2017-11-10 17:20 LouisGac Assigned To => LouisGac
2017-11-10 17:20 LouisGac Status new => closed
2017-11-10 17:20 LouisGac Resolution open => won't fix
2018-02-05 14:01 LouisGac Assigned To LouisGac => c_schmitz