Formidable

Advanced Search

Import/converter from Formidable Full to Formidable (v9)

Permalink Browser Info Environment
I'm getting multiple errors when trying to import the old data in to the new version. Running Concrete CMS 9.2 on PHP 8.1.

First
An exception occurred while executing 'INSERT INTO FormidableResult (resultIP, resultDevice, resultBrowser, resultResolution, resultOperatingSystem, resultLocale, resultUser, resultPage, resultBlock, resultDateAdded, resultDateModified, formID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["(disabled by GDPR)", null, "(disabled by GDPR)", "(disabled by GDPR)", "(disabled by GDPR)", "nl_NL", 0, 1, 0, "2022-08-05 20:02:05", "2022-08-05 20:02:05", 1]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'resultResolution' at row 1
Possible fix: change column width to 150 instead of 10

Second
method_exists(): Argument #1 ($object_or_class) must be of type object|string, null given
…/public/concrete/src/Package/ItemCategory/AbstractCategory.php21

I hope you can help.
Type: Ticket
Status: Archived
NUL76
View Replies:
DeWebmakers replied on at Permalink Reply
DeWebmakers
Hi!

Fixed in the next update!
It should be available for you now.

Best,

Corretje
NUL76 replied on at Permalink Reply
NUL76
An exception occurred while executing 'INSERT INTO FormidableResult (resultIP, resultDevice, resultBrowser, resultResolution, resultOperatingSystem, resultLocale, resultUser, resultPage, resultBlock, resultDateAdded, resultDateModified, formID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["(disabled by GDPR)", null, "(disabled by GDPR)", "(disabled by GDPR)", "(disabled by GDPR)", "nl_NL", 0, null, 0, "2022-06-12 11:23:04", "2022-06-12 11:23:04", 1]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'resultPage' cannot be null
NUL76 replied on at Permalink Reply
NUL76
Seems to breaking on this:

Old
if (!is_object($resultPage)) {
            $resultPage = (int)$resultPage;
            if ($resultPage != 0) {
                $resultPage = Page::getByID($resultPage);
            }
        }


Updated
if (!is_object($resultPage)) {
            $resultPage = Page::getByID(Page::getHomePageID());
            $resultPageID = (int)$resultPage;
            if ($resultPageID != 0) {
                $resultPage = Page::getByID($resultPageID);
            }
        }
DeWebmakers replied on at Permalink Reply
DeWebmakers
Great find and feedback! Thank you.
I'm depending on the page's still being there, but that isn't alwasy true of course.
I'll update the addon.

Thanks again!
NUL76 replied on at Permalink Reply
NUL76
When will this be updated?
DeWebmakers replied on at Permalink Reply
DeWebmakers
I'll update later this week!

concrete5 Environment Information

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

# Hostname
EnoRm

# Environment
production

# Database Information
Version: 5.7.23
SQL Mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# Concrete Packages
Block Designer (3.3.0), Block Designer Pro (3.0.1), Enorm Blackbox (1.0.8), Formidable (1.1.4.2), Formidable (Full Version) (2.1.5), GDPR (1.8.3), Open Graph Tags Lite (2.1.5), Page List+ (2.0.1.3)

# Concrete Overrides
blocks/featured_one/add.php, blocks/featured_one/icon.png, blocks/featured_one/controller.php, blocks/featured_one/config.json, blocks/featured_one/composer.php, blocks/featured_one/db.xml, blocks/featured_one/view.php, blocks/featured_one/edit.php, blocks/featured_one/form.php, blocks/featured_one, blocks/formidable/view.php, blocks/formidable/view.css, blocks/formidable, blocks/tabs/add.php, blocks/tabs/icon.png, blocks/tabs/controller.php, blocks/tabs/css_form/repeatable-ft.form.css, blocks/tabs/css_form, blocks/tabs/config.json, blocks/tabs/composer.php, blocks/tabs/db.xml, blocks/tabs/js_form/handlebars-helpers.js, blocks/tabs/js_form/handlebars-v4.0.4.js, blocks/tabs/js_form, blocks/tabs/auto.js, blocks/tabs/view.php, blocks/tabs/edit.php, blocks/tabs/form.php, blocks/tabs, blocks/clients/add.php, blocks/clients/icon.png, blocks/clients/controller.php, blocks/clients/css_form/repeatable-ft.form.css, blocks/clients/css_form, blocks/clients/config.json, blocks/clients/composer.php, blocks/clients/db.xml, blocks/clients/js_form/handlebars-helpers.js, blocks/clients/js_form/handlebars-v4.0.4.js, blocks/clients/js_form, blocks/clients/auto.js, blocks/clients/view.php, blocks/clients/edit.php, blocks/clients/form.php, blocks/clients, blocks/hero_two/add.php, blocks/hero_two/icon.png, blocks/hero_two/controller.php, blocks/hero_two/config.json, blocks/hero_two/composer.php, blocks/hero_two/db.xml, blocks/hero_two/view.php, blocks/hero_two/edit.php, blocks/hero_two/form.php, blocks/hero_two, blocks/faq_block/add.php, blocks/faq_block/icon.png, blocks/faq_block/controller.php, blocks/faq_block/css_form/repeatable-ft.form.css, blocks/faq_block/css_form, blocks/faq_block/config.json, blocks/faq_block/composer.php, blocks/faq_block/db.xml, blocks/faq_block/js_form/handlebars-helpers.js, blocks/faq_block/js_form/handlebars-v4.0.4.js, blocks/faq_block/js_form, blocks/faq_block/auto.js, blocks/faq_block/view.php, blocks/faq_block/edit.php, blocks/faq_block/form.php, blocks/faq_block, blocks/testimonials_three/add.php, blocks/testimonials_three/icon.png, blocks/testimonials_three/controller.php, blocks/testimonials_three/config.json, blocks/testimonials_three/composer.php, blocks/testimonials_three/db.xml, blocks/testimonials_three/view.php, blocks/testimonials_three/edit.php, blocks/testimonials_three/form.php, blocks/testimonials_three, blocks/contact/add.php, blocks/contact/icon.png, blocks/contact/controller.php, blocks/contact/config.json, blocks/contact/composer.php, blocks/contact/db.xml, blocks/contact/auto.js, blocks/contact/view.php, blocks/contact/edit.php, blocks/contact/form.php, blocks/contact, blocks/block_form_two/add.php, blocks/block_form_two/icon.png, blocks/block_form_two/controller.php, blocks/block_form_two/config.json, blocks/block_form_two/composer.php, blocks/block_form_two/db.xml, blocks/block_form_two/view.php, blocks/block_form_two/edit.php, blocks/block_form_two/form.php, blocks/block_form_two, blocks/block_image/add.php, blocks/block_image/icon.png, blocks/block_image/controller.php, blocks/block_image/config.json, blocks/block_image/composer.php, blocks/block_image/db.xml, blocks/block_image/view.php, blocks/block_image/edit.php, blocks/block_image/form.php, blocks/block_image, blocks/numbers/add.php, blocks/numbers/icon.png, blocks/numbers/controller.php, blocks/numbers/css_form/repeatable-ft.form.css, blocks/numbers/css_form, blocks/numbers/config.json, blocks/numbers/composer.php, blocks/numbers/db.xml, blocks/numbers/js_form/handlebars-helpers.js, blocks/numbers/js_form/handlebars-v4.0.4.js, blocks/numbers/js_form, blocks/numbers/auto.js, blocks/numbers/view.php, blocks/numbers/edit.php, blocks/numbers/form.php, blocks/numbers, blocks/call_to_action_three/add.php, blocks/call_to_action_three/icon.png, blocks/call_to_action_three/controller.php, blocks/call_to_action_three/config.json, blocks/call_to_action_three/composer.php, blocks/call_to_action_three/db.xml, blocks/call_to_action_three/auto.js, blocks/call_to_action_three/view.php, blocks/call_to_action_three/edit.php, blocks/call_to_action_three/form.php, blocks/call_to_action_three, blocks/buttons/add.php, blocks/buttons/icon.png, blocks/buttons/controller.php, blocks/buttons/css_form/repeatable-ft.form.css, blocks/buttons/css_form, blocks/buttons/config.json, blocks/buttons/composer.php, blocks/buttons/db.xml, blocks/buttons/js_form/handlebars-helpers.js, blocks/buttons/js_form/handlebars-v4.0.4.js, blocks/buttons/js_form, blocks/buttons/auto.js, blocks/buttons/view.php, blocks/buttons/edit.php, blocks/buttons/form.php, blocks/buttons, blocks/featured_two/add.php, blocks/featured_two/icon.png, blocks/featured_two/controller.php, blocks/featured_two/config.json, blocks/featured_two/composer.php, blocks/featured_two/db.xml, blocks/featured_two/view.php, blocks/featured_two/edit.php, blocks/featured_two/form.php, blocks/featured_two, blocks/block_form_one/add.php, blocks/block_form_one/icon.png, blocks/block_form_one/controller.php, blocks/block_form_one/css_form/repeatable-ft.form.css, blocks/block_form_one/css_form, blocks/block_form_one/config.json, blocks/block_form_one/composer.php, blocks/block_form_one/db.xml, blocks/block_form_one/js_form/handlebars-helpers.js, blocks/block_form_one/js_form/handlebars-v4.0.4.js, blocks/block_form_one/js_form, blocks/block_form_one/auto.js, blocks/block_form_one/view.php, blocks/block_form_one/edit.php, blocks/block_form_one/form.php, blocks/block_form_one, blocks/hero_one/add.php, blocks/hero_one/icon.png, blocks/hero_one/controller.php, blocks/hero_one/css_form/repeatable-ft.form.css, blocks/hero_one/css_form, blocks/hero_one/config.json, blocks/hero_one/composer.php, blocks/hero_one/db.xml, blocks/hero_one/js_form/handlebars-helpers.js, blocks/hero_one/js_form/handlebars-v4.0.4.js, blocks/hero_one/js_form, blocks/hero_one/auto.js, blocks/hero_one/view.php, blocks/hero_one/edit.php, blocks/hero_one/form.php, blocks/hero_one, blocks/block_video/add.php, blocks/block_video/icon.png, blocks/block_video/controller.php, blocks/block_video/config.json, blocks/block_video/composer.php, blocks/block_video/db.xml, blocks/block_video/view.php, blocks/block_video/edit.php, blocks/block_video/form.php, blocks/block_video, blocks/columns_two/add.php, blocks/columns_two/icon.png, blocks/columns_two/controller.php, blocks/columns_two/css_form/repeatable-ft.form.css, blocks/columns_two/css_form, blocks/columns_two/config.json, blocks/columns_two/composer.php, blocks/columns_two/db.xml, blocks/columns_two/js_form/handlebars-helpers.js, blocks/columns_two/js_form/handlebars-v4.0.4.js, blocks/columns_two/js_form, blocks/columns_two/auto.js, blocks/columns_two/view.php, blocks/columns_two/edit.php, blocks/columns_two/form.php, blocks/columns_two, blocks/columns_one/add.php, blocks/columns_one/icon.png, blocks/columns_one/controller.php, blocks/columns_one/config.json, blocks/columns_one/composer.php, blocks/columns_one/db.xml, blocks/columns_one/auto.js, blocks/columns_one/view.php, blocks/columns_one/edit.php, blocks/columns_one/form.php, blocks/columns_one, blocks/testimonials_two/add.php, blocks/testimonials_two/icon.png, blocks/testimonials_two/controller.php, blocks/testimonials_two/css_form/repeatable-ft.form.css, blocks/testimonials_two/css_form, blocks/testimonials_two/config.json, blocks/testimonials_two/composer.php, blocks/testimonials_two/db.xml, blocks/testimonials_two/js_form/handlebars-helpers.js, blocks/testimonials_two/js_form/handlebars-v4.0.4.js, blocks/testimonials_two/js_form, blocks/testimonials_two/auto.js, blocks/testimonials_two/view.php, blocks/testimonials_two/edit.php, blocks/testimonials_two/form.php, blocks/testimonials_two, blocks/team/add.php, blocks/team/icon.png, blocks/team/controller.php, blocks/team/css_form/repeatable-ft.form.css, blocks/team/css_form, blocks/team/config.json, blocks/team/composer.php, blocks/team/db.xml, blocks/team/js_form/handlebars-helpers.js, blocks/team/js_form/handlebars-v4.0.4.js, blocks/team/js_form, blocks/team/auto.js, blocks/team/view.php, blocks/team/edit.php, blocks/team/form.php, blocks/team, blocks/next_previous/controller.php, blocks/next_previous/view.php, blocks/next_previous, blocks/page_list_plus/templates/faq/view.php, blocks/page_list_plus/templates/faq, blocks/page_list_plus/templates/blog/view.php, blocks/page_list_plus/templates/blog, blocks/page_list_plus/templates, blocks/page_list_plus, blocks/testimonials_one/add.php, blocks/testimonials_one/icon.png, blocks/testimonials_one/controller.php, blocks/testimonials_one/css_form/repeatable-ft.form.css, blocks/testimonials_one/css_form, blocks/testimonials_one/config.json, blocks/testimonials_one/composer.php, blocks/testimonials_one/db.xml, blocks/testimonials_one/js_form/handlebars-helpers.js, blocks/testimonials_one/js_form/handlebars-v4.0.4.js, blocks/testimonials_one/js_form, blocks/testimonials_one/auto.js, blocks/testimonials_one/view.php, blocks/testimonials_one/edit.php, blocks/testimonials_one/form.php, blocks/testimonials_one, blocks/block_images/add.php, blocks/block_images/icon.png, blocks/block_images/controller.php, blocks/block_images/css_form/repeatable-ft.form.css, blocks/block_images/css_form, blocks/block_images/config.json, blocks/block_images/composer.php, blocks/block_images/db.xml, blocks/block_images/js_form/handlebars-helpers.js, blocks/block_images/js_form/handlebars-v4.0.4.js, blocks/block_images/js_form, blocks/block_images/auto.js, blocks/block_images/view.php, blocks/block_images/edit.php, blocks/block_images/form.php, blocks/block_images, blocks/hero_three/add.php, blocks/hero_three/icon.png, blocks/hero_three/controller.php, blocks/hero_three/css_form/repeatable-ft.form.css, blocks/hero_three/css_form, blocks/hero_three/config.json, blocks/hero_three/composer.php, blocks/hero_three/db.xml, blocks/hero_three/js_form/handlebars-helpers.js, blocks/hero_three/js_form/handlebars-v4.0.4.js, blocks/hero_three/js_form, blocks/hero_three/auto.js, blocks/hero_three/view.php, blocks/hero_three/edit.php, blocks/hero_three/form.php, blocks/hero_three, blocks/counters/add.php, blocks/counters/icon.png, blocks/counters/controller.php, blocks/counters/css_form/repeatable-ft.form.css, blocks/counters/css_form, blocks/counters/config.json, blocks/counters/composer.php, blocks/counters/db.xml, blocks/counters/js_form/handlebars-helpers.js, blocks/counters/js_form/handlebars-v4.0.4.js, blocks/counters/js_form, blocks/counters/auto.js, blocks/counters/view.php, blocks/counters/edit.php, blocks/counters/form.php, blocks/counters, blocks/thanks/add.php, blocks/thanks/icon.png, blocks/thanks/controller.php, blocks/thanks/config.json, blocks/thanks/composer.php, blocks/thanks/db.xml, blocks/thanks/auto.js, blocks/thanks/view.php, blocks/thanks/edit.php, blocks/thanks/form.php, blocks/thanks, blocks/call_to_action_two/add.php, blocks/call_to_action_two/icon.png, blocks/call_to_action_two/controller.php, blocks/call_to_action_two/config.json, blocks/call_to_action_two/composer.php, blocks/call_to_action_two/db.xml, blocks/call_to_action_two/auto.js, blocks/call_to_action_two/view.php, blocks/call_to_action_two/templates/no-container/view.php, blocks/call_to_action_two/templates/no-container, blocks/call_to_action_two/templates, blocks/call_to_action_two/edit.php, blocks/call_to_action_two/form.php, blocks/call_to_action_two, blocks/hero_four/add.php, blocks/hero_four/icon.png, blocks/hero_four/controller.php, blocks/hero_four/config.json, blocks/hero_four/composer.php, blocks/hero_four/db.xml, blocks/hero_four/auto.js, blocks/hero_four/view.php, blocks/hero_four/edit.php, blocks/hero_four/form.php, blocks/hero_four, blocks/block_form_three/add.php, blocks/block_form_three/icon.png, blocks/block_form_three/controller.php, blocks/block_form_three/config.json, blocks/block_form_three/composer.php, blocks/block_form_three/db.xml, blocks/block_form_three/auto.js, blocks/block_form_three/view.php, blocks/block_form_three/edit.php, blocks/block_form_three/form.php, blocks/block_form_three, blocks/call_to_action_one/add.php, blocks/call_to_action_one/icon.png, blocks/call_to_action_one/controller.php, blocks/call_to_action_one/config.json, blocks/call_to_action_one/composer.php, blocks/call_to_action_one/db.xml, blocks/call_to_action_one/auto.js, blocks/call_to_action_one/view.php, blocks/call_to_action_one/edit.php, blocks/call_to_action_one/form.php, blocks/call_to_action_one, blocks/columns_three/add.php, blocks/columns_three/icon.png, blocks/columns_three/controller.php, blocks/columns_three/css_form/repeatable-ft.form.css, blocks/columns_three/css_form, blocks/columns_three/config.json, blocks/columns_three/composer.php, blocks/columns_three/db.xml, blocks/columns_three/js_form/handlebars-helpers.js, blocks/columns_three/js_form/handlebars-v4.0.4.js, blocks/columns_three/js_form, blocks/columns_three/auto.js, blocks/columns_three/view.php, blocks/columns_three/edit.php, blocks/columns_three/form.php, blocks/columns_three, elements/blocks/page_list_plus/form/filters.php, elements/blocks/page_list_plus/form/searchbox.php, elements/blocks/page_list_plus/form/sorting.php, elements/blocks/page_list_plus/form/js.php, elements/blocks/page_list_plus/form/submit.php, elements/blocks/page_list_plus/form/loading.php, elements/blocks/page_list_plus/form, elements/blocks/page_list_plus/title.php, elements/blocks/page_list_plus/pagination.php, elements/blocks/page_list_plus/search/filters/single_option.php, elements/blocks/page_list_plus/search/filters/multiple_option.php, elements/blocks/page_list_plus/search/filters, elements/blocks/page_list_plus/search, elements/blocks/page_list_plus/form.php, elements/blocks/page_list_plus, elements/blocks, js/formidable.js, js/captcha/recaptchav3.js, js/captcha, src/Concrete/Flag/CustomInterfaceFlagHelper.php, src/Concrete/Flag, src/Concrete

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

# Server Software
nginx/1.23.3

# Server API
fpm-fcgi

# PHP Version
8.1.17

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, exif, FFI, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imagick, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, PDO, pdo_dblib, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, readline, Reflection, session, shmop, SimpleXML, soap, sockets, sodium, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlwriter, xsl, Zend OPcache, 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 - 512M
post_max_size - 512M
upload_max_filesize - 512M
zend.exception_string_param_max_len - 15
ldap.max_links - Unlimited
mbstring.regex_retry_limit - 1000000
mbstring.regex_stack_limit - 100000
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.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
unserialize_max_depth - 4096
opcache.jit_bisect_limit - 0
opcache.jit_max_exit_counters - 8192
opcache.jit_max_loop_unrolls - 8
opcache.jit_max_polymorphic_calls - 2
opcache.jit_max_recursive_calls - 2
opcache.jit_max_recursive_returns - 2
opcache.jit_max_root_traces - 1024
opcache.jit_max_side_traces - 128
opcache.max_accelerated_files - 10000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

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