View Issue Details

IDProjectCategoryView StatusLast Update
14646Bug reports[All Projects] Import/Exportpublic2019-03-19 10:10
ReporterrealitixAssigned To 
PrioritynoneSeveritymajor 
Status newResolutionopen 
Product Version3.15.x 
Target VersionFixed in Version 
Summary14646: Encoding error when importing a survey
Description

Hello,

I got an error when I try to import a survey exported from version 2.0.5.
It's an encoding error in the group name.
The error in invisible with mysql so you have to use PGSQL to see it.

When you enable convert links, it works because the group name pass through preg_replace with the /u PCRE modifier and that fixes the UTF8 string.

I'm sending the pull request.

Steps To Reproduce
  1. Import the joined .lss file and set convert links to NO
  2. ERROR
TagsNo tags attached.
Complete LimeSurvey version number (& build)master 3.15.9
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionPostgresql
Server OS (if known)
Webserver software & version (if known)
PHP Version0

Activities

realitix

realitix

2019-03-13 16:03

reporter  

limesurvey_survey_essai_2019011610000076.lss (13,003 bytes)
realitix

realitix

2019-03-13 16:03

reporter   ~50950

The SQL Exeption is the same as this bug: https://bugs.limesurvey.org/view.php?id=14133

realitix

realitix

2019-03-13 16:07

reporter   ~50951

Here the pull request: https://github.com/LimeSurvey/LimeSurvey/pull/1244

DenisChenu

DenisChenu

2019-03-13 16:27

developer   ~50953

Question : why only the group name ?
If groupname is not in UTF8 : why all other are in utf8 ?

realitix

realitix

2019-03-13 16:52

reporter   ~50955

Hello Denis,
I don't know exactly why, maybe an error in the exporter of version 2.05.
Maybe the check should be added to all fields but this bug only occurs with the group name.

dominikvitt

dominikvitt

2019-03-13 17:20

developer   ~50961

Last edited: 2019-03-13 17:21

View 2 revisions

It looks like proposed PR get rid of the SQL error, but it doesn't have any effect on group name.
It is the same for MySql or Postgresql.
I always get the following warning in import summary:
"Warnings:

Group “AAèAA 2 - AAAA-AAèAA 1 - AAAAAAAéA AA AAAAAAAAAA AAA AAAAAAAAAAAA AéAAAAéA AAA AAA AAAAAAAAAAAéA“ was set to ““ 

"
So, it looks like group name wasn't converted, but resorted to empty string.
I'm using Linux Mint, can it be because of OS difference?

DenisChenu

DenisChenu

2019-03-13 18:04

developer   ~50967

My issue is more :

  1. did this happen with a "not hacked" version of limesurvey (lss)
  2. If yes : we must «silently» fix
  3. If not : i think we must «inform user» there are an issue BUT : currently : no clean error can be done in import system …
dominikvitt

dominikvitt

2019-03-19 10:10

developer   ~51049

@realitix:
Do you have more information about this issue?
Do you also have warning when importing lss file?

Issue History

Date Modified Username Field Change
2019-03-13 16:03 realitix New Issue
2019-03-13 16:03 realitix File Added: limesurvey_survey_essai_2019011610000076.lss
2019-03-13 16:03 realitix Note Added: 50950
2019-03-13 16:07 realitix Note Added: 50951
2019-03-13 16:27 DenisChenu Note Added: 50953
2019-03-13 16:52 realitix Note Added: 50955
2019-03-13 17:20 dominikvitt Note Added: 50961
2019-03-13 17:21 dominikvitt Note Edited: 50961 View Revisions
2019-03-13 18:04 DenisChenu Note Added: 50967
2019-03-19 10:10 dominikvitt Note Added: 51049