Syntax error when launching with a Token table

Mehr
3 Tage 19 Stunden her #168897 von RaphPro
RaphPro erstellte das Thema 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,

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
3 Tage 15 Stunden her #168905 von Joffm
Joffm antwortete auf das Thema: 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
Folgende Benutzer bedankten sich: RaphPro

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
3 Tage 11 Stunden her #168923 von RaphPro
RaphPro antwortete auf das Thema: 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

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
12 Stunden 18 Minuten her #168989 von RaphPro
RaphPro antwortete auf das Thema: Syntax error when launching with a Token table
Hi again,

I then tried to create a dummy survey, to reproduce the error.
I think the issue is really with the token table, not the survey, as I could reproduce the error on different surveys with the same table.
I suppose this is due to the .csv file I try to import.
I attach here below the result from the CSV file generated by LimeSurvey after the import; I have no error after the import.

Thanks in advance for your help!

Best regards,

Raphaël
Anhang:

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Mehr
10 Stunden 18 Minuten her #168995 von holch
holch antwortete auf das Thema: Syntax error when launching with a Token table
Your CSV file imported without any errors into my Version 3.7.3+180516, as well as into my Version 2.73.1+171220.

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 oder Registrieren 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