Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Character limit on token attribute field?

Character limit on token attribute field? il y a 6 mois 3 semaines #107014

  • ChacoKevy
  • Portrait de ChacoKevy
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • 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
L'administrateur a désactivé l'accès en écriture pour le public.

Character limit on token attribute field? il y a 6 mois 3 semaines #107017

  • holch
  • Portrait de holch
  • Hors ligne
  • LimeSurvey Team
  • Messages : 2852
  • Remerciements reçus 359
  • Karma: 124
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!
L'administrateur a désactivé l'accès en écriture pour le public.

Character limit on token attribute field? il y a 6 mois 3 semaines #107018

  • ChacoKevy
  • Portrait de ChacoKevy
  • Hors ligne
  • Junior Lime
  • Messages : 20
  • 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.
L'administrateur a désactivé l'accès en écriture pour le public.

Character limit on token attribute field? il y a 6 mois 3 semaines #107021

  • holch
  • Portrait de holch
  • Hors ligne
  • LimeSurvey Team
  • Messages : 2852
  • Remerciements reçus 359
  • Karma: 124
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!
L'administrateur a désactivé l'accès en écriture pour le public.

Character limit on token attribute field? il y a 6 mois 3 semaines #107035

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 6451
  • Remerciements reçus 844
  • Karma: 249
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
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.132 secondes
Donation Image