Magento Asked by randal_flagg on December 7, 2021
When running the data migration tool
php bin/magento migrate:data vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.1.0/config.xml
We get the following error:
[Zend_Db_Statement_Exception]
SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), query was: CREATE
TRIGGER trg_catalog_compare_item_after_insert AFTER INSERT ON catalog_compare_item FOR EACH ROW
BEGIN
INSERT INTO m2_cl_catalog_compare_item (`catalog_compare_item_id`, `operation`) VALUES (NEW.catalog_compare_item_id, 'INSERT')ON DUPLICATE KEY UPDATE operation = 'INSERT';
END
Unfortunately, as we are on a Shared Server they cannot provide this privilege or configure this variable from the hosting’s end.
Is there something we can change to make this work?
Thanks!
You may try to set the MySQL variable directly on the MySQL client.
set global log_bin_trust_function_creators=1;
If not, you need to check with your hosting provider.
Answered by Franck Garnier on December 7, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP