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

Type: Pre-Sale
Status: In Progress
View Replies:
prema520 replied on at Permalink Reply
Here is the SQL that's failing

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
BlueFractals replied on at Permalink Reply
BlueFractals
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.
prema520 replied on at Permalink Reply
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
BlueFractals replied on at Permalink Reply
BlueFractals
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.
prema520 replied on at Permalink Reply
Unfortunately no!
We have had to move on to a hard coded option.
Thanks very much for your help
Kind regards
Mike

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.5.9
Version Installed - 5.7.5.9
Database Version - 20160615000000

# concrete5 Packages
Brimstone Theme (2.1.5), Form Plus (2.3.2), Neat (0.9.2), Whale OWL Carousel (2.5.7.1).

# concrete5 Overrides
blocks/form_plus/templates, blocks/form_plus/auto.js, blocks/form_plus/view.bak, blocks/form_plus/view.css, blocks/form_plus/view.php, blocks/form_plus, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, blocks/form_plus/templates, blocks/form_plus/auto.js, blocks/form_plus/view.bak, blocks/form_plus/view.css, blocks/form_plus/view.php, blocks/form_plus, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.7 (Ubuntu)

# Server API
apache2handler

# PHP Version
5.5.9-1ubuntu4.19

# PHP Extensions
apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, json, libxml, mbstring, mhash, mysql, mysqli, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_sqlite, Phar, posix, readline, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib.

# PHP Settings
max_execution_time - 500
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - -1
max_input_vars - 1000
memory_limit - 2048M
post_max_size - 50M
sql.safe_mode - Off
upload_max_filesize - 50M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440
soap.wsdl_cache_limit - 5
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (X11; CrOS x86_64 8872.54.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.54 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.