MachForm Community Forums » MachForm 3

1. Lokidog
   Member

   I'm getting this when I select the "Submit" button, and get no further.

   SQL: [652] 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

   Looks like it has something to do with "Logic" but I'm only using the Matrix field as a Q&A and not using conditional questions.

   Form is here:
   http://www.davidarmstrongdesign.com/digital-online/view.php?id=57

   The form is not active yet but soon will be, any ideas where I have gone wrong?

   //David

   Posted 10 years ago #
2. 

   yuniar

   It seems there is some problem with the matrix field structure.
   We'll need to check directly into your database for this.

   Can you contact us directly and let us know temporary FTP login to your machform folder please?
   We'll check it.

   ---

   MachForm Founder

   Posted 10 years ago #

3. Lokidog
   Member

   Details sent via contact form

   Posted 10 years ago #

4. Lokidog
   Member

   Hi Yuniar
   is there any progress with this problem? :)

   Posted 10 years ago #

5. AMurray
   Pro Member

   Appnitro had trouble with their systems. In case you haven't seen the announcement (in the forum list) about the support delay:

   http://www.appnitro.com/forums/topic/news-support-delay?replies=2

   Posted 10 years ago #

6. Lokidog
   Member

   Thanks for the up AMurray, I did miss that.
   I did think it strange and unusual at the time that the support ticket was taking some time as I usually get a quick response within 48 hrs.

   However, everything has now been fixed by Yuniar and all is well again. :)

   Thanks Yuniar!

   Posted 10 years ago #

RSS feed for this topic

Reply

You must log in to post.