Installation problem

Permalink Browser Info Environment
I am getting an error when installing the Formidable block. I can download the package but when I click to install the add-on I get the concrete5 error page with the following...

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'columnAdded'

Do you know why this would be causing an issue and how I can get the block type installed?

Thanks for your help

Type: Ticket
Status: Archived
View Replies:
DeWebmakers replied on at Permalink Reply

Sorry for the late reply. Been on holiday for the last 3 weeks :)

Seems it could be an issue with doctrine.
I've read some articles that it might not be to set a default timestamp. But it depends on the doctine version. I need to test this...


phowie74 replied on at Permalink Reply
No problem Corretje - hope you enjoyed your break.

I think I have resolved the issue myself after tinkering with the add table script. It seems it was running an older version of Mariadb on the Amazon Linux 2 server which was why the error was occurring. I have upgraded Mariadb on the server and was able to install the package with no problem.

I will be setting up and testing my first forms today so I will let you know if there are still any issues.

Thanks for getting back to me.

phowie74 replied on at Permalink Reply
I have managed to install the form no problem but I do have a query about the Address form setup.

I would like to have the Address show only the Country Field and then either the State / County / Province as applicable to the Country selected.

I have added
as outlined in your Custom Format helper but it seems that these labels {state} {county} and {province} also get output to the page including the curly braces. I have tried various combinations of the available settings but cannot find if there is any way to hide these?

Many thanks
DeWebmakers replied on at Permalink Reply
Hi Paul,

Found the issue.

The county and province variables where not replaced for the actual field.
So that will be fixed in the next update.

Then the use of the fields.
It's usually that you choose one of the fields, so use state OR province OR county.
The use of all three of them will generate 3 seperate fields.
You will see that after the update.

For now, I'll update the addon asap.



concrete5 Environment Information

# Concrete Version
Core Version - 9.2.0
Version Installed - 9.2.0
Database Version - 20230308163514

# Hostname

# Environment

# Database Information
Version: 5.5.68-MariaDB
SQL Mode:

# Concrete Packages
Formidable (, Multiple Page Selector Attribute (1.0.1)

# Concrete Overrides
blocks/page_title/templates/main_heading/view.php, blocks/page_title/templates/main_heading, blocks/page_title/templates/blog_post/view.php, blocks/page_title/templates/blog_post, blocks/page_title/templates, blocks/page_title, blocks/content/templates/description/view.php, blocks/content/templates/description, blocks/content/templates/francaise/view.php, blocks/content/templates/francaise, blocks/content/templates, blocks/content, blocks/page_attribute_display/templates/intro_image/view.php, blocks/page_attribute_display/templates/intro_image, blocks/page_attribute_display/templates/download/view.php, blocks/page_attribute_display/templates/download, blocks/page_attribute_display/templates, blocks/page_attribute_display, blocks/page_list/templates/secondary_nav/view.php, blocks/page_list/templates/secondary_nav, blocks/page_list/templates/section/view.php, blocks/page_list/templates/section, blocks/page_list/templates/blog/view.php, blocks/page_list/templates/blog, blocks/page_list/templates/src/view.php, blocks/page_list/templates/src, blocks/page_list/templates/product_resources/view.php, blocks/page_list/templates/product_resources, blocks/page_list/templates/slats/view.php, blocks/page_list/templates/slats, blocks/page_list/templates/events/view.php, blocks/page_list/templates/events, blocks/page_list/templates, blocks/page_list, blocks/autonav/templates/main_nav/view.php, blocks/autonav/templates/main_nav, blocks/autonav/templates/sub_nav/view.php, blocks/autonav/templates/sub_nav, blocks/autonav/templates, blocks/autonav, blocks/image/templates/float_right/view.php, blocks/image/templates/float_right, blocks/image/templates/float_left/view.php, blocks/image/templates/float_left, blocks/image/templates/centered/view.php, blocks/image/templates/centered, blocks/image/templates, blocks/image/view.php, blocks/image, blocks/html/templates/spec_table/view.php, blocks/html/templates/spec_table, blocks/html/templates/download_table/view.php, blocks/html/templates/download_table, blocks/html/templates, blocks/html, blocks/document_library/templates/downloads/view.php, blocks/document_library/templates/downloads, blocks/document_library/templates, blocks/document_library/controller.php, blocks/document_library, blocks/date_navigation/templates/blog/view.php, blocks/date_navigation/templates/blog, blocks/date_navigation/templates, blocks/date_navigation, blocks/tags/templates/blog/view.php, blocks/tags/templates/blog, blocks/tags/templates, blocks/tags, blocks/search/templates/blog/view.php, blocks/search/templates/blog, blocks/search/templates/product/view.php, blocks/search/templates/product, blocks/search/templates, blocks/search, blocks/share_this_page/view.php, blocks/share_this_page, blocks/image_slider/templates/home/view.php, blocks/image_slider/templates/home, blocks/image_slider/templates, blocks/image_slider, blocks/topic_list/templates/page_topic/view.php, blocks/topic_list/templates/page_topic, blocks/topic_list/templates, blocks/topic_list, blocks/file/templates/download/view.php, blocks/file/templates/download, blocks/file/templates, blocks/file, blocks/form/templates/contact/view.php, blocks/form/templates/contact, blocks/form/templates, blocks/form, blocks/express_form/templates/contact/view.php, blocks/express_form/templates/contact, blocks/express_form/templates, blocks/express_form, elements/form/frontend.php, elements/form, themes/bluegreen/elements/footer.php, themes/bluegreen/elements/header.php, themes/bluegreen/elements, themes/bluegreen/js/scripts.min.js, themes/bluegreen/js/scripts.js, themes/bluegreen/js, themes/bluegreen/default.php, themes/bluegreen/page_theme.php, themes/bluegreen/scripts.js, themes/bluegreen/styles.css, themes/bluegreen/thumbnail.png, themes/bluegreen/view.php, themes/bluegreen/product.php, themes/bluegreen/, themes/bluegreen/styles-min.css, themes/bluegreen, src/Sonatest/Express/Form/Context/FrontendFormContect.php, src/Sonatest/Express/Form/Context/FrontendFormContext.php, src/Sonatest/Express/Form/Context, src/Sonatest/Express/Form, src/Sonatest/Express/Controller/FormController.php, src/Sonatest/Express/Controller, src/Sonatest/Express, src/Sonatest/Attribute/Context/FrontendFormContext.php, src/Sonatest/Attribute/Context, src/Sonatest/Attribute, src/Sonatest

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

# Server Software

# Server API

# PHP Version

# PHP Extensions
bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, random, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 30
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
max_multipart_body_parts - -1
memory_limit - 128M
post_max_size - 8M
upload_max_filesize - 5M
zend.exception_string_param_max_len - 15
mbstring.regex_retry_limit - 1000000
mbstring.regex_stack_limit - 100000
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
unserialize_max_depth - 4096

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.2 Safari/605.1.15

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.