Installation error

Permalink Browser Info Environment
An exception occurred while executing 'ALTER TABLE ExpressFormFieldSetTextControls ADD CONSTRAINT FK_DB5A209ABF396750 FOREIGN KEY (id) REFERENCES ExpressFormFieldSetControls (id) ON DELETE CASCADE': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`myDatabasename`.`#sql-c6f_449a06`, CONSTRAINT `FK_DB5A209ABF396750` FOREIGN KEY (`id`) REFERENCES `ExpressFormFieldSetControls` (`id`) ON DELETE CASCADE)


I received this error when installing the extension on my staging site,using the extend Concrete5 area.

Type: Pre-Sale
Status: In Progress
ohTrivera
View Replies:
ohTrivera replied on at Permalink Reply
ohTrivera
This issue was unrelated to the formify plugin. My database had orphan rows

concrete5 Environment Information

# concrete5 Version
Core Version - 8.1.0
Version Installed - 8.1.0
Database Version - 20170123000000

# concrete5 Packages
ExchangeCore reCAPTCHA (1.1.1), Formify (2.6.5), HonestWebsites Store location (1.2.6), Video Lightbox (1.8.7), Vivid Simple Accordion (1.0.1), Whale Responsive Tables (1.0.3)

# concrete5 Overrides
blocks/image_slider/templates/mg_home/view.php, blocks/image_slider/templates/mg_home/view.css, blocks/image_slider/templates/mg_home, blocks/image_slider/templates, blocks/image_slider, blocks/page_list/templates/thumbnail_grid/view.php, blocks/page_list/templates/thumbnail_grid/view.css, blocks/page_list/templates/thumbnail_grid, blocks/page_list/templates/mg_blog/view.php, blocks/page_list/templates/mg_blog/view.css, blocks/page_list/templates/mg_blog, blocks/page_list/templates, blocks/page_list, blocks/next_previous/templates/mg_next_prev/view.php, blocks/next_previous/templates/mg_next_prev, blocks/next_previous/templates, blocks/next_previous, blocks/autonav/templates/main_nav/view.php, blocks/autonav/templates/main_nav, blocks/autonav/templates, blocks/autonav, blocks/hw_store_location/view.php, blocks/hw_store_location, blocks/add_store/form.js, blocks/add_store/edit.php, blocks/add_store/db.xml, blocks/add_store/view.php, blocks/add_store/controller.php, blocks/add_store/add.php, blocks/add_store, controllers/single_page/dashboard/poporder/products/form.php, controllers/single_page/dashboard/poporder/products, controllers/single_page/dashboard/poporder/stores/edit.php, controllers/single_page/dashboard/poporder/stores/approvestore.php, controllers/single_page/dashboard/poporder/stores, controllers/single_page/dashboard/poporder/orders.php, controllers/single_page/dashboard/poporder/stores.php, controllers/single_page/dashboard/poporder/orders/edit.php, controllers/single_page/dashboard/poporder/orders/add.php, controllers/single_page/dashboard/poporder/orders/detail.php, controllers/single_page/dashboard/poporder/orders, controllers/single_page/dashboard/poporder/products.php, controllers/single_page/dashboard/poporder, controllers/single_page/dashboard, controllers/single_page/retailers/orderpop.php, controllers/single_page/retailers/orderpop/products/detail.php, controllers/single_page/retailers/orderpop/products, controllers/single_page/retailers/orderpop/purchase.php, controllers/single_page/retailers/orderpop/stores/manage.php, controllers/single_page/retailers/orderpop/stores, controllers/single_page/retailers/orderpop/orders.php, controllers/single_page/retailers/orderpop/stores.php, controllers/single_page/retailers/orderpop/orders/edit.php, controllers/single_page/retailers/orderpop/orders/detail.php, controllers/single_page/retailers/orderpop/orders, controllers/single_page/retailers/orderpop/products.php, controllers/single_page/retailers/orderpop/cart.php, controllers/single_page/retailers/orderpop, controllers/single_page/retailers, controllers/single_page/distributor/orderpop.php, controllers/single_page/distributor, controllers/single_page/login.php, controllers/single_page, authentication/concrete/email_validated.php, authentication/concrete/form.php, authentication/concrete, jobs/clear_empty_workflow_progress.php, jobs/geotag_stores_before_import.php, jobs/send_to_fulfillment_api.php, languages/es_ES/LC_MESSAGES/messages.mo, languages/es_ES/LC_MESSAGES, languages/es_ES, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/es_PE/LC_MESSAGES/messages.mo, languages/es_PE/LC_MESSAGES, languages/es_PE, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, 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/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, single_pages/dashboard/poporder/products/view.php, single_pages/dashboard/poporder/products/form.php, single_pages/dashboard/poporder/products, single_pages/dashboard/poporder/stores/edit.php, single_pages/dashboard/poporder/stores/view.php, single_pages/dashboard/poporder/stores/view.css, single_pages/dashboard/poporder/stores/approvestore.php, single_pages/dashboard/poporder/stores, single_pages/dashboard/poporder/orders/edit.php, single_pages/dashboard/poporder/orders/view.php, single_pages/dashboard/poporder/orders/add.php, single_pages/dashboard/poporder/orders/detail.php, single_pages/dashboard/poporder/orders, single_pages/dashboard/poporder, single_pages/dashboard/hw_store_locations/addstore.php, single_pages/dashboard/hw_store_locations/approvestore.php, single_pages/dashboard/hw_store_locations, single_pages/dashboard/reports/linkchecker.php, single_pages/dashboard/reports, single_pages/dashboard/hw_store_locations.php, single_pages/dashboard, single_pages/retailers/orderpop/products/view.php, single_pages/retailers/orderpop/products/detail.php, single_pages/retailers/orderpop/products, single_pages/retailers/orderpop/stores/view.php, single_pages/retailers/orderpop/stores/manage.php, single_pages/retailers/orderpop/stores, single_pages/retailers/orderpop/view.php, single_pages/retailers/orderpop/purchase/view.php, single_pages/retailers/orderpop/purchase, single_pages/retailers/orderpop/orders/view.php, single_pages/retailers/orderpop/orders/detail.php, single_pages/retailers/orderpop/orders, single_pages/retailers/orderpop/cart/view.php, single_pages/retailers/orderpop/cart, single_pages/retailers/orderpop, single_pages/retailers, single_pages/distributor/orderpop.php, single_pages/distributor, single_pages/login.php, single_pages/register.php, themes/milorganite/home_pro.php, themes/milorganite/css/bootstrap-modified.css, themes/milorganite/css/overrides.css, themes/milorganite/css/default.css, themes/milorganite/css/flaunt.css, themes/milorganite/css, themes/milorganite/contact.php, themes/milorganite/landing_pro.php, themes/milorganite/thumbnail.png, themes/milorganite/js/flaunt.js, themes/milorganite/js/bootstrap.min.js, themes/milorganite/js/jquery.matchHeight-min.js, themes/milorganite/js, themes/milorganite/main_content_retail.php, themes/milorganite/search_results.php, themes/milorganite/main_content_pro.php, themes/milorganite/content_text_pro.php, themes/milorganite/page_theme.php, themes/milorganite/home_retailer.php, themes/milorganite/page_not_found.php, themes/milorganite/left_sidebar.php, themes/milorganite/landing_retail.php, themes/milorganite/view.php, themes/milorganite/blank.php, themes/milorganite/videos.php, themes/milorganite/blog.php, themes/milorganite/page_forbidden.php, themes/milorganite/elements/header.php, themes/milorganite/elements/orderpop_header.php, themes/milorganite/elements/footer_bottom.php, themes/milorganite/elements/footer.php, themes/milorganite/elements/header_retailer.php, themes/milorganite/elements/header_top.php, themes/milorganite/elements/header_pro.php, themes/milorganite/elements, themes/milorganite/landing.php, themes/milorganite/home.php, themes/milorganite/content_text_retail.php, themes/milorganite/description.txt, themes/milorganite/default.php, themes/milorganite/images/MilorganiteLogo.png, themes/milorganite/images/hamburger.svg, themes/milorganite/images/arrow.svg, themes/milorganite/images/cork-bkg.png, themes/milorganite/images/missing-staff.jpg, themes/milorganite/images/cork-lt.png, themes/milorganite/images, themes/milorganite/content_text.php, themes/milorganite/main_content.php, themes/milorganite/full.php, themes/milorganite, blocks/image_slider/templates/mg_home/view.php, blocks/image_slider/templates/mg_home/view.css, blocks/image_slider/templates/mg_home, blocks/image_slider/templates, blocks/image_slider, blocks/page_list/templates/thumbnail_grid/view.php, blocks/page_list/templates/thumbnail_grid/view.css, blocks/page_list/templates/thumbnail_grid, blocks/page_list/templates/mg_blog/view.php, blocks/page_list/templates/mg_blog/view.css, blocks/page_list/templates/mg_blog, blocks/page_list/templates, blocks/page_list, blocks/next_previous/templates/mg_next_prev/view.php, blocks/next_previous/templates/mg_next_prev, blocks/next_previous/templates, blocks/next_previous, blocks/autonav/templates/main_nav/view.php, blocks/autonav/templates/main_nav, blocks/autonav/templates, blocks/autonav, blocks/hw_store_location/view.php, blocks/hw_store_location, blocks/add_store/form.js, blocks/add_store/edit.php, blocks/add_store/db.xml, blocks/add_store/view.php, blocks/add_store/controller.php, blocks/add_store/add.php, blocks/add_store, controllers/single_page/dashboard/poporder/products/form.php, controllers/single_page/dashboard/poporder/products, controllers/single_page/dashboard/poporder/stores/edit.php, controllers/single_page/dashboard/poporder/stores/approvestore.php, controllers/single_page/dashboard/poporder/stores, controllers/single_page/dashboard/poporder/orders.php, controllers/single_page/dashboard/poporder/stores.php, controllers/single_page/dashboard/poporder/orders/edit.php, controllers/single_page/dashboard/poporder/orders/add.php, controllers/single_page/dashboard/poporder/orders/detail.php, controllers/single_page/dashboard/poporder/orders, controllers/single_page/dashboard/poporder/products.php, controllers/single_page/dashboard/poporder, controllers/single_page/dashboard, controllers/single_page/retailers/orderpop.php, controllers/single_page/retailers/orderpop/products/detail.php, controllers/single_page/retailers/orderpop/products, controllers/single_page/retailers/orderpop/purchase.php, controllers/single_page/retailers/orderpop/stores/manage.php, controllers/single_page/retailers/orderpop/stores, controllers/single_page/retailers/orderpop/orders.php, controllers/single_page/retailers/orderpop/stores.php, controllers/single_page/retailers/orderpop/orders/edit.php, controllers/single_page/retailers/orderpop/orders/detail.php, controllers/single_page/retailers/orderpop/orders, controllers/single_page/retailers/orderpop/products.php, controllers/single_page/retailers/orderpop/cart.php, controllers/single_page/retailers/orderpop, controllers/single_page/retailers, controllers/single_page/distributor/orderpop.php, controllers/single_page/distributor, controllers/single_page/login.php, controllers/single_page, authentication/concrete/email_validated.php, authentication/concrete/form.php, authentication/concrete, jobs/clear_empty_workflow_progress.php, jobs/geotag_stores_before_import.php, jobs/send_to_fulfillment_api.php, languages/es_ES/LC_MESSAGES/messages.mo, languages/es_ES/LC_MESSAGES, languages/es_ES, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/es_PE/LC_MESSAGES/messages.mo, languages/es_PE/LC_MESSAGES, languages/es_PE, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, 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/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, single_pages/dashboard/poporder/products/view.php, single_pages/dashboard/poporder/products/form.php, single_pages/dashboard/poporder/products, single_pages/dashboard/poporder/stores/edit.php, single_pages/dashboard/poporder/stores/view.php, single_pages/dashboard/poporder/stores/view.css, single_pages/dashboard/poporder/stores/approvestore.php, single_pages/dashboard/poporder/stores, single_pages/dashboard/poporder/orders/edit.php, single_pages/dashboard/poporder/orders/view.php, single_pages/dashboard/poporder/orders/add.php, single_pages/dashboard/poporder/orders/detail.php, single_pages/dashboard/poporder/orders, single_pages/dashboard/poporder, single_pages/dashboard/hw_store_locations/addstore.php, single_pages/dashboard/hw_store_locations/approvestore.php, single_pages/dashboard/hw_store_locations, single_pages/dashboard/reports/linkchecker.php, single_pages/dashboard/reports, single_pages/dashboard/hw_store_locations.php, single_pages/dashboard, single_pages/retailers/orderpop/products/view.php, single_pages/retailers/orderpop/products/detail.php, single_pages/retailers/orderpop/products, single_pages/retailers/orderpop/stores/view.php, single_pages/retailers/orderpop/stores/manage.php, single_pages/retailers/orderpop/stores, single_pages/retailers/orderpop/view.php, single_pages/retailers/orderpop/purchase/view.php, single_pages/retailers/orderpop/purchase, single_pages/retailers/orderpop/orders/view.php, single_pages/retailers/orderpop/orders/detail.php, single_pages/retailers/orderpop/orders, single_pages/retailers/orderpop/cart/view.php, single_pages/retailers/orderpop/cart, single_pages/retailers/orderpop, single_pages/retailers, single_pages/distributor/orderpop.php, single_pages/distributor, single_pages/login.php, single_pages/register.php, themes/milorganite/home_pro.php, themes/milorganite/css/bootstrap-modified.css, themes/milorganite/css/overrides.css, themes/milorganite/css/default.css, themes/milorganite/css/flaunt.css, themes/milorganite/css, themes/milorganite/contact.php, themes/milorganite/landing_pro.php, themes/milorganite/thumbnail.png, themes/milorganite/js/flaunt.js, themes/milorganite/js/bootstrap.min.js, themes/milorganite/js/jquery.matchHeight-min.js, themes/milorganite/js, themes/milorganite/main_content_retail.php, themes/milorganite/search_results.php, themes/milorganite/main_content_pro.php, themes/milorganite/content_text_pro.php, themes/milorganite/page_theme.php, themes/milorganite/home_retailer.php, themes/milorganite/page_not_found.php, themes/milorganite/left_sidebar.php, themes/milorganite/landing_retail.php, themes/milorganite/view.php, themes/milorganite/blank.php, themes/milorganite/videos.php, themes/milorganite/blog.php, themes/milorganite/page_forbidden.php, themes/milorganite/elements/header.php, themes/milorganite/elements/orderpop_header.php, themes/milorganite/elements/footer_bottom.php, themes/milorganite/elements/footer.php, themes/milorganite/elements/header_retailer.php, themes/milorganite/elements/header_top.php, themes/milorganite/elements/header_pro.php, themes/milorganite/elements, themes/milorganite/landing.php, themes/milorganite/home.php, themes/milorganite/content_text_retail.php, themes/milorganite/description.txt, themes/milorganite/default.php, themes/milorganite/images/MilorganiteLogo.png, themes/milorganite/images/hamburger.svg, themes/milorganite/images/arrow.svg, themes/milorganite/images/cork-bkg.png, themes/milorganite/images/missing-staff.jpg, themes/milorganite/images/cork-lt.png, themes/milorganite/images, themes/milorganite/content_text.php, themes/milorganite/main_content.php, themes/milorganite/full.php, themes/milorganite

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - On - If blocks on the particular page allow it.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
fpm-fcgi

# PHP Version
5.6.31

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, fileinfo, filter, ftp, gd, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 300
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 600
max_input_vars - 1000
memory_limit - 1024M
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
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 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 have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.