Time Out Error and Crash After Update
Permalink Browser Info Environment
Hello,
We have been using this block without any issues for a couple of years. Recently, we started experiencing issues searching for form submissions. This morning we were unable to access form submissions at all (see attached Before Update.jpg)
I suspected there may be to issues that caused this 1.) there were to many saved submissions and deleting them may solve the problem. The issue is now that I can't access them at all, I am unable to delete them. Is it possible to do this through the database? 2.) I needed to install an update. I tried this step first and I got an error that causes Formidable not to work. Clicking on it through the dashboard gives me this issue attached (After Update.png)
Can you please help me get this up and running again?
Thanks,
Jim
We have been using this block without any issues for a couple of years. Recently, we started experiencing issues searching for form submissions. This morning we were unable to access form submissions at all (see attached Before Update.jpg)
I suspected there may be to issues that caused this 1.) there were to many saved submissions and deleting them may solve the problem. The issue is now that I can't access them at all, I am unable to delete them. Is it possible to do this through the database? 2.) I needed to install an update. I tried this step first and I got an error that causes Formidable not to work. Clicking on it through the dashboard gives me this issue attached (After Update.png)
Can you please help me get this up and running again?
Thanks,
Jim
| Type: | Pre-Sale |
|---|---|
| Status: | In Progress |
Thank you for your reply Corretje.
I have the attachments that were missing in my previous post attached. Sorry about that. I ran both of the queries that you gave me, and the issue is still occurring.
Please see the attached error message that I am receiving. (new.png)
I have the attachments that were missing in my previous post attached. Sorry about that. I ran both of the queries that you gave me, and the issue is still occurring.
Please see the attached error message that I am receiving. (new.png)
Hi,
Seems something went wrong with the update of Formidable.
Can you try to restart the update process?
Go to the table Packages in your DB
Change the version of Formidable to one lower than the value is currently.
So, for instance, if your version is 2.0.18 change it to 2.0.17.
Than rerun the update and see if it works.
Best,
Corretje
Seems something went wrong with the update of Formidable.
Can you try to restart the update process?
Go to the table Packages in your DB
Change the version of Formidable to one lower than the value is currently.
So, for instance, if your version is 2.0.18 change it to 2.0.17.
Than rerun the update and see if it works.
Best,
Corretje
I am unable to get the forms to work at all at this point. Is there any way you can assist me here?
Hi,
Sure, I can help...
Send FTP-login details and C5 Admin login details to wim@dewebmakers.nl
Also access to the DB would be nice.
Best,
Corretje
Sure, I can help...
Send FTP-login details and C5 Admin login details to wim@dewebmakers.nl
Also access to the DB would be nice.
Best,
Corretje
I can't see the screendumps, but I think I understand.
You can try the following:
1.
Create backups for the following tables:
FormidableAnswerSets
FormidableAnsers
2.
Execute the following MySQL queries:
ALTER TABLE FormidableAnswerSets ADD UNIQUE (answerSetID);
ALTER TABLE FormidableAnswerSets ADD INDEX (formID);
ALTER TABLE FormidableAnswerSets ADD INDEX (userID);
ALTER TABLE FormidableAnswerSets ADD INDEX (collectionID);
ALTER TABLE FormidableAnswers ADD INDEX (answerSetID);
ALTER TABLE FormidableAnswers ADD INDEX (formID);
ALTER TABLE FormidableAnswers ADD INDEX (elementID);
Then see if you can access the submissions again...
If that doesn't work the try step 3.
3.
Execute the following MySQL queries:
TRUNCATE FormidableAnswerSets
TRUNCATE FormidableAnswers
This will empty the tables. See if you can update and access the submissions.
Best,
Corretje