ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Error while installing new site


#1

We are installing a new frappe instance.
New bench and frappe version (developer). Ubuntu 18.4
When we define the new site we get an mysql error. The mariadb is fresh and connecting well.
What can we do?
Any help is appreciated.

Updating DocTypes for 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 "/srv/bench/erptest/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
    main()
  File "/srv/bench/erptest/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
    click.Group(commands=commands)(prog_name='bench')
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/click/core.py", line 764, in __call__
    return self.main(*args, **kwargs)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/click/core.py", line 717, in main
    rv = self.invoke(ctx)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/click/core.py", line 956, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/click/core.py", line 555, in invoke
    return callback(*args, **kwargs)
  File "/srv/bench/erptest/apps/frappe/frappe/commands/site.py", line 33, in new_site
    db_type = db_type)
  File "/srv/bench/erptest/apps/frappe/frappe/commands/site.py", line 70, in _new_site
    _install_app(app, verbose=verbose, set_as_patched=not source_sql)
  File "/srv/bench/erptest/apps/frappe/frappe/installer.py", line 84, in install_app
    sync_for(name, force=True, sync_everything=True, verbose=verbose, reset_permissions=True)
  File "/srv/bench/erptest/apps/frappe/frappe/model/sync.py", line 56, in sync_for
    reset_permissions=reset_permissions, for_sync=True)
  File "/srv/bench/erptest/apps/frappe/frappe/modules/import_file.py", line 66, in import_file_by_path
    ignore_version=ignore_version, reset_permissions=reset_permissions)
  File "/srv/bench/erptest/apps/frappe/frappe/modules/import_file.py", line 141, in import_doc
    doc.insert()
  File "/srv/bench/erptest/apps/frappe/frappe/model/document.py", line 258, in insert
    self.run_post_save_methods()
  File "/srv/bench/erptest/apps/frappe/frappe/model/document.py", line 917, in run_post_save_methods
    self.run_method("on_update")
  File "/srv/bench/erptest/apps/frappe/frappe/model/document.py", line 786, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
  File "/srv/bench/erptest/apps/frappe/frappe/model/document.py", line 1055, in composer
    return composed(self, method, *args, **kwargs)
  File "/srv/bench/erptest/apps/frappe/frappe/model/document.py", line 1038, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/srv/bench/erptest/apps/frappe/frappe/model/document.py", line 780, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/srv/bench/erptest/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 279, in on_update
    self.run_module_method("on_doctype_update")
  File "/srv/bench/erptest/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 348, in run_module_method
    getattr(module, method)()
  File "/srv/bench/erptest/apps/frappe/frappe/core/doctype/communication/communication.py", line 289, in on_doctype_update
    frappe.db.add_index("Communication Link", ["link_doctype", "link_name"])
  File "/srv/bench/erptest/apps/frappe/frappe/database/mariadb/database.py", line 253, in add_index
    if not self.has_index(table_name, index_name):
  File "/srv/bench/erptest/apps/frappe/frappe/database/mariadb/database.py", line 245, in has_index
    index_name=index_name
  File "/srv/bench/erptest/apps/frappe/frappe/database/database.py", line 171, in sql
    self._cursor.execute(query)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 517, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 732, in _read_query_result
    result.read()
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1075, in read
    first_packet = self.connection._read_packet()
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/srv/bench/erptest/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, u"Table '_b409e168a2d2f22c.tabCommunication Link' doesn't exist")

#2

See this link…


#3

I suspect that the problem was caused by a ubuntu apt update. I suppose that that loads some veriosn of a python library that causes the problem.

When I do a new fresh ubuntu install (partly following the how to you refer to) it is working.

I have the feeling that that is one of the python disadvantages.

Thanks anyhow.

Met vriendelijke groeten, Kind regards,
``Braedius
Medical

Braedius Medical BV
Bikbergerweg 18
1272 PM Huizen,The Netherlands
Email: frank.messie@braedius.com
Phone: +31(0)358876100
Mobile: +31654665520
Web: www.braedius.com

trentmu

    May 31

See this link…

[New installation Issue](https://u5968873.ct.sendgrid.net/wf/click?upn=tpnhN2PDH04qGcoOy06bdSzngX9HFcIvUsr98XA5f6ibDGSPT8gBEPsTRWlRiwfuBaaWFIHIbF9iO4rG6ktMIYRuyZ-2FbxZPPgUhLpDckiGk-3D_YHTYZr-2BoC467NZmuaMcOY44Rdhg6ny4WqpBriIrsb1ewo46nwF-2Fu9c-2Bhx9oKtinI4qY3o5T3WV7c4AlC7QeyA847PkGH-2FOFQtQtMNO4bHu4rrwZCxeccatBJnC1cekvK-2BMFWB7gHJnJgpp5ghqx4MQySCjTPSzSXQJvO-2FsCf-2BJzIYaSQUILTFbEONQ-2F-2BUsguF4Q22RY75spo-2FELKriAIVXtQn66gNhH6f-2B-2BmahODVz8-3D) [ERPNext](https://u5968873.ct.sendgrid.net/wf/click?upn=xpQuMF-2BI9SGsnBJHyGXF49WuschlKMJ9D2-2B7E1NWGTQK0c96mD6eEPx2xIcx7xBh_YHTYZr-2BoC467NZmuaMcOY44Rdhg6ny4WqpBriIrsb1ewo46nwF-2Fu9c-2Bhx9oKtinI4qY3o5T3WV7c4AlC7QeyAydVakN66v1YbV0zwtXl3LKIOlWqN5kf9dDK2Z1Igg4eCVZF-2FwRDP83843LQTm4c0fcChlKUy3x4ayarUMh20fhnCjtdN1Qgyfsv6nGHRxMPGTlj-2FQNlRJCf8OhmpvV7h3FpYneFI9XOrNjmkXyqBR4-3D)

Try following the instructions on this guide - https://github.com/frappe/frappe/wiki/The-Hitchhiker’s-Guide-to-Installing-Frappé-on-Linux

We have been consistently successful with it. If you are familiar with basic Python development, you may want to also set up a virtualenv just before running pip install -e ./bench


Visit Topic or reply to this email to respond.

To unsubscribe from these emails, click here.

On Fri, 31/05/2019 07:40 AM, Trent Murgatroyd discuss@erpnext.com wrote:

Email sent using Axigen Free Mail Server:

http://www.axigen.com/mail-server/free