Hello, I am running an on-prem version-14 erpnext manual install. I am trying to implement the GoCardless Payment gateway. I followed the documentation here: Setting up GoCardless.
The main error I’m seeing is this:
pymysql.err.OperationalError: (1054, “Unknown column ‘header_img’ in ‘field list’”)
For troubleshooting, I uninstalled the payment apps from my site and removed the app from bench (bench uninstall-app, bench remove-app). Then reinstalled with bench get-app and bench install-app, followed by bench clear-cache, bench migrate, and bench restart. Here are my current installed app versions:
erpnext 14.3.1
frappe 14.12.0
hrms 1.0.0
payments 0.0.1
I configured my GoCardless settings first in ERPNext Integrations > GoCardless Settings to create my Gateway (with webhooks secret), which also created my Payment Gateway Document, Payment Gateway Account Document, and Account Head in the Chart of Accounts. My GoCardless (non-sandbox) account is functional and the webhooks are showing green- so they are able to connect to the webhook endpoint: https://redacted-site-name/api/method/erpnext.erpnext_integrations.doctype.gocardless_settings.webhooks. Everything seems to be there, but I am still seeing this error. I am testing by creating a Payment Request from a Sales Invoice and sending it with the payment link, then clicking on the link: <a href="{{ payment_url }}"> click here to pay </a>
There is more detail in the error log, the error is called “/integrations/gocardless_checkout failed”
File “apps/frappe/frappe/website/serve.py”, line 18, in get_response
…
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 725, in _read_packet
packet.raise_for_error()
self = <pymysql.connections.Connection object at 0x7f86e569a560>
packet_type = <class ‘pymysql.protocol.MysqlPacket’>
buff = bytearray(b"\xff\x1e\x04#42S22Unknown column 'header_img' in 'field list'“)
packet_header = b’4\x00\x00\x01’
btrl = 52
btrh = 0
packet_number = 1
bytes_to_read = 52
recv_data = b”\xff\x1e\x04#42S22Unknown column ‘header_img’ in ‘field list’"
packet = <pymysql.protocol.MysqlPacket object at 0x7f86e5618a90>
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
self = <pymysql.protocol.MysqlPacket object at 0x7f86e5618a90>
errno = 1054
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
data = b"\xff\x1e\x04#42S22Unknown column ‘header_img’ in ‘field list’"
errno = 1054
errval = “Unknown column ‘header_img’ in ‘field list’”
errorclass = <class ‘pymysql.err.OperationalError’>
pymysql.err.OperationalError: (1054, “Unknown column ‘header_img’ in ‘field list’”)
Any help appreciated, I’m trying to stay as close to possible to the most simple way to implement this. Maybe I missed something?