MachForm Community Forums » MachForm 2

1. gothmane
   Member

   Hi when I try to login to the admin panel of machform, it gives me the following error:

   select count(*) total_entry from ap_form_10 Query failed: Table 'table.ap_form_10' doesn't exist.

   What could be wrong?

   Posted 16 years ago #
2. 

   yuniar

   Hmm.. it looks like one of your table wasn't deleted properly.
   Try to check your form which have id = 10

   Should be like this: http://www.example.com/machform/view.php?id=10

   Is it there? Is the form supposed to be deleted?

   ---

   MachForm Founder

   Posted 16 years ago #

3. gothmane
   Member

   You're right. I have only till form id 6. The rest seem to be partial and they are not supposed to be there. How do I rectify it? how do I delete these forms and gain access to the admin panel?

   Posted 16 years ago #
4. 

   redityo

   Hi..

   I think you should delete missing reference form id in some tables. You can use PhpMyAdmin to do this step and do it carefully :)

   1. go to SQL window
   2. copy paste this SQL
   

   delete from ap_forms where form_id = '10';
   delete from ap_form_elements where form_id = '10';
   delete from ap_element_options where form_id = '10';
   delete from ap_column_preferences where form_id = '10';

   10 is missing form id that you've mention. after that you can try to access the admin panel again. If you get similar error like before you have to run the SQL again with different form id.

   for example. this error indicate form id = 9

   select count(*) total_entry from ap_form_9 Query
   failed: Table 'table.ap_form_9' doesn't exist.

   ---

   MachForm Support

   Posted 16 years ago #

5. gothmane
   Member

   You guys are a genius!!! It worked!! :D

   Posted 16 years ago #

RSS feed for this topic

Reply

You must log in to post.