[UPDATE ERROR] item_code field cannot be set as unique in tabItem

[vladucoju]

Hello,

i can't finish update. I have error item_code field cannot be set as unique in tabItem, as there are non-unique existing values. After that i find problem in the database. I remove unique item_code from the table. Run update again and same error. In database was created again this unique key

Executing erpnext.patches.v11_0.move_item_defaults_to_child_table_for_multicompany #02-07-2018 in gramat (0a45e633db7ea364)

There was an issue while migrating the DocType: Item

Traceback (most recent call last): File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main "main", fname, loader, pkg_name) File "/usr/lib/python2.7/runpy.py", line 72, in _run_code exec code in run_globals File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 97, in main() File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main click.Group(commands=commands)(prog_name='bench') File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 722, in call return self.main(args, kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, ctx.params) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke return callback(args, kwargs) File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, *kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py", line 25, in _func ret = f(frappe._dict(ctx.obj), args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 222, in migrate migrate(context.verbose, rebuild_website=rebuild_website) File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 39, in migrate frappe.modules.patch_handler.run_all() File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 29, in run_all if not run_single(patchmodule = patch): File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 63, in run_single return execute_patch(patchmodule, method, methodargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 83, in execute_patch frappe.get_attr(patchmodule.split()[0] + ".execute")() File "/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v11_0/move_item_defaults_to_child_table_for_multicompany.py", line 18, in execute frappe.reload_doc('stock', 'doctype', 'item') File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 724, in reload_doc return frappe.modules.reload_doc(module, dt, dn, force=force, reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/utils.py", line 155, in reload_doc return import_files(module, dt, dn, force=force, reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 26, in import_files reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 31, in import_file ret = import_file_by_path(path, force, pre_process=pre_process, reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 65, in import_file_by_path ignore_version=ignore_version, reset_permissions=reset_permissions) File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 132, in import_doc doc.insert() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 249, in insert self.run_post_save_methods() File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 898, in run_post_save_methods self.run_method("on_update") File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 765, in run_method out = Document.hook(fn)(self, *args, kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1040, in composer return composed(self, method, *args, *kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1023, in runner add_to_return_value(self, fn(self, args, kwargs)) File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 759, in fn = lambda self, *args, *kwargs: getattr(self, method)(args, **kwargs) File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 231, in on_update raise e frappe.exceptions.ValidationError: item_code field cannot be set as unique in tabItem, as there are non-unique existing values

[vladucoju]

I still have this error after latest update. It is stuck on one database. There is unique id item_code. I delete him from database but update is populating him again.