The completed field can be found at the lime_tokens_12345 table (depending on your survey settings).

Mazi,

That isn't any good. From the look of Carstens post it sounds like there should be a field in the completed results table (survey_xxxxx). The tokens table contains all tokens, in my case, over 4000. So if I issue an update completed field set to "Y" SQL command ALL 4000+ records are set to "Y". Not good as we then won't be able to send any reminder emails.

Somewhere there must be a field that flags the respondent as a complete. If it is the tokens table then that isn't what Carsten mentioned and also if you can link the tokens table to the responses table then you have blown all anonymity. All of a sudden I can check who said what = BAD.

Cheers
Paul

Hello Paul,

I am sorry. I meant the submitdate field, of course.
That is what submitted results separates from incomplete results.

Brilliant. Cheers Carsten.

About the fix:

The fixed file is attached to the bug report at

http://bugs.limesurvey.org/view.php?id=2193

I found the bug today thanks to Joe.

Please update to the latest version, where the bug is fixed now.