Skip to content

BUG: Install ERPNext on postgres fails due to 'column "route(500)" does not exist' #18028

@madmath03

Description

@madmath03

Install of ERPNext from develop branch (with frappe also from develop branch) on postgres 10 fails due to column "route(500)" not existing.

Stack trace:

Installing erpnext...
Updating DocTypes for erpnext       : [====Traceback (most recent call last):  ]
   File "/usr/local/lib/python3.7/runpy.py", line 193, in _run_module_as_main
     "__main__", mod_spec)
   File "/usr/local/lib/python3.7/runpy.py", line 85, in _run_code
     exec(code, run_globals)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 97, in <module>
     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/lib/python3.7/site-packages/click/core.py", line 764, in __call__
     return self.main(*args, **kwargs)
   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 717, in main
     rv = self.invoke(ctx)
   File "/home/frappe/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/frappe/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/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 956, in invoke
     return ctx.invoke(self.callback, **ctx.params)
   File "/home/frappe/frappe-bench/env/lib/python3.7/site-packages/click/core.py", line 555, in invoke
     return callback(*args, **kwargs)
   File "/home/frappe/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/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 170, in install_app
     _install_app(app, verbose=context.verbose)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/installer.py", line 84, in install_app
     sync_for(name, force=True, sync_everything=True, verbose=verbose, reset_permissions=True)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/sync.py", line 56, in sync_for
     reset_permissions=reset_permissions, for_sync=True)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 66, 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 141, in import_doc
     doc.insert()
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 258, in insert
     self.run_post_save_methods()
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 917, in run_post_save_methods
     self.run_method("on_update")
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 786, in run_method
     out = Document.hook(fn)(self, *args, **kwargs)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1055, in composer
     return composed(self, method, *args, **kwargs)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 1038, in runner
     add_to_return_value(self, fn(self, *args, **kwargs))
   File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 780, in <lambda>
     fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 279, in on_update
     self.run_module_method("on_doctype_update")
   File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 348, in run_module_method
     getattr(module, method)()
   File "/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/doctype/item/item.py", line 1077, in on_doctype_update
     frappe.db.add_index("Item", ["route(500)"])
   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/postgres/database.py", line 254, in add_index
     self.sql("""CREATE INDEX IF NOT EXISTS "{}" ON `{}`("{}")""".format(index_name, table_name, '", "'.join(fields)))
   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/postgres/database.py", line 103, in sql
     return super(PostgresDatabase, self).sql(*args, **kwargs)
   File "/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py", line 171, in sql
     self._cursor.execute(query)
 psycopg2.ProgrammingError: column "route(500)" does not exist

Updating DocTypes for erpnext       : [=======================                 ]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions