Permissions issue after update

Hi,

It’s me again.

Other of the issues I have after a recent update to V5, is that my user can’t see icons on the dashboard when logging in to ERPNext.

The other user of the system does not have this problem, and if I duplicate my user, the new user can see the icons also without problems.

I thought it was a permissions issue, but maybe not?! Sometimes I see the nice colour background empty with no icons, but just after login I see the nav bar with completely white screen beneath, with no icons.

If a search the modules on the search bar I don’t have any problem in accessing all the modules and documents.

I tried to reset permissions from command line, but this is what I get:

/home/erpnext/frappe-bench/apps/erpnext/erpnext/accounts/doctype/chart_of_accounts/chart_of_accounts.json missing
Traceback (most recent call last):
  File "/usr/lib/python2.7/runpy.py", line 162, 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/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 77, in <module>
    main()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 14, in main
    click.Group(commands=commands)(prog_name='bench')
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 610, in __call__
    return self.main(*args, **kwargs)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 590, in main
    rv = self.invoke(ctx)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 936, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 936, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 782, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py", line 416, in invoke
    return callback(*args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 28, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/commands.py", line 381, in reset_perms
    reset_perms(d)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/permissions.py", line 288, in reset_perms
    "DocType", doctype, force=True)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 515, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 37, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 54, in import_file_by_path
    import_doc(doc, force=force, data_import=data_import)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 120, in import_doc
    doc.insert()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 183, in insert
    self.run_post_save_methods()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 518, in run_post_save_methods
    self.run_method("on_update")
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 466, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 577, in composer
    return composed(self, method, *args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 560, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py", line 460, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 115, in on_update
    self.run_module_method("after_doctype_insert")
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 124, in run_module_method
    getattr(module, method)()
  File "/home/erpnext/frappe-bench/apps/erpnext/erpnext/crm/doctype/newsletter_list_subscriber/newsletter_list_subscriber.py", line 13, in after_doctype_insert
    frappe.db.add_unique("Newsletter List Subscriber", ("name", "email"))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 739, in add_unique
    add unique `%s`(%s)""" % (doctype, constraint_name, ", ".join(fields)))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 140, in sql
    self._cursor.execute(query)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1061, "Duplicate key name 'unique_name_email'")

Many thanks for your kind help and your time, as always

Fixed the issue. Please try updating again.

Hi Nabinhait,

Many thanks for your reply.

I have just migrated again from v4, and I can’t see the icons.

Should I try the bench reset-perms again?

Thanks and kind regards,

Hi,

Well, I tried with bench reset-perms, and it is still blank the dashboard.

Also, it complained with a couple of missing files:

server:~/frappe-bench$ bench reset-perms
/home/erpnext/frappe-bench/apps/erpnext/erpnext/accounts/doctype/chart_of_accounts/chart_of_accounts.json missing
/home/erpnext/frappe-bench/apps/frappe/frappe/website/doctype/style_settings/style_settings.json missing

It is not a permission issue. I have fixed the issue, please try after updating.

Deleted those 2 deprecated doctypes via patch

Hi,

I am still missing the icons in here after updating and deleting caches.

Many thanks Nabinhait for your help and kind regards,

Hi,

Icons recovered after last update today at early afternoon.

Many thanks and kind regards from Spain!

Hi. We fixed the icon issue yesterday. Can you update again?

Hi Anand,

Yes, I updated yesterday and it is working great.

Many thanks!!