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
Started 10 years ago by barb080M | 2 posts |
-
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 # -
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 #
Reply
You must log in to post.