Skip to Content

New J2Commerce 6.6.5 is out. Here is everything in the release.

See What’s New
Account
Enter the email address on your account.
Forgot your username?
Enter your password.
Forgot your password?

Or continue with

Closed Public Category: Migration Ticket #829

Tools & Finalise step question

This is a public ticket

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

J2Commerce

Version
J2Commerce v6

Conversation

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

Attachments

j2commerce-migrator-j2commerce4-2026-06-12_120115.log
Olivier Buisard Staff

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.

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 Buisard Staff

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.

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 */;

Antonio Cornacchia

Hi Olivier

why payment methods details are not migrated? Bank info and Paypal account are empty after migration in J2Commerce 6.

Regards

Antonio Cornacchia

Hi Olivier, I was waiting for a response regarding this issue. I've continued to run more tests using the latest versions of the components and Migrator, but the payment configurations still haven't been migrated.

Thanks.

Olivier Buisard Staff

Hi Antonio,

apologies, I forgot to answer that one.

Payment credentials are not data, they are security secrets. Secrets are never migrated. They must be re‑entered so the payment gateway can re‑authenticate the new store.

I hope this answers your question.

Olivier.