Hi there,
I purchased your Data Migration Pro about 3 months ago, we’ve spent quite some time working on the website after migrating the first data from our live site. It seems like it’s expired and we didn’t get a chance to do a Delta Migration.
When we get to Step 7 (Sales) It is giving us this error message:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘12781’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `mg_sales_order_tax` (`tax_id`, `order_id`, `code`, `title`, `percent`, `amount`, `priority`, `position`, `base_amount`, `process`, `base_real_amount`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)
I’ve already done the:
Delete From mg_sales_order_tax Where entity_id = 12781;
But SQL says:
Error
SQL query:
Delete From mg_sales_order_tax Where entity_id = 12781
MySQL said:
#1054 -- Unknown column ‘entity_id’ in ‘where clause’
Any advice?
Thanks!
3 answers
Hi there,
it seems like it’s expired and I didn’t get a chance to do a Delta Migration.
It is not letting me anymore… and it’s giving me some error messages.
Please provide me more details information about the issue you mentioned. Also, provide me information about your instance as below:
+ Admin credentials and URL to back-end of your M2 site
+ SSH credentials and path to M2 folder
I will help to check further and get back you then.
Regards,
Mall.
Hi there,
I couldn’t access to your back-end with the admin credentials you provided: http://i.prntscr.com/AkNr_xr2QyaIBR3JQSx0sA.png
Please help to check again.
Meanwhile, regarding the error message you quoted:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘12781’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `mg_sales_order_tax` (`tax_id`, `order_id`, `code`, `title`, `percent`
To fix that issue, you need to run the SQL below in your M2 database:
Delete From mg_sales_order_tax Where tax_id = 12781;
+ Once done, you can continue as normal.
Regards,
Mall.