Welcome, Guest
Username: Password: Remember me

TOPIC: Character limit on token attribute field?

Character limit on token attribute field? 10 months 3 weeks ago #107014

  • ChacoKevy
  • ChacoKevy's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 21
  • Karma: 1
Hi there,
Got this error when uploading tokens:
Internal Server Error

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.

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

Now, I know where in my .csv the error is occurring, but I'd like for it to stop. Is it a LS restriction on how many characters I can upload to the token attribute fields or one put on LS by my DB admin? Not sure where to start.
Thanks!
-CK
The administrator has disabled public write access.

Character limit on token attribute field? 10 months 3 weeks ago #107017

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 3189
  • Thank you received: 424
  • Karma: 134
What is the length of your tokens?

What did you set in "Set token length to:" (General settings --> Tokens)?
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Character limit on token attribute field? 10 months 3 weeks ago #107018

  • ChacoKevy
  • ChacoKevy's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 21
  • Karma: 1
15, but it's not an issue with the token length in the URL. It's the number of characters within an attribute field when uploading a .csv to the token table. Specifically, attribute_5 crashes the upload when it sometimes carries what appears to be an entire paragraph of text.
The administrator has disabled public write access.

Character limit on token attribute field? 10 months 3 weeks ago #107021

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 3189
  • Thank you received: 424
  • Karma: 134
Well, I don't think that the token attributes were supposed to contain an entire paragraph of text. I can imagine that the limit is 256 characters, but I am not sure. Maybe one of the developers chan give you more info.

And it seems like you use a Microsoft SQL server? Might be a problem with that too. There have been some issues with MS SQL before, I think.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Character limit on token attribute field? 10 months 3 weeks ago #107035

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6886
  • Thank you received: 925
  • Karma: 275
Hi,

If you can confirm the CDbCommand error with the last version, please put a bug report with the CSV of token to be uploaded and a lsa file for the token table.

Denis
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.115 seconds
Donation Image