View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
05827Bug reportsStatisticspublic2012-03-01 17:53
Reportertacman1123 Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.92RC3 
Summary05827: Encoding problem at Label Set import (former: "Statistics Show Wrong Results")
Description

We just entered a bunch of survey results via data entry. The data looks right, they're all from Ho Chi Minh City, and the data reflects.

BUT when we run statistics, it's showing up wrong. In fact, all the codes are off because Sóc Trăng (code soctr in the answer options) is missing from the statistics list, but is present in the answer options.

Steps To Reproduce

This should work. Import the .lss file, go to the data entry screen and in the question for ent_city, choose Tp Ho Chi Minh. Save the survey, run the statistics, and it shows up with Denang as the city.

Additional Information

See this video (no sound) that shows the error. I tried to move the mouse where the problem is: http://screencast-o-matic.com/watch/clnD2Ha3K

TagsNo tags attached.
Attached Files
denang_bug.lss (650,922 bytes)
vn-business-labels.lsl (438,368 bytes)
Bug heat8
Complete LimeSurvey version number (& build)155
I will donate to the project if issue is resolvedYes
Browser
Database type & versionmysql 5
Server OS (if known)all
Webserver software & version (if known)Apache 2.2
PHP Version5.3

Relationships

related to 05834 closedTMSWhite Moving a Vietnamese Survey breaks character set 

Users monitoring this issue

There are no users monitoring this issue.

Activities

TMSWhite

TMSWhite

2012-02-16 17:38

reporter   ~17465

Is this just a problem from data_entry? (are the data correct if you use the survey to enter the data).

Is this just a 1.92 RC3 problem, or is it also a problem with 1.91+?

tacman1123

tacman1123

2012-02-16 17:45

reporter   ~17466

The data is correct now matter how it's entered. It's a problem with the statistics report.

If you look at the video (I can re-upload to youtube if that's easier), you'll see the key screens that show the problem.

My current theory (wild guess) is that because it's in Vietnamese, there's some unicode character or utf8 character that's somehow tripping up the system that builds the translation array between code and display.

TMSWhite

TMSWhite

2012-02-16 17:56

reporter   ~17471

Glad to hear the data is correct. Someone who has expertise in the statistics system will need to take this one.

tacman1123

tacman1123

2012-02-16 23:17

reporter   ~17483

I can give someone admin access to the system if they'd like to see the problem in more detail than the video provides. Email me at tacman@gmail.com.

tacman1123

tacman1123

2012-02-16 23:54

reporter   ~17484

Ok, the problem wasn't in the statistics, it was that the labels were off between the English and the Vietnamese, and the software is maddenly switching between base language and selected language frequently. No sure why the label import didn't work, or if the problem was with the data, or what.

c_schmitz

c_schmitz

2012-02-19 13:43

administrator   ~17515

tacman1123: Can you reproduce when the label mess-up happened?

tacman1123

tacman1123

2012-02-19 14:48

reporter   ~17518

if you import the label set I've attached, I think you'll see the problem. Actually, it's not utf8, that might be related to the problem as well.

Mazi

Mazi

2012-02-22 15:32

updater   ~17551

I also think this is an encoding problem, e. g. "Sóc Trăng" becomes "Soc Trang" after having imported the attached label set.

TMSWhite

TMSWhite

2012-02-23 15:48

reporter   ~17582

When I import the attached label set into 1.92 RC5, it looks fine. Yes, I see Soc Trang for English, but I see Sóc Trăng for the Vietnamese version of the labels.

So, perhaps the problem is that the statistics are using the English instead of Vietnamese labels? If so, that is the desired behavior for a different user - have the statistics show up in the admin language instead of the survey language.

c_schmitz

c_schmitz

2012-02-27 23:06

administrator   ~17665

I can't see anything wrong with the label set. It is UTF-8 indeed and it has different versions of the string saved for English and Vietnamese.

So unless we get some new information here, I would close the issue.
Most likely this was messed up during answer editing - question is how.

Issue History

Date Modified Username Field Change
2012-02-16 16:00 tacman1123 New Issue
2012-02-16 16:00 tacman1123 File Added: denang_bug.lss
2012-02-16 17:38 TMSWhite Note Added: 17465
2012-02-16 17:45 tacman1123 Note Added: 17466
2012-02-16 17:56 TMSWhite Note Added: 17471
2012-02-16 23:17 tacman1123 Note Added: 17483
2012-02-16 23:54 tacman1123 Note Added: 17484
2012-02-19 13:43 c_schmitz Note Added: 17515
2012-02-19 13:43 c_schmitz Assigned To => c_schmitz
2012-02-19 13:43 c_schmitz Status new => feedback
2012-02-19 14:47 tacman1123 File Added: vn-business-labels.lsl
2012-02-19 14:48 tacman1123 Note Added: 17518
2012-02-19 14:48 tacman1123 Status feedback => assigned
2012-02-22 15:25 Mazi Relationship added related to 05834
2012-02-22 15:31 Mazi Summary Statistics Show Wrong Results => Encoding problem at Label Set import (former: "Statistics Show Wrong Results")
2012-02-22 15:32 Mazi Note Added: 17551
2012-02-23 15:48 TMSWhite Note Added: 17582
2012-02-27 23:06 c_schmitz Note Added: 17665
2012-02-27 23:06 c_schmitz Status assigned => feedback
2012-03-01 17:53 c_schmitz Status feedback => closed
2012-03-01 17:53 c_schmitz Resolution open => unable to reproduce