While in the process of running the data migration tool. We came across this error message that read: SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user for table ‘catalog_compare_item’. The error happened to be an access violation for Magento 1.

To clear the error message we went to MySQL® Databases in cPanel. Then next to the Magento 1 database we clicked on the privileged user. The user did not have all privileges and TRIGGER was unselected. We then granted all privileges for the Magento 1 user.

This cleared the SQLSTATE[42000] error message when running the Magento data migration tool.

Elyssa McGregor

Hi! I'm Elyssa McGregor. I love helping people succeed online and promoting businesses with our wide range of promotional products. I have a love for search engine optimization (SEO) and getting companies out there on the world wide web. How can I help you?

View all posts

Add comment

Your email address will not be published. Required fields are marked *