[done] Incompletes in data base but data recorded (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: [done] Incompletes in data base but data recorded
|
Mazi (Moderator)
Moderator Lime
Posts: 3262
|
|
Re:Incompletes in data base but data recorded 4 Months, 3 Weeks ago
|
Karma: 25
|
|
The completed field can be found at the lime_tokens_12345 table (depending on your survey settings).
|
|
|
|
 Logged
|
|
|
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact. |
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Incompletes in data base but data recorded 4 Months, 3 Weeks ago
|
Karma: 5
|
|
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
|
|
|
|
Logged
|
|
|
Last Edit: 2008/07/02 15:41 By paulalford.
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Incompletes in data base but data recorded 4 Months, 3 Weeks ago
|
Karma: 39
|
|
Hello Paul,
I am sorry. I meant the submitdate field, of course.
That is what submitted results separates from incomplete results.
|
|
|
|
Logged
|
|
|
Best regards
Carsten Schmitz
LimeSurvey Project Leader
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Incompletes in data base but data recorded 4 Months, 3 Weeks ago
|
Karma: 5
|
|
Brilliant. Cheers Carsten.
|
|
|
|
Logged
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Incompletes in data base but data recorded 4 Months, 3 Weeks ago
|
Karma: 39
|
About the fix:
The fixed file is attached to the bug report at
bugs.limesurvey.org/view.php?id=2193
I found the bug today thanks to Joe. |
|
|
|
Logged
|
|
|
Best regards
Carsten Schmitz
LimeSurvey Project Leader
|
|
|
The administrator has disabled public write access.
|
|
|
|
Re:Incompletes in data base but data recorded 4 Months, 2 Weeks ago
|
Karma: 39
|
|
Please update to the latest version, where the bug is fixed now.
|
|
|
|
Logged
|
|
|
Best regards
Carsten Schmitz
LimeSurvey Project Leader
|
|
|
The administrator has disabled public write access.
|
|
 |
|
|
