Hello Everyone,

I am trying to run a limesurvey through Amazon Mechanical Turk. My active lime survey functions properly when tested outside of Mturk, but when I test it in the workers sandbox this error occurs:

ERROR: column "assignmentId" of relation "lime_survey_76532" does not exist LINE 1: UPDATE lime_survey_76532 SET "lastpage"='-1', "assignmentId"... ^:UPDATE lime_survey_76532 SET "lastpage"='-1', "assignmentId"='A', "hitId"='3' WHERE ID=6

I've verified that the assignment ID column does exist in the database and in the limesurvey responses. I've also changed the end URL in lime survey to reflect the workers sandbox URL versus the production URL.

Does anyone have any ideas what is going on here?

Thank you in advance for any help you can provide.

Amanda

assignmentId or hitId ????

What is this column ? I don't remind to have this column in LS core.

Denis

Hi Dennis,

Thank you for your reply. I have added two hidden questions in order to save the hit ID and assignment ID in the lime survey.

Thank you,

Amanda

Yes, but in the DB this 2 question must be set to sidXgidXqid.

Then you must use sidXgidXqid . What do you want to do , and how do you do it ?