View Issue Details

IDProjectCategoryView StatusLast Update
16908Bug reportsImport/Exportpublic2021-03-11 08:51
Reportergabrieljenik Assigned To 
PrioritylowSeveritypartial_block 
Status acknowledgedResolutionopen 
Product Version3.25.4 
Summary16908: Importing Question with multiple languages can left grabage on the DB
DescriptionWhen importing question holding multiple languages, the DB could be populated with data for languages which are not used in the survey.
Steps To Reproduce- Survey uses EN and ES
- Question holds ES, EN and FR.

FR info will be imported but still never used neither shown.
TagsNo tags attached.
Complete LimeSurvey version number (& build)3.25.4
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionMysql
Server OS (if known)
Webserver software & version (if known)
PHP Version7

Relationships

related to 17093 closedDenisChenu Unable to fix invalid survey after import bad TSV 

Activities

gabrieljenik

gabrieljenik

2020-12-14 20:26

manager   ~60950

Possibly same happens on LS4
DenisChenu

DenisChenu

2020-12-15 08:00

developer   ~60951

checkintegrity fix the issue ?

We don't have a checkintegrity limited to survey ?
gabrieljenik

gabrieljenik

2020-12-16 14:51

manager   ~60979

I think checkintegrity works around the isue, but is not enough.

```
/**
* fixLanguageConsistency() fixes missing groups, questions, answers, quotas & assessments for languages on a survey
* @param string $sid - the currently selected survey
* @param string $availlangs - space separated list of additional languages in survey - if empty all additional languages of a survey are checked against the base language
* @return bool - always returns true
*/
```
gabrieljenik

gabrieljenik

2020-12-16 14:58

manager   ~60980

You mean the CheckIntegrity controller?
Didn't check on that. But consider that is not widely used.
DenisChenu

DenisChenu

2020-12-16 15:10

developer   ~60982

The global checkintegrity action :)

Sometimes : you need to use it : on server with DB older than 4 years for example, when you use TSV import etc …

There are something for SubQuestions : https://github.com/LimeSurvey/LimeSurvey/blob/3.x-LTS/application/models/Question.php#L1076
DenisChenu

DenisChenu

2021-03-11 08:51

developer   ~63281

related ?
https://github.com/LimeSurvey/LimeSurvey/pull/1774

Issue History

Date Modified Username Field Change
2020-12-14 20:25 gabrieljenik New Issue
2020-12-14 20:25 gabrieljenik Issue generated from: 16907
2020-12-14 20:26 gabrieljenik Note Added: 60950
2020-12-15 08:00 DenisChenu Note Added: 60951
2020-12-16 14:51 gabrieljenik Note Added: 60979
2020-12-16 14:58 gabrieljenik Note Added: 60980
2020-12-16 15:10 DenisChenu Note Added: 60982
2020-12-28 13:05 cdorin Status new => acknowledged
2021-03-10 21:10 ollehar Priority none => low
2021-03-11 08:51 DenisChenu Note Added: 63281
2021-03-11 08:51 DenisChenu Relationship added related to 17093