All forms disappearing when one form is deleted
Permalink Browser Info Environment
HI Dev!
Thanks very much for form plus -- cool to use for our clients
We ran into an issue this morning.
Steps to reproduce:
1. Edit form
2. Change ListID
3. Refresh the merges
4. Make the signup mandatory
What happened
SQL data error. We don't have the SQL
5. Delete the block (to create a new block)
6. All FormPlus instances are deleted
We suspect that it might be a clipboard issue?
Any comments welcome.
We're going to try rebuilding the forms
The package is updated to latest
Thanks very much for form plus -- cool to use for our clients
We ran into an issue this morning.
Steps to reproduce:
1. Edit form
2. Change ListID
3. Refresh the merges
4. Make the signup mandatory
What happened
SQL data error. We don't have the SQL
5. Delete the block (to create a new block)
6. All FormPlus instances are deleted
We suspect that it might be a clipboard issue?
Any comments welcome.
We're going to try rebuilding the forms
The package is updated to latest
| Type: | Pre-Sale |
|---|---|
| Status: | In Progress |
Hi
Thanks for your message. Not sure if I've totally understood your issue. I followed your steps in Concrete5.7.5.9 but couldn't reproduce the issue.
When making the signup mandatory in your step 4, were you referring to the "Always opt-in" option in the Mailchimp tab? Anyway, after step 4, I didn't get any SQL error.
Did you copy an existing block into clipboard and try to create new instances from it? Sometimes copies made from clipboard can cause some issues. I've also noticed issues with C5's original Form block. However I didn't see all Form Plus instances deleted as you have indicated. If you want to retrieve old instances, you may do so from the page versions.
If you need multiple copies of Form Plus, I'd advise creating each instance from scratch.
You may also use a stack if you want your form results to remain available in the results page even after you've deleted a stack instance from a page.
Thanks for your message. Not sure if I've totally understood your issue. I followed your steps in Concrete5.7.5.9 but couldn't reproduce the issue.
When making the signup mandatory in your step 4, were you referring to the "Always opt-in" option in the Mailchimp tab? Anyway, after step 4, I didn't get any SQL error.
Did you copy an existing block into clipboard and try to create new instances from it? Sometimes copies made from clipboard can cause some issues. I've also noticed issues with C5's original Form block. However I didn't see all Form Plus instances deleted as you have indicated. If you want to retrieve old instances, you may do so from the page versions.
If you need multiple copies of Form Plus, I'd advise creating each instance from scratch.
You may also use a stack if you want your form results to remain available in the results page even after you've deleted a stack instance from a page.
Hi BlueFractals
We done some extensive testing - the outcome is:
- Rolled C5 Data back to original install
- Completely reinstalled the component
- Add a new form and configure
- We get a variant of the SQL dump already pasted
- Restore a C5 SQL version with the form already installed
- It works
- Change the list ID
- SQL dump
Hope this is useful in some way
Kind regards
Mike
We done some extensive testing - the outcome is:
- Rolled C5 Data back to original install
- Completely reinstalled the component
- Add a new form and configure
- We get a variant of the SQL dump already pasted
- Restore a C5 SQL version with the form already installed
- It works
- Change the list ID
- SQL dump
Hope this is useful in some way
Kind regards
Mike
So it's working for you now, is it?
I still haven't understood whether it was the FormPlus issue or caused by something else.
I still haven't understood whether it was the FormPlus issue or caused by something else.
Unfortunately no!
We have had to move on to a hard coded option.
Thanks very much for your help
Kind regards
Mike
We have had to move on to a hard coded option.
Thanks very much for your help
Kind regards
Mike
SELECT a.answer, a.answerLong
FROM btFormQuestions AS q
INNER JOIN btFormAnswerSet AS aset
ON q.questionSetId = aset.questionSetId
INNER JOIN btFormAnswers AS a
ON aset.asID = a.asID
WHERE q.bID = 528
AND q.msqID =
AND a.msqID =
AND aset.asID = (SELECT MAX(asID) FROM btFormAnswerSet