I cannot reproduce that in 3.12.3
Please update and let us know if it works now.

I have updated with the latest ComfortUpdate & am still seeing this error.

Further note, if I press "Create Question Group" directly after the import fails, I see this error;

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '='.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

I have grabbed the latest source code from GitHub, configured it to be hosted locally and pointed at a local SQL database. I have then tried to import a survey exported from the Live version (hosted here) and it throws the "Error: Failed to insert data [3]" message.

So definitely nothing to do with my hosted version.

I'm going to try and debug it next.

Confirmed that this is still an issue in the latest ComfortUpdate.

Hi, I'll try to reproduce it tomorow.
It seems to affect only linux mssql server client.
Why don't you use MySQL by the way? Why mssql?

Hi all,
same for me using:
LimeSurvey 3.13.0
Windows Server 2012 R2 64Bit
MS SQL Server 2016
Apache Apache 2.4.33 (64bit)
PHP 7.2.6 (64bit)

additional Information: Despite this error message, the survey gets imported, but only with question groups and without questions!

Why don't you use MySQL by the way? Why mssql?

Client requirements I'm afraid, they are a MSSQL shop.

How does your freetds.conf look like?

I dont appear to have a freetds.conf file on my local machine (Windows) which is displaying the error. I'll try and grab the copy of the RedHat box which is also experiencing the problem.

I have put in a pull request to address the fix. The issue is that the SQL PDO driver has changed its implementation so if you pass in a sequence name, it will always try and get a ID from a sequence, even on MSSQL. Comment from the code;

"Before version 5.0, the SQLSRV driver supports PDO::lastInsertId() with one peculiarity: when $sequence's value is null or empty string it returns empty string. But when parameter is not specified at all it's working as expected and returns actual last inserted ID (like other PDO drivers). 5.0 of the Microsoft PHP Drivers for SQL Server changes the behaviour of PDO::lastInsertID to be consistent with the behaviour outlined in the PDO documentation. It returns the ID of the last inserted sequence or row."

This change has come from the tip of the yii-1.19-dev code I'm not sure if their will be a further release (yii 1.1x is at end of life).

Pull Request Here: https://github.com/LimeSurvey/LimeSurvey/pull/1090

The relevant yii commit is here: https://github.com/yiisoft/yii/commit/7b768c304289ede574768de68939224d1180e2b1

Hi,

any update on when this issue and\or pull request might be reviewed?

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

This version of LimeSurvey is not longer supported. Please check so that the issue is fixed in a more recent version of LimeSurvey. If it's not, reopen this bug report. Thank you.