This forum is no longer open and is for reading/searching only.

Please use our new MachForm Community Forum instead.

MachForm Community Forums » MachForm 4

Logic Troubleshooting


  1. barb080M
    Member

    Have set up a rule for skipping to a particular page in the form, when I go to edit the rule or add another rule the following script appears, how is this fixed please anyone know?

    "SQL: [653] select A.element_id, A.option_id, (select if(B.element_matrix_parent_id=0,A.option, (select C.option from ap_element_options C where C.element_id=B.element_matrix_parent_id and C.form_id=A.form_id and C.live=1 and C.option_id=A.option_id)) ) 'option_label' from ap_element_options A left join ap_form_elements B on (A.element_id=B.element_id and A.form_id=B.form Params: 1 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Query Failed: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row."

    Thanks Barb

    Posted 10 years ago #
  2. yuniar

    What version of MachForm do you use? There seems to be some issue with the records within your database.
    Can you contact us directly please? We'll help to check it.

    http://www.appnitro.com/contact


    MachForm Founder

    Posted 10 years ago #

RSS feed for this topic

Reply