#829 Tools & Finalise step question

Posted in ‘Migration Requests’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Latest post by Olivier on Saturday, 13 June 2026 18:07 UTC

Antonio Cornacchia

Hello
I'm testing the migration to J2Commerce on a localhost copy of my site.

After the upgrade from J!5.x to J!6.x I installed J2Commerce 6. The Migration Wizard is ok until the last step, for the Migrate Store Settings I still see the "Retry" button.
Attached the log file.

Regards

Olivier

Antonio,

is it possible to access the site? If not, can you tell us what is the content of the j2store configuration table?

Thanks!

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Antonio Cornacchia

Since it's on a local machine (using MAMP), I can't grant external access.
I exported the table, and I think there might be a problem because this is the result:
SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

<div class="alert alert-danger" role="alert"><img src="https://www.j2commerce.com/themes/dot.gif" title="" alt="" class="icon ic_s_error"> TypeError: PhpMyAdmin\Export::exportDatabase(): Argument #3 ($whatStrucOrData) must be of type string, null given, called in /Applications/MAMP/bin/phpMyAdmin5/libraries/classes/Controllers/Export/ExportController.php on line 547</div></body></html>

However, it opens in the backend and is configured correctly.

 

Olivier

Antonio,

if we cannot see the database signature, this is going to be difficult to troubleshoot. 

I am looking for something like:

CREATE TABLE `tada_j2store_configurations` (
`config_meta_key` varchar(255) NOT NULL,
`config_meta_value` text,
`config_meta_default` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

INSERT INTO `tada_j2store_configurations` (`config_meta_key`, `config_meta_value`, `config_meta_default`) VALUES
('13fe403f608b', '1', NULL),
('921373770e56fe3', '1', NULL),
('addtocart_action', '3', NULL),
('addtocart_button_class', 'btn btn-primary', NULL),
('addtocart_placement', 'default', NULL),
('admin_email', 'support@j2commerce.com', NULL),
('allow_guest_checkout', '1', NULL),
('allow_password_validation', '1', NULL),
('allow_registration', '1', NULL),
('attachmentfolderpath', 'media/downloads', NULL),
('auto_apply_shipping_rate', '1', NULL),
('backend_voucher_to_shipping', '1', NULL),
('bootstrap_version', '5', NULL),
('cancel_order', '1', NULL),
('catalog_mode', '0', NULL),
('checkout_price_display_options', '1', NULL),
('clear_cart', 'order_placed', NULL),
('clear_outdated_cart_data_term', '90', NULL),
('config_cart_empty_redirect', 'cart', NULL),
('config_cart_redirect_page_url', '', NULL),
('config_continue_shopping_page', 'previous', NULL),
('config_continue_shopping_page_url', '', NULL),
('config_currency', 'USD', NULL),
('config_currency_auto', '1', NULL),
('config_including_tax', '1', NULL),
('config_length_class_id', '2', NULL),
('config_tax_default', 'billing', NULL),
('config_tax_default_address', 'store', NULL),
('config_weight_class_id', '4', NULL),
('continue_cart_redirect_menu', '101', NULL),
('continue_shopping_page_menu', '101', NULL),
('country_id', '223', NULL),
('coupon_update', '1', NULL),
('date_format', 'm/d/Y', NULL),
('default_payment_method', 'payment_paypal', NULL),
('display_price_with_tax_info', '0', NULL),
('downloadid', 'a19b154a321855f7f2', NULL),
('download_area', '1', NULL),
('enable_coupon', '1', NULL),
('enable_falang_support', '0', NULL),
('enable_inventory', '1', NULL),
('enable_voucher', '1', NULL),
('export_column_per_product_option', '1', NULL),
('hide_shipping_until_address_selection', '1', NULL),
('hold_stock', '60', NULL),
('image_for_product_options', '0', NULL),
('installation_complete', '1', NULL),
('invoice_prefix', '', NULL),
('isregister', '0', NULL),
('j2commerce_isnew', '1', NULL),
('j2store_enable_css', '1', NULL),
('jquery_ui_localisation', '1', NULL),
('limit_orderstatuses', '*', NULL),
('load_bootstrap', '0', NULL),
('load_fancybox', '1', NULL),
('load_fontawesome_ui', '1', NULL),
('load_jquery_ui', '3', NULL),
('load_minimal_bootstrap', '0', NULL),
('load_timepicker', '3', NULL),
('option', 'com_j2store', NULL),
('plugin_check_date', '2025-12-31', NULL),
('postalcode_required', '1', NULL),
('prepare_content', '0', NULL),
('price_display_options', '2', NULL),
('product_option_price', '1', NULL),
('product_option_price_prefix', '1', NULL),
('queue_key', 'e1edfe9ea1e14f8', NULL),
('queue_repeat_count', '10', NULL),
('related_product_columns', '3', NULL),
('send_default_email_template', '1', NULL),
('shipping_mandatory', '0', NULL),
('show_base_price', '1', NULL),
('show_clear_cart_button', '0', NULL),
('show_customer_note', '1', NULL),
('show_item_tax', '0', NULL),
('show_login_form', '1', NULL),
('show_logout_myprofile', '0', NULL),
('show_manufacturer', '0', NULL),
('show_postpayment_orderlink', '1', NULL),
('show_price_field', '1', NULL),
('show_product_price_for_register_user', '0', NULL),
('show_product_sku_for_register_user', '0', NULL),
('show_qty_field', '1', NULL),
('show_shipping_address', '1', NULL),
('show_sku', '1', NULL),
('show_tax_calculator', '1', NULL),
('show_terms', '1', NULL),
('show_thumb_cart', '3', NULL),
('show_thumb_email', '1', NULL),
('stock_display_format', 'always_show', NULL),
('store_address_1', '854 Tada Street', NULL),
('store_address_2', '', NULL),
('store_billing_layout', '<div class=\"row\">\n <div class=\"col-md-6\">[first_name] [last_name] [email] [phone_1] [phone_2] [company] [tax_number]</div>\n <div class=\"col-md-6\">[address_1] [address_2] [city] [zip] [country_id] [zone_id]</div>\n </div>', NULL),
('store_city', 'Job Lake', NULL),
('store_max_sale_qty', '', NULL),
('store_min_sale_qty', '1', NULL),
('store_name', 'Joomla 5', NULL),
('store_notify_qty', '', NULL),
('store_payment_layout', '', NULL),
('store_shipping_layout', '<div class=\"row\">\n <div class=\"col-md-6\">[first_name] [last_name] [phone_1] [phone_2] [company]</div>\n <div class=\"col-md-6\">[address_1] [address_2] [city] [zip] [country_id] [zone_id]</div>\n </div>', NULL),
('store_zip', '0K6', NULL),
('task', 'saveConfig', NULL),
('termsid', '', NULL),
('terms_display_type', 'link', NULL),
('update_complete', '1', NULL),
('view', 'postconfig', NULL),
('zone_id', '3655', NULL);

It would be great to get that information.

If too difficult, we can go to plan B, where you can install a plugin of our own on your site, which should help get that info.

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Antonio Cornacchia

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Creato il: Giu 13, 2026 alle 06:37
-- Versione del server: 8.0.40
-- Versione PHP: 8.3.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `awand`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `zk637_j2store_configurations`
--

CREATE TABLE `zk637_j2store_configurations` (
`config_meta_key` varchar(255) NOT NULL,
`config_meta_value` text,
`config_meta_default` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dump dei dati per la tabella `zk637_j2store_configurations`
--

INSERT INTO `zk637_j2store_configurations` (`config_meta_key`, `config_meta_value`, `config_meta_default`) VALUES
('a90711f704aa9aeb9ed55bd3df52d330', '1', ''),
('addtocart_action', '3', NULL),
('addtocart_button_class', 'btn btn-primary', NULL),
('addtocart_placement', 'both', NULL),
('admin_email', 'info@awand.org,info@squilibri.it,squilibri@tiscali.it', NULL),
('allow_guest_checkout', '1', NULL),
('allow_password_validation', '1', NULL),
('allow_registration', '1', NULL),
('attachmentfolderpath', '', NULL),
('auto_apply_shipping_rate', '0', NULL),
('backend_voucher_to_shipping', '0', NULL),
('bootstrap_version', '5', NULL),
('cancel_order', '0', NULL),
('catalog_mode', '0', NULL),
('checkout_price_display_options', '1', NULL),
('clear_cart', 'order_placed', NULL),
('clear_outdated_cart_data_term', '7', NULL),
('config_cart_empty_redirect', 'cart', NULL),
('config_cart_redirect_page_url', '', NULL),
('config_continue_shopping_page', 'previous', NULL),
('config_continue_shopping_page_url', '', NULL),
('config_currency', 'EUR', NULL),
('config_currency_auto', '1', NULL),
('config_including_tax', '1', NULL),
('config_length_class_id', '1', NULL);

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `zk637_j2store_configurations`
--
ALTER TABLE `zk637_j2store_configurations`
ADD PRIMARY KEY (`config_meta_key`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Olivier

Thank you!

Olivier.

Growing Together

Help us get back to #1 in the Joomla Extension Directory by leaving us a 5-Star review here.

Stay Updated

Subscribe for free and be the first to know about the latest features, updates, and new additions.