Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
16908Bug reportsImport/Exportpublic2021-03-11 08:51
Reportergabrieljenik Assigned To 
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
Database & DB-VersionMysql
Server OS (if known)
Webserver software & version (if known)
PHP Version7


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




2020-12-14 20:26

manager   ~60950

Possibly same happens on LS4


2020-12-15 08:00

developer   ~60951

checkintegrity fix the issue ?

We don't have a checkintegrity limited to survey ?


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


2020-12-16 14:58

manager   ~60980

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


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 :


2021-03-11 08:51

developer   ~63281

related ?

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