You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I was trying to install lending to a fresh v14 install of ERPnext and experienced this error. Is "lending" even meant to be installed on 14? Unfortunately also the old Loan Module now doesnt work anymore (I think doctypes are missing).
Is there a way to delete all Loan specific doc types and database entries and install lending fresh?
thanks for your help!
Module
Loan Management
Version
erpnext 14.48.1
frappe 14.55.0
lending 0.0.1
Installation method
manual install
Relevant log output / Stack trace / Full Error Message.
Installing lending...
Updating DocTypes for lending : [========================================] 100%
Running post-install patches to patch existing data...
An error occurred while installing lending: (1051, "Unknown table '_cef4968b8549ea81.tabLoan Product'")
Traceback (most recent call last):
File "apps/frappe/frappe/commands/site.py", line 415, in install_app
_install_app(app, verbose=context.verbose, force=force)
File "apps/frappe/frappe/installer.py", line 307, in install_app
frappe.get_attr(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")()
File "apps/lending/lending/patches/v15_0/rename_loan_type_to_loan_product.py", line 11, in execute
frappe.db.sql_ddl("DROP TABLE `tabLoan Product`")
File "apps/frappe/frappe/database/database.py", line 378, in sql_ddl
self.sql(query, debug=debug)
File "apps/frappe/frappe/database/database.py", line 220, in sql
self._cursor.execute(query, values)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 158, in execute
result = self._query(query)
File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 325, in _query
conn.query(q)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 549, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_query_result
result.read()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1157, inread
first_packet = self.connection._read_packet()
File "env/lib/python3.10/site-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "env/lib/python3.10/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "env/lib/python3.10/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1051, "Unknown table '_cef4968b8549ea81.tabLoan Product'")
Code of Conduct
I agree to follow this project's Code of Conduct
The text was updated successfully, but these errors were encountered:
I was fiddling with the broken database entries ( without success, haha) when I realised this:
# The first installation failed (see thread opener). But the apps seems to be installed:
bench --site SITENAME install-app lending
# "App erpnext already installed"# "App lending already installed"# so you can do:
bench uninstall-app lending
# which deletes ALL corresponding database entries# and kinda do a fresh installation with:
bench --site SITENAME install-app lending
Everything works for me now. Of course loan data would be lost I guess.
I had the same problem with V15. My steps to install successfully: bench --site SITENAME install-app lending
This ends up with the same error as above. Then I run: bench migrate
and everything works.
Information about bug
Hi, I was trying to install lending to a fresh v14 install of ERPnext and experienced this error. Is "lending" even meant to be installed on 14? Unfortunately also the old Loan Module now doesnt work anymore (I think doctypes are missing).
Is there a way to delete all Loan specific doc types and database entries and install lending fresh?
thanks for your help!
Module
Loan Management
Version
erpnext 14.48.1
frappe 14.55.0
lending 0.0.1
Installation method
manual install
Relevant log output / Stack trace / Full Error Message.
Code of Conduct
The text was updated successfully, but these errors were encountered: