Syntax error when launching with a Token table

Plus d'informations
il y a 2 jours 1 heure #168897 par RaphPro
RaphPro a créé le sujet : Syntax error when launching with a Token table
Good morning everyone!

I'm brand new on this forum, but a user of LimeSurvey for several months.
I really appreciate what this great tool can do!

Recently, some colleagues of mine and myself experienced an issue with the Token table.
Let's recap:
1. We build the survey and test it: fine;
2. We initiate a list of participants: fine;
3. We import the list of participants (.csv), no error: fine;
4. We generate tokens: fine;
5. When we try to launch the survey with any of the tokens, we experience the same issue, as described below.

Error message is:
"CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"
LINE 2: ("startlanguage", "", "", "", "", "", "", "", "")"
No matter if we try to launch the survey from the token table or via the invitations sent by email.

Version is 2.73.1 (sorry, I know this is an old version but I cannot update it myself).

I tried to Google the issue and to delete and re-create the token table, but the same message appears. It seems not to be survey-specific as we have the issue on several surveys.
I compared the .csv files generated by failing and working surveys but I could not detect any differences that could explain the error.

I am sorry, this may be for a very simple reason, but for now I cannot figure out why on my side...

Any idea is welcome, thanks a lot in advance!

Best regards,

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 jour 21 heures #168905 par Joffm
Joffm a répondu au sujet : Syntax error when launching with a Token table
Hi,
the best is to provide a sample survey (*.lss) and a dummy csv participants file that show the error on your side.

Maybe somebody can reproduce and see where there is an issue.

And IMO not all fields behind "language" should be empty.
These are "validfrom,validuntil,invited,reminded,remindercount,completed,usesleft"
"invited", "reminded" and "completed" should be "Y" or "N"
"remindercount" and "usesleft"some numeric value.


Best regards
Joffm
Les utilisateur(s) suivant ont remercié: RaphPro

Connexion ou Créer un compte pour participer à la conversation.

Plus d'informations
il y a 1 jour 17 heures #168923 par RaphPro
RaphPro a répondu au sujet : Syntax error when launching with a Token table
Hi Joffm,

Thanks a lot for your reply!

I checked, the following fields are correctly filled-in. When I open the window to modify the participant, I cannot see any error.
"validfrom,validuntil" are empty, but even filling then in does not improve the situation...

Anyhow, I will try to generate a dummy file on Monday for you to test.

Thanks again!

Best regards,

RaphPro

Connexion ou Créer un compte pour participer à la conversation.

Commencez dès maintenant !

Créez simplement un compte et commencez à utiliser LimeSurvey dès aujourd'hui.

Inscrivez-vous maintenant

Inscrivez-vous à notre Newsletter!