MachForm Community Forums » MachForm 2

1. christo
   Member

   Hi,
   I am getting the following error when I try to view entries from the admin area. Can you please tell me what I might have done to cause such an error and how to fix?

   select id,id as row_num,date_created,date_updated,element_17,element_19,element_2_3,element_2_4,element_3,element_8,element_14,element_15_1,element_5,element_6,element_9,element_43,element_53,element_59,element_60 from ap_form_9 order by id desc LIMIT 0,15 Query failed: Unknown column 'element_43' in 'field list'

   thanks very much!
   Chris

   Posted 14 years ago #
2. 

   redityo

   It seems you've a missing field in machform table, try to run this SQL from PHPMyAdmin :

   delete from ap_column_preferences where form_id = 9

   However if you prefer to do by us, please send me your FTP login info to :

   customer.service[at]appnitro.com

   I will help you

   ---

   MachForm Support

   Posted 14 years ago #

3. christo
   Member

   Hi - Thanks for the response. so just drop that in there an it should address the problem without messing up the form that I have created or the data in the database?

   Posted 14 years ago #

4. christo
   Member

   and when I say "drop in in there" I am asking if I can just drop:

   delete from ap_column_preferences where form_id = 9

   in the box below "Run SQL query/queries on database" for the machform database in phpmyadmin and click "go" and it should solve the problem?

   Thanks,
   Chris

   Posted 14 years ago #

RSS feed for this topic

Reply

You must log in to post.