https://www.machform.com/forums/ MachForm Community Forums Topic: SQL error when setting entries filter en Mon, 04 May 2026 00:07:21 +0000 https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-19623 Sat, 09 Nov 2013 17:07:38 +0000 yuniar 19623@https://www.machform.com/forums/ <p>bebinim -- Is it possible for you to contact us directly and let us know temporary FTP login to your machform folder?<br /> We'll need to check this directly.</p> <p>It seems there is some problem with the record of that form. </p> https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-19604 Fri, 08 Nov 2013 02:32:03 +0000 bebinim 19604@https://www.machform.com/forums/ <p>I added some fields to the form with first problems, then duplicated them and deleted some ... and that fixed the first problem ..<br /> but the second problem ..did the same thing ... still gives me the error code. </p> https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-19603 Fri, 08 Nov 2013 02:20:13 +0000 bebinim 19603@https://www.machform.com/forums/ <p>I do have the same problem :<br /> SQL: [340] select count(*) total_row from (select <code>id</code>, <code>id</code> as <code>row_num</code> ,<code>element_320</code>,<code>element_5</code> from ap_form_17179 A WHERE (date(date_created) &lt; '2013-11-12' AND (payment_status = '' OR payment_status IS NULL) AND element_1_1 = '1' AND element_1_1 = '1') AND <code>status</code>=1 ) B Params: 0 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_status' in 'where clause'</p> <p>in one form and :</p> <p>SQL: [900] select count(*) total_row from (select <code>id</code>, <code>id</code> as <code>row_num</code> ,<code>date_created</code>,<code>element_322</code>,<code>element_5</code> ,(select <code>payment_amount</code> from ap_form_payments where form_id='16432' and record_id=A.id order by afp_id desc limit 1) payment_amount,ifnull((select <code>payment_status</code> from ap_form_payments where form_id='16 Params: 0 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'element_322' in 'field list'</p> <p>in another form ... they are two different errors ... but i cannot do anything to bypass the page. </p> https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-17253 Sat, 16 Feb 2013 05:34:48 +0000 yuniar 17253@https://www.machform.com/forums/ <p>maperformance -- this is a bug indeed. Please contact us directly and we'll send you a fix for this.<br /> <a href="http://www.appnitro.com/contact" rel="nofollow">http://www.appnitro.com/contact</a> </p> https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-17237 Fri, 15 Feb 2013 21:38:35 +0000 maperformance 17237@https://www.machform.com/forums/ <p>Thanks for the feedback. I understand WHY the error is showing, but like I stated I cannot edit or clear the filter. HOW do I clear or change the filter when those links on the page do nothing? Seems like a bug to me. </p> https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-17210 Fri, 15 Feb 2013 03:45:43 +0000 Saghalie 17210@https://www.machform.com/forums/ <p>Where did you apply the filter? It looks to me like you put the incorrect column name in the filter itself. So check your database and make sure you are using the correct column (e.g. payment_status). The column name might not be correct.</p> <p>Regards,</p> <p>Saghalie<br /> <a href="http://www.kcmhosting.com" rel="nofollow">http://www.kcmhosting.com</a> </p> https://www.machform.com/forums/topic/sql-error-when-setting-entries-filter#post-17205 Thu, 14 Feb 2013 23:20:28 +0000 maperformance 17205@https://www.machform.com/forums/ <p>I tried filtering one of our form's entries to show only those with a PAID status and it cam back witht his error:</p> <p>SQL: [251] select count(*) total_row from (select <code>id</code>, <code>id</code> as <code>row_num</code>, <code>date_created</code>,<code>element_1_1</code>,<code>element_1_2</code>,<code>element_2</code> from ap_form_1 A WHERE (payment_status = 'paid') AND <code>status</code>=1 ) B Params: 0 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_status' in 'where clause'</p> <p>Now I can't clear the filter to get rid of this. How can I fix it? </p>