[solved] Upgrading v11 -> v12 stuck at pymysql.err.IntegrityError: (1062, "Duplicate entry

I’m assuming in SQL table ‘tabUOM Conversion Factor’, there exists already a row with name = ‘MAT-UOM-CNV-00001

Check your Naming Series. What is the next number for Series MAT-UOM-CNV?

If the next value is 1, this would explain the problem. The patch might be trying to insert a new UOM conversion. And because of the Naming Series, it believes that MAT-UOM-CNV-00001 is an available value for ‘name

1 Like