Error when installing on V15

[showlinepos]

Information about bug

being able to install erpnext v15

Module

Loan Management

Version

error when installing on v15
error when installing on v15 erpnext

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

frappe1@vmi1947963:~/frappe-bench$ bench install-app lending
Please specify --site sitename
frappe1@vmi1947963:~/frappe-bench$ bench --site erp3.havano.online install-app lending
App erpnext already installed

Installing lending...

Running post-install patches to patch existing data...

An error occurred while installing lending: (1146, "Table '_7c9073ad97ca0aea.tabLoan' doesn't exist")
Traceback with variables (most recent call last):
  File "apps/frappe/frappe/commands/site.py", line 496, in install_app
    _install_app(app, verbose=context.verbose, force=force)
      context = {'sites': ['erp3.havano.online'], 'force': False, 'verbose': False, 'profile': False}
      apps = ('lending',)
      force = False
      _install_app = <function install_app at 0x7f145be9f400>
      filelock = <function filelock at 0x7f145be9f0a0>
      exit_code = 0
      site = 'erp3.havano.online'
      app = 'lending'
      err = ProgrammingError(1146, "Table '_7c9073ad97ca0aea.tabLoan' doesn't exist")
  File "apps/frappe/frappe/installer.py", line 324, in install_app
    frappe.get_attr(after_install)()
      name = 'lending'
      verbose = False
      set_as_patched = True
      force = False
      sync_jobs = <function sync_jobs at 0x7f145b51f400>
      sync_for = <function sync_for at 0x7f145b51ff40>
      sync_customizations = <function sync_customizations at 0x7f145c0e5750>
      sync_fixtures = <function sync_fixtures at 0x7f145b3341f0>
      app_hooks = {'after_install': ['lending.install.after_install'], 'app_description': ['Open Source Lending software'], 'app_email': ['[email protected]'], 'app_include_js': ['lending.bundle.js'], 'app_license': ['GNU General Public License (v3)'], 'app_name': ['lending'], 'app_publisher': ['Frappe Technologies Pvt. Ltd.'], 'app_title': ['Frappe Lending'], 'audit_trail_doctypes': ['Loan Balance Adjustment', 'Loan Disbursement', 'Loan Interest Accrual', 'Loan Refund', 'Loan Repayment', 'Loan Write Off'], 'bank_reconciliation_doctypes': ['Loan Repayment', 'Loan Disbursement'], 'before_tests': ['lending.utils.before_tests'], 'before_uninstall': ['lending.uninstall.before_uninstall'], 'doc_events': {'Company': {'validate': ['lending.overrides.company.validate_loan_tables']}}, 'get_amounts_not_reflected_in_system_for_bank_reconciliation_statement': ['lending.loan_management.utils.get_amounts_not_reflected_in_system_for_bank_reconciliation_statement'], 'get_entries_for_bank_clearance_summary': ['lending.l...
      installed_apps = ['frappe', 'erpnext', 'datavalue_theme_15', 'pos_api']
      app = 'erpnext'
      required_app = 'erpnext'
      after_install = 'lending.install.after_install'
  File "apps/lending/lending/install.py", line 236, in after_install
    run_patches(get_post_install_patches())
  File "apps/lending/lending/install.py", line 227, in run_patches
    frappe.get_attr(f"lending.patches.v15_0.{patch}.execute")()
      patches = ('rename_loan_type_to_loan_product', 'generate_loan_repayment_schedule', 'update_loan_types', 'make_loan_type_non_submittable', 'migrate_loan_type_to_loan_product', 'add_loan_product_code_and_rename_loan_name', 'update_penalty_interest_method_in_loan_products')
      patch = 'generate_loan_repayment_schedule'
  File "apps/lending/lending/patches/v15_0/generate_loan_repayment_schedule.py", line 8, in execute
    loans_created = frappe.db.count("Loan")
  File "apps/frappe/frappe/database/database.py", line 1149, in count
    count = frappe.qb.get_query(
      self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f145b5c4cd0>
      dt = 'Loan'
      filters = None
      debug = False
      cache = False
      distinct = True
  File "apps/frappe/frappe/query_builder/utils.py", line 84, in execute_query
    result = frappe.db.sql(query, params, *args, **kwargs)  # nosemgrep
      query = 'SELECT DISTINCT COUNT(*) FROM `tabLoan`'
      args = ()
      kwargs = {'debug': False}
      child_queries = []
      params = {}
      execute_child_queries = <function patch_query_execute.<locals>.execute_child_queries at 0x7f145b5a25f0>
      prepare_query = <function patch_query_execute.<locals>.prepare_query at 0x7f145b5d5d80>
  File "apps/frappe/frappe/database/database.py", line 236, in sql
    self._cursor.execute(query, values)
      self = <frappe.database.mariadb.database.MariaDBDatabase object at 0x7f145b5c4cd0>
      query = 'SELECT DISTINCT COUNT(*) FROM `tabLoan`'
      values = {}
      as_dict = 0
      as_list = 0
      debug = False
      ignore_ddl = 0
      auto_commit = 0
      update = None
      explain = False
      run = True
      pluck = False
      as_iterator = False
      trace_id = None
  File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
      self = <pymysql.cursors.Cursor object at 0x7f1459c0a4d0>
      query = 'SELECT DISTINCT COUNT(*) FROM `tabLoan`'
      args = {}
  File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
      self = <pymysql.cursors.Cursor object at 0x7f1459c0a4d0>
      q = 'SELECT DISTINCT COUNT(*) FROM `tabLoan`'
      conn = <pymysql.connections.Connection object at 0x7f1459c0a380>
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 563, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
      self = <pymysql.connections.Connection object at 0x7f1459c0a380>
      sql = b'SELECT DISTINCT COUNT(*) FROM `tabLoan`'
      unbuffered = False
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 825, in _read_query_result
    result.read()
      self = <pymysql.connections.Connection object at 0x7f1459c0a380>
      unbuffered = False
      result = <pymysql.connections.MySQLResult object at 0x7f1458e2b010>
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1199, in read
    first_packet = self.connection._read_packet()
      self = <pymysql.connections.MySQLResult object at 0x7f1458e2b010>
  File "env/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_packet
    packet.raise_for_error()
      self = <pymysql.connections.Connection object at 0x7f1459c0a380>
      packet_type = <class 'pymysql.protocol.MysqlPacket'>
      buff = bytearray(b"\xffz\x04#42S02Table \'_7c9073ad97ca0aea.tabLoan\' doesn\'t exist")
      packet_header = b'8\x00\x00\x01'
      btrl = 56
      btrh = 0
      packet_number = 1
      bytes_to_read = 56
      recv_data = b"\xffz\x04#42S02Table '_7c9073ad97ca0aea.tabLoan' doesn't exist"
      packet = <pymysql.protocol.MysqlPacket object at 0x7f1458e2bfd0>
  File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
      self = <pymysql.protocol.MysqlPacket object at 0x7f1458e2bfd0>
      errno = 1146
  File "env/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
      data = b"\xffz\x04#42S02Table '_7c9073ad97ca0aea.tabLoan' doesn't exist"
      errno = 1146
      errval = "Table '_7c9073ad97ca0aea.tabLoan' doesn't exist"
      errorclass = <class 'pymysql.err.ProgrammingError'>
pymysql.err.ProgrammingError: (1146, "Table '_7c9073ad97ca0aea.tabLoan' doesn't exist")

Code of Conduct

• I agree to follow this project's Code of Conduct

[it-at-awokeindia]

+1