https://www.machform.com/forums/ MachForm Community Forums Topic: Entries Tab en Thu, 18 Jun 2026 14:04:41 +0000 https://www.machform.com/forums/topic/entries-tab#post-15434 Mon, 23 Jul 2012 22:51:47 +0000 flinthamm 15434@https://www.machform.com/forums/ <p>I upgraded to v3.3 over the weekend but the problem is exactly the same? I have taken a quick look but do not have much time at the moment and was unable to find the problem? Your help would be appreciated. </p> https://www.machform.com/forums/topic/entries-tab#post-15432 Sun, 22 Jul 2012 17:43:23 +0000 yuniar 15432@https://www.machform.com/forums/ <p>If you haven't updated to v3.3, I suggest to update your machform. There was some bug with the previous versions that occured on certain conditions and caused errors as above. </p> https://www.machform.com/forums/topic/entries-tab#post-15425 Sat, 21 Jul 2012 23:28:45 +0000 flinthamm 15425@https://www.machform.com/forums/ <p>First off, can't praise you guys enough, this is a really fantastic application, keep up your great work!</p> <p>I have this problem too and it appear to happen as soon as you have 10 or more forms. If you call /manage_entries.php?id=10 with a double digit number the SQLerror above is displayed and you cannot see any entries. I am just going to investigate the code as it's preventing me from getting at data for one of my critical forms.</p> <p>Hope this helps and will re-post if I find the problem! </p> https://www.machform.com/forums/topic/entries-tab#post-15122 Sat, 23 Jun 2012 05:21:43 +0000 badtrout 15122@https://www.machform.com/forums/ <p>I have about half of my forms giving this error. (V3.2) No rhyme or reason... I would give you my FTP but I upload directly to my host... can i just get you my login and password? </p> https://www.machform.com/forums/topic/entries-tab#post-14925 Tue, 29 May 2012 10:12:14 +0000 redityo 14925@https://www.machform.com/forums/ <p>Hi,</p> <p>It seems you have problem with one of your form entry and we need to check the problem further.<br /> Could you send your ftp and machform login info to :</p> <p>customer.service[at]appnitro.com </p> https://www.machform.com/forums/topic/entries-tab#post-14919 Mon, 28 May 2012 22:27:25 +0000 clbks 14919@https://www.machform.com/forums/ <p>With one of my forms when I click on the Entries Tab to view submissions I get the following error. All other forms work fine.</p> <p>SQL: [672] select A.element_id, A.option_id, (select if(B.element_matrix_parent_id=0,A.option, (select C.<code>option</code> 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 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 </p>