Please update to the latest version and check if the bug can still be reproduced. Thank you.

I don't have an MSSQL server but my guess is this bug will still occur in the latest version due to this code:

helpers/export_helper.php:

1758 case "R": //RANKING STYLE
1759 quexml_create_subQuestions($question, $qid, $sgq, $iResponseID, $fieldmap, true);
1760
1761 $QROW = Yii::app()->db->createCommand()
1762 ->select('MAX(CHAR_LENGTH(code)) as sc')
1763 ->from("{{answers}}")
1764 ->where(" qid=:qid AND language=:language", array(':qid'=>$qid, ':language'=>$quexmllang))
1765 ->queryRow();
1766
1767 $response->appendChild(QueXMLCreateFree("integer", $QROW['sc'], ""));
1768 $question->appendChild($response);
1769 break;

I'll work on an update that checks for MSSQL and rewrites the query

@adeuschlinger

This error will show up on MSSQL when a survey has a ranking style question.

Can you please replace application/helpers/export_helper.php with the attached file and try again and see if it fixes the issue - if so I'll apply the patch to the next LimeSurvey release.

Thank you @adamzammit

I replaced the php file.
And the export is working without any error now.

Great, Adam. Do we have a PR for this?

Created here: https://github.com/LimeSurvey/LimeSurvey/pull/1902
Will probably need to apply to master too

Adam

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=31929

Hi,

Yes, a separate PR has to be created for master, since the query is a little bit different. Couldn't trivially cherry-pick it, and someone needs to test it first.

@ollehar - Created here for master: https://github.com/LimeSurvey/LimeSurvey/pull/1905

Looks very similar to me but happy to wait for someone to test before merging.

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

Release done.

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