View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
14739Bug reportsSurvey editingpublic2019-04-04 09:432020-03-09 15:36
ReporterDenisChenu Assigned Todominikvitt 
PrioritynoneSeverityminor 
Status closedResolutionno change required 
Product Version4.0.0dev 
Summary14739: All DB column to text
Description

After activation all DB column are set to text …

Steps To Reproduce

Import lss (if it work) activate, look at DB

Additional Information

I really think the most difficult things to manage is the DB column type. In my opinion it must be done at start of development.
Maybe the idea on how it works are already here ?

DB type column in config.xml or something like this ?

TagsNo tags attached.
Attached Files
limesurvey_survey_221856.lss (27,210 bytes)
survey_archive_221856.lsa (4,370 bytes)
Bug heat6
Complete LimeSurvey version number (& build)4.0.0 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)fedora/linux
Webserver software & version (if known)nginx
PHP Versionphp7.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2019-04-05 09:00

updater   ~51363

Aren't there certain feature like date filtering or calculating mean values at statistics which rely on a certain DB field type?
dominikvitt

dominikvitt

2019-06-12 18:16

developer   ~52379

I returned back the same behaviour as it was before, except for case when response should be encrypted - then it is set to "text".

See here: https://github.com/LimeSurvey/LimeSurvey/commit/3f37ed81d63d7083015e42861efcd1b722c6f412
DenisChenu

DenisChenu

2019-06-12 18:27

developer   ~52381

I didn't kow it was done for encrypt :)

See my comment about token.

And about collation too ? Unsure it's needed or not ?
dominikvitt

dominikvitt

2019-06-17 18:08

developer   ~52432

Collation is inherited automatically from table definition, you should only specify if you want different column collation.

Issue History

Date Modified Username Field Change
2019-04-04 09:43 DenisChenu New Issue
2019-04-04 09:43 DenisChenu File Added: limesurvey_survey_221856.lss
2019-04-04 09:43 DenisChenu File Added: survey_archive_221856.lsa
2019-04-05 09:00 Mazi Note Added: 51363
2019-06-12 18:16 dominikvitt Assigned To => dominikvitt
2019-06-12 18:16 dominikvitt Status new => resolved
2019-06-12 18:16 dominikvitt Resolution open => no change required
2019-06-12 18:16 dominikvitt Note Added: 52379
2019-06-12 18:27 DenisChenu Note Added: 52381
2019-06-17 18:08 dominikvitt Note Added: 52432
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing
2020-03-09 15:36 c_schmitz Status resolved => closed