View Issue Details

IDProjectCategoryView StatusLast Update
14739Bug reports[All Projects] Survey designpublic2019-06-17 18:08
ReporterDenisChenu Assigned Todominikvitt  
PrioritynoneSeverityminor 
Status resolvedResolutionno change required 
Product Version4.0.0dev 
Target VersionFixed in Version 
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.
Complete LimeSurvey version number (& build)4.0.0 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-Versionmariadb
Server OS (if known)fedora/linux
Webserver software & version (if known)nginx
PHP Versionphp7.2

Activities

DenisChenu

DenisChenu

2019-04-04 09:43

developer  

limesurvey_survey_221856.lss (27,210 bytes)
survey_archive_221856.lsa (4,370 bytes)
Mazi

Mazi

2019-04-05 09:00

partner   ~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