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

Please use our new MachForm Community Forum instead.

MachForm Community Forums » MachForm 3

SQL Error encountered at end of questionnaire


  1. Jas123
    Member

    http://www.dealingwithbailiffs.co.uk/forms/view.php?id=20339

    go to the very last question and i get this...

    SQL: [568] SELECT count(B.element_title) total_row FROM( SELECT A.element_123, (select option from ap_element_options where form_id = ? and element_id = ? and option_id = A.element_123 and live = 1) element_title FROM ap_form_20339_review A WHERE session_id = ? Params: 3 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Key: Position #1: paramno=1 name=[0] "" is_param=1 param_type=2 Key: Position #2: paramno=2 name=[0] "" is_param=1 param_type=2 Query Failed: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row

    Help!?

    Posted 10 years ago #
  2. yuniar

    There seems to be an issue with the record of your form fields.
    Is it possible for you to send us the FTP login info to your machform folder?

    We'll check it directly.
    Please send it to: customer.service [at] appnitro.com


    MachForm Founder

    Posted 10 years ago #

RSS feed for this topic

Reply