[
https://issues.apache.org/jira/browse/OFBIZ-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14062714#comment-14062714
]
Pierre Smits commented on OFBIZ-5685:
-------------------------------------
The Following Errors Occurred:
{code}
Exception thrown while storing entity value:
org.ofbiz.entity.GenericEntityException: Error while updating:
[GenericEntity:SurveyQuestionAppl][createdStamp,2014-07-15
22:27:47.494(java.sql.Timestamp)][createdTxStamp,2014-07-15
22:27:47.406(java.sql.Timestamp)][externalFieldRef,null()][fromDate,2014-07-15
22:27:47.494(java.sql.Timestamp)][lastUpdatedStamp,2014-07-15
23:50:46.078(java.sql.Timestamp)][lastUpdatedTxStamp,2014-07-15
23:50:46.016(java.sql.Timestamp)][requiredField,N(java.lang.String)][sequenceNum,3(java.lang.Long)][surveyId,10000(java.lang.String)][surveyMultiRespColId,null()][surveyMultiRespId,null()][surveyPageSeqId,null()][surveyQuestionId,10061(java.lang.String)][thruDate,null()][withSurveyOptionSeqId,Y(java.lang.String)][withSurveyQuestionId,10020(java.lang.String)]
(SQL Exception while executing the following:UPDATE
public.SURVEY_QUESTION_APPL SET THRU_DATE=?, SURVEY_PAGE_SEQ_ID=?,
SURVEY_MULTI_RESP_ID=?, SURVEY_MULTI_RESP_COL_ID=?, REQUIRED_FIELD=?,
SEQUENCE_NUM=?, EXTERNAL_FIELD_REF=?, WITH_SURVEY_QUESTION_ID=?,
WITH_SURVEY_OPTION_SEQ_ID=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?,
CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE SURVEY_ID=? AND SURVEY_QUESTION_ID=?
AND FROM_DATE=? (ERROR: insert or update on table "survey_question_appl"
violates foreign key constraint "srvyqstapl_svqo" Detail: Key
(with_survey_question_id, with_survey_option_seq_id)=(10020, Y) is not present
in table "survey_question_option".)) (Error while updating:
[GenericEntity:SurveyQuestionAppl][createdStamp,2014-07-15
22:27:47.494(java.sql.Timestamp)][createdTxStamp,2014-07-15
22:27:47.406(java.sql.Timestamp)][externalFieldRef,null()][fromDate,2014-07-15
22:27:47.494(java.sql.Timestamp)][lastUpdatedStamp,2014-07-15
23:50:46.078(java.sql.Timestamp)][lastUpdatedTxStamp,2014-07-15
23:50:46.016(java.sql.Timestamp)][requiredField,N(java.lang.String)][sequenceNum,3(java.lang.Long)][surveyId,10000(java.lang.String)][surveyMultiRespColId,null()][surveyMultiRespId,null()][surveyPageSeqId,null()][surveyQuestionId,10061(java.lang.String)][thruDate,null()][withSurveyOptionSeqId,Y(java.lang.String)][withSurveyQuestionId,10020(java.lang.String)]
(SQL Exception while executing the following:UPDATE
public.SURVEY_QUESTION_APPL SET THRU_DATE=?, SURVEY_PAGE_SEQ_ID=?,
SURVEY_MULTI_RESP_ID=?, SURVEY_MULTI_RESP_COL_ID=?, REQUIRED_FIELD=?,
SEQUENCE_NUM=?, EXTERNAL_FIELD_REF=?, WITH_SURVEY_QUESTION_ID=?,
WITH_SURVEY_OPTION_SEQ_ID=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?,
CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE SURVEY_ID=? AND SURVEY_QUESTION_ID=?
AND FROM_DATE=? (ERROR: insert or update on table "survey_question_appl"
violates foreign key constraint "srvyqstapl_svqo" Detail: Key
(with_survey_question_id, with_survey_option_seq_id)=(10020, Y) is not present
in table "survey_question_option".)))
{code}
Which is happening because boolean values (Y or N) are not known as
surveyQuestionOptions.
> Setting a dependent question for question of type 'Boolean Yes/No' is not
> possible
> ----------------------------------------------------------------------------------
>
> Key: OFBIZ-5685
> URL: https://issues.apache.org/jira/browse/OFBIZ-5685
> Project: OFBiz
> Issue Type: Bug
> Components: content
> Affects Versions: Release Branch 13.07, Release Branch 12.04, Release
> Branch 11.04, Trunk
> Reporter: Pierre Smits
>
> When having question 1 of type 'Boolean Yes/No' a second question being
> dependent on one of either options can not be set to be dependent on question
> 1.
> This is due to the fact that the select options Yes and No don't have an
> option value assigned. See code exerpt from html source below:
> {code}
> <div>Did you enjoy the show?</div>
> </td>
> <td width="1"> </td>
> <td align="right">
> <select name="answers_10020">
> <option value=""></option>
> <option selected="selected">Y</option>
> <option >N</option>
> </select>
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
