View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
12000Bug reportsSurvey participants (Tokens)public2016-12-12 11:482017-01-06 12:14
Reporterwojtech Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.55.x 
Fixed in Version2.57.x 
Summary12000: Different charset collation?
Description

Is there any reason why there there are different charset collations for tokens column in lime_survey_id table (token varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL,) and lime_tokens_id table (token varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL)? As far as I know in some MySQL versions it might cause problems with indexing, if there is difference in column definition, or am I wrong?

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)2.55.1+161026
I will donate to the project if issue is resolvedNo
Browserany
Database type & versionMySQL 5.6.3/5.5.45
Server OS (if known)Debian/Windows 2012R2
Webserver software & version (if known)Apache/2.4.16 (Debian)/IIS
PHP Version5.6.14-1/7.0.9

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2017-01-02 16:39

administrator   ~42611

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=21884
c_schmitz

c_schmitz

2017-01-04 14:21

administrator   ~42620

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=21894
c_schmitz

c_schmitz

2017-01-06 12:14

administrator   ~42646

New version released.

Related Changesets

LimeSurvey: master a01f6696

2017-01-02 16:39:24

c_schmitz

Details Diff 		Fixed issue 12000: 'token' column collation is not set in survey tables Affected Issues
12000
mod - application/helpers/admin/activate_helper.php Diff File

LimeSurvey: master 292daf49

2017-01-04 14:21:07

c_schmitz

Details Diff 		Fixed issue 12000: 'token' column collation is not set in survey tables Affected Issues
12000
mod - application/helpers/admin/activate_helper.php Diff File

Issue History

Date Modified Username Field Change
2016-12-12 11:48 wojtech New Issue
2017-01-02 16:35 c_schmitz Assigned To => c_schmitz
2017-01-02 16:35 c_schmitz Status new => assigned
2017-01-02 16:39 c_schmitz Changeset attached => LimeSurvey master a01f6696
2017-01-02 16:39 c_schmitz Note Added: 42611
2017-01-02 16:39 c_schmitz Resolution open => fixed
2017-01-02 16:43 c_schmitz Status assigned => resolved
2017-01-02 16:43 c_schmitz Fixed in Version => 2.57.x
2017-01-04 14:21 c_schmitz Changeset attached => LimeSurvey master 292daf49
2017-01-04 14:21 c_schmitz Note Added: 42620
2017-01-06 12:14 c_schmitz Note Added: 42646
2017-01-06 12:14 c_schmitz Status resolved => closed