_ft_cache_form_stats, line 1704

[ClaudiaUSA]

I have by accident deleted one table in my MySQL database via the Administration Tool on my webhost.
That was a table used by Formtools.org.
Now I can't get the list of my forms anymore when I start formtools.
This message shows up:
_ft_cache_form_stats, line 1704

Please advice - I need the overview of my forms back.

[mrGarvin]

Which table was it that you deleted? Can you access anything else, except the list of forms?

The function _ft_cache_form_stats seems to be used to check for nr of submissions, sessions and other stats for a form.

You might try to use the System Check module (and more specific: the Table Verification) to check your table structure. Read more about it here:
http://modules.formtools.org/system_check/?page=index

Install the module from here: http://www.formtools.org/download.php

You can also read http://forums.formtools.org/showthread.php?tid=1861 to see if that thread helps.

[ClaudiaUSA]

Thank you so much, MrGarvin, for picking up and be willing to help me out. I am a big fan of Formtools.org and have brought our School Lunch Order, Volunteer Registration, School Directory all online with help of this tool. It works just well. I am not a SW programmer, but have small knowledge in programming.
I deleted one table created by Formtools in my MYSQL (I did that via my web host account). I think, the table was still in the "initialize" phase.
I have checked the tables via System Check. Everything comes back just fine.
I can see the tables via the module "Submission History"

But my main overview of the tables is gone. The menu "- Forms" brings above error message.
Thank you so much for your help.
I couldn't find anything helpful in the other thread.

[mrGarvin]

No problems... but I'm no programmer either so my help is ... well, what it is :-)

So, if I understand you correctly, what you did was that you deleted a created form table? Nothing else...or? No system critical table?

I think I know the problem, but can't verify it now. I'll have to check my tables when I get back to work.
What I'm guessing might be the problem is that there probably is a system table that keeps track of all your forms. When you delete a form the "right way" (from the interface that is) the link to that form is removed from this table, but since you deleted it from a mySql editor the link is still there, but now the link is broken. Thus causing the problem. But it's just a guess (though I think I'm on the right track here).
Have you done the complete system check? I think one of the checks is for orphants of that kind...
But I'll check in again tomorrow with a better answer (Swedish time here, so it's later in the evening now) if you haven't found a solution yet.

Good luck!

//Peter

[ClaudiaUSA]

Hi Peter,
thank you so much for your advice. Following you thoughts I was looking for the place where Formtools has this "system table" that keeps track of all the forms.

This is a field "ft_forms" in your MySQL database used by Formtools. I looked at the entries of that field via the mySql editor of my web host and found the link (which is an entry in this field) to the table I have deleted.
I deleted this one entry in the field "ft_forms" and everything is fine again.
You have pointed me in the right direction.

Thank you so much - from Pennsylvania, originally from Germany
Claudia

[mrGarvin]

Perfect! Glad I could help, and yes, that was the table I was thinking about.
You're welcome, former european :-)