MachForm Community Forums » MachForm 3

1. maperformance
   Member

   I tried filtering one of our form's entries to show only those with a PAID status and it cam back witht his error:

   SQL: [251] select count(*) total_row from (select id, id as row_num, date_created,element_1_1,element_1_2,element_2 from ap_form_1 A WHERE (payment_status = 'paid') AND status=1 ) B Params: 0 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_status' in 'where clause'

   Now I can't clear the filter to get rid of this. How can I fix it?

   Posted 11 years ago #

2. Saghalie
   Pro Member

   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.

   Regards,

   Saghalie
   http://www.kcmhosting.com

   Posted 11 years ago #

3. maperformance
   Member

   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.

   Posted 11 years ago #
4. 

   yuniar

   maperformance -- this is a bug indeed. Please contact us directly and we'll send you a fix for this.
   http://www.appnitro.com/contact

   ---

   MachForm Founder

   Posted 11 years ago #

5. bebinim
   Member

   I do have the same problem :
   SQL: [340] select count(*) total_row from (select id, id as row_num ,element_320,element_5 from ap_form_17179 A WHERE (date(date_created) < '2013-11-12' AND (payment_status = '' OR payment_status IS NULL) AND element_1_1 = '1' AND element_1_1 = '1') AND status=1 ) B Params: 0 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'payment_status' in 'where clause'

   in one form and :

   SQL: [900] select count(*) total_row from (select id, id as row_num ,date_created,element_322,element_5 ,(select payment_amount from ap_form_payments where form_id='16432' and record_id=A.id order by afp_id desc limit 1) payment_amount,ifnull((select payment_status 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'

   in another form ... they are two different errors ... but i cannot do anything to bypass the page.

   Posted 11 years ago #

6. bebinim
   Member

   I added some fields to the form with first problems, then duplicated them and deleted some ... and that fixed the first problem ..
   but the second problem ..did the same thing ... still gives me the error code.

   Posted 11 years ago #
7. 

   yuniar

   bebinim -- Is it possible for you to contact us directly and let us know temporary FTP login to your machform folder?
   We'll need to check this directly.

   It seems there is some problem with the record of that form.

   ---

   MachForm Founder

   Posted 11 years ago #

RSS feed for this topic

Reply

You must log in to post.