Hi everyone,

After working on a same survey ID, we have experienced an increment size of the exported archive (no matters if it's .lss, .txt, .lsa...), even though we did no changes on it. Doing some attempts, the export archive incremented from 3Mb to 103Mb.

Checking the database, we have seen the incremented size resides on 'lime_template_configuration' table. This table does not delete the rows associated with the survey id when you delete the survey. So, when you import a survey with an existing old ID, this old rows will be part of the new survey when exporting.

We are not sure the utility of this table, so we don't know if this is a bug.

We eventually work on creating surveys in a development server and importing them in the production server. We do the import/export process a lot of times so this table does not stop incrementing. Management time becomes quite complicated with the pass of the time.

Does anyone know how to debug and reduce the 'lime_template_configuration' table?

 

Thanks for your attention!

LimeSurvey version: 5.6.30+230711