View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
14739 | Bug reports | Survey editing | public | 2019-04-04 09:43 | 2020-03-09 15:36 |
Reporter | DenisChenu | Assigned To | |||
Priority | none | Severity | minor | ||
Status | closed | Resolution | no change required | ||
Product Version | 4.0.0dev | ||||
Summary | 14739: 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. DB type column in config.xml or something like this ? | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 4.0.0 github | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | not relevant | ||||
Database type & version | mariadb | ||||
Server OS (if known) | fedora/linux | ||||
Webserver software & version (if known) | nginx | ||||
PHP Version | php7.2 | ||||
Aren't there certain feature like date filtering or calculating mean values at statistics which rely on a certain DB field type? |
|
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 |
|
I didn't kow it was done for encrypt :) See my comment about token. And about collation too ? Unsure it's needed or not ? |
|
Collation is inherited automatically from table definition, you should only specify if you want different column collation. |
|
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 |
|
Assigned To | => dominikvitt |
2019-06-12 18:16 |
|
Status | new => resolved |
2019-06-12 18:16 |
|
Resolution | open => no change required |
2019-06-12 18:16 |
|
Note Added: 52379 | |
2019-06-12 18:27 | DenisChenu | Note Added: 52381 | |
2019-06-17 18:08 |
|
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 |