From: SourceForge.net <no...@so...> - 2004-09-14 15:43:52
|
Bugs item #1027980, was opened at 2004-09-14 08:07 Message generated for change (Comment added) made by nobody You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1027980&group_id=8956 Category: Admin Group: None Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Zero value in choice_id on required field Initial Comment: My survey has a large number of 'response_single' replies which are marked as 'required'. The survey handler treats this perfectly - i.e. respondents are blocked from passing onto next question before the previous has been answered. When reviewing the database I notice that approx 40 out of 6000 rows in the 'response_single' table have a zero-value (0) in it for the field 'choice_id'. Since all the underlying questions are "required" I cannot understand how that should be possible. I have tried very hard to provoke this error without luck. Mostly the surveys are run with permission to save and resume but even when I have turned that off I see the problem occassionally. I enclose a dump of the 'response_single' table. Thanks, Søren Voigt ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2004-09-14 08:43 Message: Logged In: NO Are you sure that the responses w/ zeros were completed? select id from response where complete = 'Y'; -James ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1027980&group_id=8956 |