2

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!

  • Have you checked the privilage of your db username in the server backend (CPanel or anything else? Does it includes trigger? Have you tried to run this in shell : mysql -u USERNAME -p (your password) and then run set global log_bin_trust_function_creators=1; – MBK1People Mar 20 at 19:01
0

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.