MySQL error with preview

Permalink Browser Info Environment
I have a form with preview enabled and when trying to edit the form and then preview it again, I get the following error:
mysqlt error: [1048: Column 'ProformsItemID' cannot be null] in EXECUTE("INSERT INTO ProformsItemAttributeValues (ProformsItemID,akID,avID) VALUES (NULL,107,3810)")

The URL of the error page is:

Type: Discussion
Status: In Progress
View Replies:
luovaamo replied on at Permalink Reply
Also when trying to edit the form again, it returns an empty form.
RadiantWeb replied on at Permalink Reply
Hi there, this is an auto-responder to let you know that your support request has been forwarded to our entire team at RadiantWeb.

Support tickets are reviewed Mondays thru Fridays 9am to 9pm & Saturdays 9am to 12pm EST. A support team member will be following up with you as soon as possible.

RadiantWeb replied on at Permalink Reply
It sounds like you are trying to access the form irrespective of it's ID#. You have to make sure you pass the "entryID#" in the blocks settings. And then make sure any time you are wanting to access a specific form "entry" that you are adding ?entryID=# to the URL. It's not cached or sessioned. so you can't just go to the page and review without having that entryID# in the URL.

luovaamo replied on at Permalink Reply
Thanks, that seems to be the reason for the problem.

But at the moment when I enable the form ID in the block settings, it has some problem adding the hidden value to the form.

I can now preview the form and return to editing it. But when I return from the preview, the form ID seems to corrupt. It adds "> to the page and when viewing the pages source at shows this:
<input type="hidden" name="ProformsItemID" value="�[dy����H�9��2�HEmZ" y��="">

I tested the preview with two different forms, and both show the same problem after returning to edit from preview.
RadiantWeb replied on at Permalink Reply
please update to v5.7.8

The entryID# should now pass correctly to the editable form.


concrete5 Environment Information

# concrete5 Version

# concrete5 Packages
Attribute Displayer (1.0.1), Automatic Email Obfuscator (1.2.3), Calendar Nav (1.0.8), Disqus Comments (0.5.1), Editor Comment (1.0), Enhanced User List (1.6.0), Page List+ (, Pro Forms (7.5.6), ProForms Extend Example (0.0.1), Redirect (1.1).

# concrete5 Overrides
blocks/search, blocks/pro_event_list, blocks/pmw_enhanced_user_list, blocks/page_list, blocks/rss_displayer, blocks/calendar_nav, controllers/tapahtumat_json.php, elements/profile, languages/ru_RU, languages/he_IL, languages/sl_SI, languages/fi_FI, languages/cs_CZ, languages/ro_RO, languages/fr_FR, languages/it_IT, languages/zh_TW, languages/tr_TR, languages/es_ES, languages/fa_IR, languages/es_MX, languages/de_DE, languages/zh_CN, languages/es_PE, languages/ar, languages/sk_SK, languages/ja_JP, languages/da_DK, languages/nl_NL, languages/es_AR, languages/vi_VN, languages/nb_NO, languages/pt_PT, languages/sv_SE, languages/el_GR, single_pages/profile, single_pages/ideapankki.php, single_pages/tietoa, single_pages/tutkimusta-ja-kehitysta, single_pages/tapahtumat_json, single_pages/ajankohtaista, themes/luovaamo

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off

# Server Software
Apache/2.2.22 (Debian)

# Server API

# PHP Version

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

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 50
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 40M
sql.safe_mode - Off
upload_max_filesize - 16M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71 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.