Error when importing a survey ( SQLSTATE[22001] )

More
3 years 2 months ago #112812 by zelwiux92
zelwiux92 created the topic: Error when importing a survey ( SQLSTATE[22001] )
Hey guys,

One of the users can't import a survey. He could when it was Limersurvey 1.95. Now it is 2.05. He gets this message: CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.
But I (administrator) can import, only question numbers change. What should I do? Maybe the message is not correct, and the problem is with this user's permissions? If it is, where could I change that?

Please Log in to join the conversation.

More
3 years 2 months ago #112824 by zelwiux92
zelwiux92 replied the topic: Error when importing a survey ( SQLSTATE[22001] )
Good! I found the problem, using SQL Server profiler. The subject of email message, which is sent to administrator, when there is new response, was too long. But I would really appreciate, if you could tell me, why administrator could insert such value but not the regular user?

Please Log in to join the conversation.

More
3 years 2 months ago #112825 by DenisChenu
DenisChenu replied the topic: Error when importing a survey ( SQLSTATE[22001] )
Hi,

Think this one must be reported as a bug : bug report

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!