Databses not portable

Permalink 0 0 Browser Info Environment
Version 8+ or concrete5.

Tested on MySQL 5.6
Import of exported DB file fails due to constraints:
"ALTER TABLE atNumber
ADD CONSTRAINT FK_41BA30B5A2A82A5D FOREIGN KEY (avID) REFERENCES AttributeValues (avID) ON DELETE CASCADE"

This is with a default export file from MySQL. Makes moving the site as it sites VERY VERY difficult.


Status: New
justinba replied on at Permalink Reply
As a fix (thanks Remo) will likely need to add the line below to your DB import file.

SET foreign_key_checks = 0

concrete5 Environment Information

# concrete5 Version
Core Version - 8.2.0
Version Installed - 8.2.0
Database Version - 20170711151953

# concrete5 Packages
HDMZ Build (1.1.8), HDMZ Site Search (0.0.1), Page Redirect (2.0), Page Selector Attribute (2.0)

# concrete5 Overrides
blocks/autonav/templates/responsive_header_navigation/view.css, blocks/autonav/templates/responsive_header_navigation/view.js, blocks/autonav/templates/responsive_header_navigation/view.php, blocks/autonav/templates/responsive_header_navigation, blocks/autonav/templates/utility_nav/view.css, blocks/autonav/templates/utility_nav/view.php, blocks/autonav/templates/utility_nav, blocks/autonav/templates, blocks/autonav, blocks/content/templates/homepage-splash/view.php, blocks/content/templates/homepage-splash, blocks/content/templates, blocks/content, blocks/core_area_layout/templates/homepage-splash/view.php, blocks/core_area_layout/templates/homepage-splash, blocks/core_area_layout/templates/metabolite-bg/view.php, blocks/core_area_layout/templates/metabolite-bg, blocks/core_area_layout/templates, blocks/core_area_layout, blocks/external_form/form/contact.php, blocks/external_form/form/controller/contact.php, blocks/external_form/form/controller/demo_account.php, blocks/external_form/form/controller/inquiry.php, blocks/external_form/form/controller/lipid_surveyor_demo.php, blocks/external_form/form/controller, blocks/external_form/form/demo_account.php, blocks/external_form/form/inquiry.php, blocks/external_form/form/lipid_surveyor_demo.php, blocks/external_form/form, blocks/external_form, blocks/hdmz_tab_content/templates/icons/view.php, blocks/hdmz_tab_content/templates/icons, blocks/hdmz_tab_content/templates/metabolite_tabs/view.php, blocks/hdmz_tab_content/templates/metabolite_tabs, blocks/hdmz_tab_content/templates/tabs_view/view.php, blocks/hdmz_tab_content/templates/tabs_view, blocks/hdmz_tab_content/templates, blocks/hdmz_tab_content/view.css, blocks/hdmz_tab_content/view.php, blocks/hdmz_tab_content, blocks/image/templates/magnify/view.css, blocks/image/templates/magnify/view.js, blocks/image/templates/magnify/view.php, blocks/image/templates/magnify, blocks/image/templates/splash-img-1/view.css, blocks/image/templates/splash-img-1/view.php, blocks/image/templates/splash-img-1, blocks/image/templates/splash-img-2/view.css, blocks/image/templates/splash-img-2/view.php, blocks/image/templates/splash-img-2, blocks/image/templates, blocks/image, blocks/index.html, blocks/page_list/templates/blog-list/view.css, blocks/page_list/templates/blog-list/view.php, blocks/page_list/templates/blog-list, blocks/page_list/templates/events-list/view.css, blocks/page_list/templates/events-list/view.php, blocks/page_list/templates/events-list, blocks/page_list/templates/homepage-list/view.css, blocks/page_list/templates/homepage-list/view.php, blocks/page_list/templates/homepage-list, blocks/page_list/templates/news-list/view.css, blocks/page_list/templates/news-list/view.php, blocks/page_list/templates/news-list, blocks/page_list/templates/page-jumper/view.css, blocks/page_list/templates/page-jumper/view.php, blocks/page_list/templates/page-jumper, blocks/page_list/templates/publications-list/view.php, blocks/page_list/templates/publications-list, blocks/page_list/templates/thumbnail_grid/view.css, blocks/page_list/templates/thumbnail_grid/view.php, blocks/page_list/templates/thumbnail_grid, blocks/page_list/templates, blocks/page_list/view.css, blocks/page_list/view.php, blocks/page_list, blocks/topic_list/view.css, blocks/topic_list, blocks/video/add.php, blocks/video/controller.php, blocks/video/db.xml, blocks/video/edit.php, blocks/video/form_setup_html.php, blocks/video/templates/modal_video/view.css, blocks/video/templates/modal_video/view.php, blocks/video/templates/modal_video, blocks/video/templates, blocks/video, blocks/youtube/controller.php, blocks/youtube/db.xml, blocks/youtube/form_setup_html.php, blocks/youtube/templates/modal_video/view.css, blocks/youtube/templates/modal_video/view.js, blocks/youtube/templates/modal_video/view.php, blocks/youtube/templates/modal_video, blocks/youtube/templates, blocks/youtube, controllers/index.html, elements/header_required.php, elements/index.html, elements/page_controls_footer.php, elements/page_controls_header.php, attributes/index.html, authentication/concrete/form.php, authentication/concrete, authentication/index.html, jobs/index.html, css/app.css, css/build/mixin.less, css/build, js/bootstrap.min.js, js/eventsHandler.js, js/main.js, js/mobile-nav/classie.js, js/mobile-nav/mobile-menu.js, js/mobile-nav/modernizr-min.js, js/mobile-nav/modernizr.js, js/mobile-nav, mail/contact_form.php, mail/demo_account_form.php, mail/index.html, mail/inquiry.php, mail/lipid_surveyor_demo.php, single_pages/index.html, single_pages/login.php, themes/index.html, themes/metabolon2017/blank.php, themes/metabolon2017/blog_entry.php, themes/metabolon2017/css/bootstrap-modified.css, themes/metabolon2017/css/build/add-ons/calendar.less, themes/metabolon2017/css/build/add-ons, themes/metabolon2017/css/build/blocks/date-navigation.less, themes/metabolon2017/css/build/blocks/faq.less, themes/metabolon2017/css/build/blocks/feature-template-hover-description.less, themes/metabolon2017/css/build/blocks/feature.less, themes/metabolon2017/css/build/blocks/image-slider.less, themes/metabolon2017/css/build/blocks/image.less, themes/metabolon2017/css/build/blocks/next-previous.less, themes/metabolon2017/css/build/blocks/page-attribute-display.less, themes/metabolon2017/css/build/blocks/page-list-option-buttons.less, themes/metabolon2017/css/build/blocks/page-list-template-thumbnail-grid.less, themes/metabolon2017/css/build/blocks/page-list.less, themes/metabolon2017/css/build/blocks/page-title-option-byline.less, themes/metabolon2017/css/build/blocks/page-title.less, themes/metabolon2017/css/build/blocks/tags.less, themes/metabolon2017/css/build/blocks/testimonial.less, themes/metabolon2017/css/build/blocks/topic-list.less, themes/metabolon2017/css/build/blocks, themes/metabolon2017/css/build/body.less, themes/metabolon2017/css/build/bootstrap-3.2.0/alerts.less, themes/metabolon2017/css/build/bootstrap-3.2.0/badges.less, themes/metabolon2017/css/build/bootstrap-3.2.0/bootstrap.less, themes/metabolon2017/css/build/bootstrap-3.2.0/breadcrumbs.less, themes/metabolon2017/css/build/bootstrap-3.2.0/button-groups.less, themes/metabolon2017/css/build/bootstrap-3.2.0/buttons.less, themes/metabolon2017/css/build/bootstrap-3.2.0/carousel.less, themes/metabolon2017/css/build/bootstrap-3.2.0/close.less, themes/metabolon2017/css/build/bootstrap-3.2.0/code.less, themes/metabolon2017/css/build/bootstrap-3.2.0/component-animations.less, themes/metabolon2017/css/build/bootstrap-3.2.0/dropdowns.less, themes/metabolon2017/css/build/bootstrap-3.2.0/forms.less, themes/metabolon2017/css/build/bootstrap-3.2.0/glyphicons.less, themes/metabolon2017/css/build/bootstrap-3.2.0/grid.less, themes/metabolon2017/css/build/bootstrap-3.2.0/input-groups.less, themes/metabolon2017/css/build/bootstrap-3.2.0/jumbotron.less, themes/metabolon2017/css/build/bootstrap-3.2.0/labels.less, themes/metabolon2017/css/build/bootstrap-3.2.0/list-group.less, themes/metabolon2017/css/build/bootstrap-3.2.0/media.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/alerts.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/background-variant.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/border-radius.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/buttons.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/center-block.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/clearfix.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/dropdowns.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/forms.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/gradients.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/grid-framework.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/grid.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/hide-text.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/image.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/labels.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/list-group.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/modals.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/nav-divider.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/nav-vertical-align.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/opacity.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/pagination.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/panels.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/popovers.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/progress-bar.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/reset-filter.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/resize.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/responsive-visibility.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/size.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/tab-focus.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/table-row.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/text-emphasis.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/text-overflow.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/tooltip.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins/vendor-prefixes.less, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins, themes/metabolon2017/css/build/bootstrap-3.2.0/mixins.less, themes/metabolon2017/css/build/bootstrap-3.2.0/modals.less, themes/metabolon2017/css/build/bootstrap-3.2.0/navbar.less, themes/metabolon2017/css/build/bootstrap-3.2.0/navs.less, themes/metabolon2017/css/build/bootstrap-3.2.0/normalize.less, themes/metabolon2017/css/build/bootstrap-3.2.0/pager.less, themes/metabolon2017/css/build/bootstrap-3.2.0/pagination.less, themes/metabolon2017/css/build/bootstrap-3.2.0/panels.less, themes/metabolon2017/css/build/bootstrap-3.2.0/popovers.less, themes/metabolon2017/css/build/bootstrap-3.2.0/print.less, themes/metabolon2017/css/build/bootstrap-3.2.0/progress-bars.less, themes/metabolon2017/css/build/bootstrap-3.2.0/responsive-embed.less, themes/metabolon2017/css/build/bootstrap-3.2.0/responsive-utilities.less, themes/metabolon2017/css/build/bootstrap-3.2.0/scaffolding.less, themes/metabolon2017/css/build/bootstrap-3.2.0/tables.less, themes/metabolon2017/css/build/bootstrap-3.2.0/theme.less, themes/metabolon2017/css/build/bootstrap-3.2.0/thumbnails.less, themes/metabolon2017/css/build/bootstrap-3.2.0/tooltip.less, themes/metabolon2017/css/build/bootstrap-3.2.0/type.less, themes/metabolon2017/css/build/bootstrap-3.2.0/utilities.less, themes/metabolon2017/css/build/bootstrap-3.2.0/variables.less, themes/metabolon2017/css/build/bootstrap-3.2.0/wells.less, themes/metabolon2017/css/build/bootstrap-3.2.0, themes/metabolon2017/css/build/breadcrumb.less, themes/metabolon2017/css/build/buttons.less, themes/metabolon2017/css/build/captcha.less, themes/metabolon2017/css/build/content.less, themes/metabolon2017/css/build/custom-design-classes/area-content-accent.less, themes/metabolon2017/css/build/custom-design-classes/block-sidebar-padded.less, themes/metabolon2017/css/build/custom-design-classes/block-sidebar-wrapped.less, themes/metabolon2017/css/build/custom-design-classes/blog-entry-list.less, themes/metabolon2017/css/build/custom-design-classes/recent-blog-entry.less, themes/metabolon2017/css/build/custom-design-classes/testimonial-bio.less, themes/metabolon2017/css/build/custom-design-classes, themes/metabolon2017/css/build/edit-mode.less, themes/metabolon2017/css/build/errors.less, themes/metabolon2017/css/build/fonts/blue-sky.less, themes/metabolon2017/css/build/fonts/defaults.less, themes/metabolon2017/css/build/fonts/hdmz.less, themes/metabolon2017/css/build/fonts/night-road.less, themes/metabolon2017/css/build/fonts/royal.less, themes/metabolon2017/css/build/fonts, themes/metabolon2017/css/build/footer.less, themes/metabolon2017/css/build/header.less, themes/metabolon2017/css/build/miscellaneous-styles.less, themes/metabolon2017/css/build/mixins.less, themes/metabolon2017/css/build/mobile/navigation.less, themes/metabolon2017/css/build/mobile, themes/metabolon2017/css/build/pagination.less, themes/metabolon2017/css/build/reset.less, themes/metabolon2017/css/build/search.less, themes/metabolon2017/css/build, themes/metabolon2017/css/fonts/metabolon.eot, themes/metabolon2017/css/fonts/metabolon.svg, themes/metabolon2017/css/fonts/metabolon.ttf, themes/metabolon2017/css/fonts/metabolon.woff, themes/metabolon2017/css/fonts, themes/metabolon2017/css/icons.less, themes/metabolon2017/css/import.less, themes/metabolon2017/css/main.less, themes/metabolon2017/css/mobile-menu.less, themes/metabolon2017/css/navigation.less, themes/metabolon2017/css/presets/blue-sky.less, themes/metabolon2017/css/presets/defaults.less, themes/metabolon2017/css/presets/hdmz.less, themes/metabolon2017/css/presets/night-road.less, themes/metabolon2017/css/presets/royal.less, themes/metabolon2017/css/presets, themes/metabolon2017/css/responsive.less, themes/metabolon2017/css/styles.xml, themes/metabolon2017/css, themes/metabolon2017/default.php, themes/metabolon2017/elements/footer.php, themes/metabolon2017/elements/footer_bottom.php, themes/metabolon2017/elements/header.php, themes/metabolon2017/elements/header_top.php, themes/metabolon2017/elements/page_template_header.php, themes/metabolon2017/elements, themes/metabolon2017/event.php, themes/metabolon2017/full.php, themes/metabolon2017/home.php, themes/metabolon2017/images/background-slider-blue-sky.png, themes/metabolon2017/images/background-slider-default.png, themes/metabolon2017/images/background-slider-night-road.png, themes/metabolon2017/images/background-slider-royal.png, themes/metabolon2017/images/background.png, themes/metabolon2017/images/tree-bottom.png, themes/metabolon2017/images, themes/metabolon2017/js/theme.js, themes/metabolon2017/js, themes/metabolon2017/left_sidebar.php, themes/metabolon2017/news.php, themes/metabolon2017/page_forbidden.php, themes/metabolon2017/page_not_found.php, themes/metabolon2017/page_theme.php, themes/metabolon2017/partials/page_sections.php, themes/metabolon2017/partials, themes/metabolon2017/publication.php, themes/metabolon2017/right_sidebar.php, themes/metabolon2017/thumbnail.png, themes/metabolon2017/view.php, themes/metabolon2017, tools/index.html, page_templates/index.html, views/index.html, src/Mail/MailServiceProvider.php, src/Mail/Service.php, src/Mail

# 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.16 (Ubuntu)

# Server API
apache2handler

# PHP Version
5.6.14-1+deb.sury.org~trusty+1

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

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 512M
post_max_size - 256M
sql.safe_mode - Off
upload_max_filesize - 256M
memcache.max_failover_attempts - 20
memcached.sess_lock_max_wait - 0
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
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 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36