During data migration from Magento1 to Magento2, I'm getting the following issue:-

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; END;
INSERT INTO m2_cl_cataloginventory_stock_item (item_id, operation) V' at line 3, query was: CREATE TRIGGER codisto_cataloginventory_stock_item_delete AFTER DELETE ON cataloginventory_stock _item FOR EACH ROW

Please see the screenshot for more details


Please help me to resolve this issue.


  • Facing the same issue. Can anyone have its solution. – user70923 Aug 8 '18 at 12:21
  • This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review – Piyush Aug 8 '18 at 12:41
  • Does your database user have the permission to create triggers? – simonthesorcerer Aug 8 '18 at 16:34

Your Answer

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

Browse other questions tagged or ask your own question.