Hello Community,
I tried to install ERPNext on ubuntu 16.04. I am facing this error while I am rying to add a newsite.
$ bench new-site site2.local
MySQL root password:
mysql: [Warning] Using a password on the command line interface can be insecure.Installing frappe…
Updating DocTypes for frappe : [========================================]
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/kys/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/home/kys/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/kys/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/kys/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/kys/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/kys/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/commands/site.py”, line 34, in new_site
verbose=verbose, install_apps=install_app, source_sql=source_sql, force=force)
File “/home/kys/frappe-bench/apps/frappe/frappe/commands/site.py”, line 69, in _new_site
_install_app(app, verbose=verbose, set_as_patched=not source_sql)
File “/home/kys/frappe-bench/apps/frappe/frappe/installer.py”, line 145, in install_app
add_to_installed_apps(name)
File “/home/kys/frappe-bench/apps/frappe/frappe/installer.py”, line 166, in add_to_installed_apps
post_install(rebuild_website)
File “/home/kys/frappe-bench/apps/frappe/frappe/installer.py”, line 230, in post_install
init_singles()
File “/home/kys/frappe-bench/apps/frappe/frappe/installer.py”, line 251, in init_singles
doc.save()
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 256, in save
return self._save(*args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 279, in _save
self.insert()
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 245, in insert
self.run_post_save_methods()
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 887, in run_post_save_methods
self.run_method(“on_update”)
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 755, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 1024, in composer
return composed(self, method, *args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 1007, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/kys/frappe-bench/apps/frappe/frappe/model/document.py”, line 749, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/core/doctype/domain_settings/domain_settings.py”, line 22, in on_update
self.restrict_roles_and_modules()
File “/home/kys/frappe-bench/apps/frappe/frappe/core/doctype/domain_settings/domain_settings.py”, line 27, in restrict_roles_and_modules
active_domains = frappe.get_active_domains()
File “/home/kys/frappe-bench/apps/frappe/frappe/init.py”, line 1405, in get_active_domains
return get_active_domains()
File “/home/kys/frappe-bench/apps/frappe/frappe/core/doctype/domain_settings/domain_settings.py”, line 62, in get_active_domains
return frappe.cache().get_value(“active_domains”, _get_active_domains)
File “/home/kys/frappe-bench/apps/frappe/frappe/utils/redis_wrapper.py”, line 72, in get_value
val = generator()
File “/home/kys/frappe-bench/apps/frappe/frappe/core/doctype/domain_settings/domain_settings.py”, line 56, in _get_active_domains
fields=[“domain”], distinct=True)
File “/home/kys/frappe-bench/apps/frappe/frappe/init.py”, line 1177, in get_all
return get_list(doctype, *args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/init.py”, line 1150, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(None, *args, **kwargs)
File “/home/kys/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 88, in execute
result = self.build_and_run()
File “/home/kys/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 112, in build_and_run
return frappe.db.sql(query, as_dict=not self.as_list, debug=self.debug, update=self.update)
File “/home/kys/frappe-bench/apps/frappe/frappe/database.py”, line 176, in sql
self._cursor.execute(query)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 166, in execute
result = self._query(query)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 856, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1057, in _read_query_result
result.read()
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1340, in read
first_packet = self.connection._read_packet()
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 1014, in _read_packet
packet.check_error()
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py”, line 393, in check_error
err.raise_mysql_exception(self._data)
File “/home/kys/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/err.py”, line 107, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (3065, u"Expression #1 of ORDER BY clause is not in SELECT list, references column ‘a46003081c220c38.tabHas Domain.modified’ which is not in SELECT list; this is incompatible with DISTINCT")
Help me to solve this Issue.