You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
for 2 customers in database represents_company field was empty string ""
from console I set it to None saved and commit. Then it will migrate successfully.
Updating DocTypes for erpnext : [========== ] 27%
There was an issue while migrating the DocType: Customer
Traceback (most recent call last):
File "/home/revant/frappe-bench/apps/frappe/frappe/database/mariadb/schema.py", line 75, in alter
frappe.db.sql(query)
File "/home/revant/frappe-bench/apps/frappe/frappe/database/database.py", line 152, in sql
self._cursor.execute(query)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.IntegrityError: (1062, "Duplicate entry '' for key 'represents_company'")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/revant/.pyenv/versions/3.7.10/lib/python3.7/runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "/home/revant/.pyenv/versions/3.7.10/lib/python3.7/runpy.py", line 85, in _run_code
exec(code, run_globals)
File "/home/revant/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 101, in <module>
main()
File "/home/revant/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
click.Group(commands=commands)(prog_name='bench')
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 764, in __call__
return self.main(*args, **kwargs)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
rv = self.invoke(ctx)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 1137, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
return callback(*args, **kwargs)
File "/home/revant/frappe-bench/env/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/revant/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 27, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File "/home/revant/frappe-bench/apps/frappe/frappe/commands/site.py", line 300, in migrate
skip_search_index=skip_search_index
File "/home/revant/frappe-bench/apps/frappe/frappe/migrate.py", line 70, in migrate
frappe.model.sync.sync_all(verbose=verbose)
File "/home/revant/frappe-bench/apps/frappe/frappe/model/sync.py", line 19, in sync_all
sync_for(app, force, verbose=verbose, reset_permissions=reset_permissions)
File "/home/revant/frappe-bench/apps/frappe/frappe/model/sync.py", line 70, in sync_for
reset_permissions=reset_permissions, for_sync=True)
File "/home/revant/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 70, in import_file_by_path
ignore_version=ignore_version, reset_permissions=reset_permissions)
File "/home/revant/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 143, in import_doc
doc.insert()
File "/home/revant/frappe-bench/apps/frappe/frappe/model/document.py", line 267, in insert
self.run_post_save_methods()
File "/home/revant/frappe-bench/apps/frappe/frappe/model/document.py", line 982, in run_post_save_methods
self.run_method("on_update")
File "/home/revant/frappe-bench/apps/frappe/frappe/model/document.py", line 847, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File "/home/revant/frappe-bench/apps/frappe/frappe/model/document.py", line 1136, in composer
return composed(self, method, *args, **kwargs)
File "/home/revant/frappe-bench/apps/frappe/frappe/model/document.py", line 1119, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File "/home/revant/frappe-bench/apps/frappe/frappe/model/document.py", line 841, in <lambda>
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File "/home/revant/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 247, in on_update
raise e
File "/home/revant/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 244, in on_update
frappe.db.updatedb(self.name, Meta(self))
File "/home/revant/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 291, in updatedb
db_table.sync()
File "/home/revant/frappe-bench/apps/frappe/frappe/database/schema.py", line 37, in sync
self.alter()
File "/home/revant/frappe-bench/apps/frappe/frappe/database/mariadb/schema.py", line 84, in alter
fieldname, self.table_name))
File "/home/revant/frappe-bench/apps/frappe/frappe/__init__.py", line 424, in throw
msgprint(msg, raise_exception=exc, title=title, indicator='red', is_minimizable=is_minimizable, wide=wide, as_list=as_list)
File "/home/revant/frappe-bench/apps/frappe/frappe/__init__.py", line 403, in msgprint
_raise_exception()
File "/home/revant/frappe-bench/apps/frappe/frappe/__init__.py", line 357, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.ValidationError: represents_company field cannot be set as unique in tabCustomer, as there are non-unique existing values
I executed following python script on my database from bench console
for 2 customers in database
represents_company
field was empty string""
from console I set it to
None
saved and commit. Then it will migrate successfully.I executed following python script on my database from bench console
The text was updated successfully, but these errors were encountered: