We do not support InnoDB tables, only MyISAM.
If you can reproduce the isse on MyISAM tables please attach the related .lss files to your reproducing instructions. Thank you.

They are MyISAM tables. I thought it is InnoDB but it's not. My bad.

However, this happens to Version 2.05+ Build 141020 but not Version 2.05+ Build 140703. And I'm accessing the database manually.

So if we look at "questions" table closely. There were changes of how the table is created.

According to installer\sql\create-mysql.sql of Build 141020. The primary key setting of "questions" is :-
PRIMARY KEY (language, qid)
while it was like this in Build 140703 :-
PRIMARY KEY (qid,language)

So when I change this back the table works just fine. But I'm not sure this is the way we should do it so solve the problem. While some forum suggests unique setting instead.

How I tested the table, I simply used sql insert script directly to "questions" table. Try insert the table using different value of "language".

I can't tell why you can't reproduce this one.
For environment setting. For this issue, the one I wrote is my development PC.
However, my production server has MySQL:
version = 5.5.38-0+wheezy1-log
version_comment = (Debian)
version_compile_machine =x86_64
version_compile_os =debian-linux-gnu

And it's still have the same problem.

The lss file have the 2 language ?

Maybe best to put the lss file here ;)

No, they are separated surveys. Each one has different base languages.
But I can't send you the lss files, it's my company's policy.

However, I uploaded "duplicated_test.sql" the file will generates 2 "questions" tables. The one is from Build 141020 and another is Build 140703.
Then the script will insert 5 records to each of them. And you can select data from tables to see the result.

I uploaded 2 test surveys. Each one has different based language.

So this is how I reproduce this issue.

1. Install new Limesurvey Build 141020
2. Import limesurvey_survey_381139.lss
3. Import limesurvey_survey_575216.lss
4. Browse to survey 575216's question
5. LimeSurvey load survey 381139's question instead because of duplicated qid.

Hi,
Can not reproduce.
My default language is fr, my admin language is en. Test with last GIT version.

Before staring i look at my DB, the last qid was 42347 then look at select:
SELECT * FROM lime_questions WHERE qid >=42347

2. Import limesurvey_survey_381139.lss
   New question line : qid=>42348,sid=>381139,title=>defirstquestion ,question=>""
   2. Import limesurvey_survey_381139.lss
      New question line : qid=>42349,sid=>575216,title=>itfirstquestion,question=>this one has text

But i think we can have some error when:
1: create a survey in it (for example)
2: export lss file
3: delete survey
4: update lss file (maybe set to lang:de)
5: see waht you have.

In some situation, we have strange issue when testing, BUT : logout limesurvey admin/ login limesurvey admin allways reset .

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14607

Version 2.05 Build 141110 released