Error when importing a survey ( SQLSTATE[22001] )

More
3 years 8 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 or Create an account to join the conversation.

More
3 years 8 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 or Create an account to join the conversation.

More
3 years 8 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 or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!