Character limit on token attribute field?

Mehr
3 Jahre 7 Monate her #107014 von ChacoKevy
ChacoKevy erstellte das Thema Character limit on token attribute field?
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

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 7 Monate her #107017 von holch
holch antwortete auf das Thema: Character limit on token attribute field?
What is the length of your tokens?

What did you set in "Set token length to:" (General settings --> Tokens)?

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 7 Monate her #107018 von ChacoKevy
ChacoKevy antwortete auf das Thema: Character limit on token attribute field?
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.

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 7 Monate her #107021 von holch
holch antwortete auf das Thema: Character limit on token attribute field?
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.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Bitte Anmelden um an der Konversation teilzunehmen.

Mehr
3 Jahre 7 Monate her #107035 von DenisChenu
DenisChenu antwortete auf das Thema: Character limit on token attribute field?
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

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 .

Bitte Anmelden um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha