Issue using the Sync WooCommerce

[vithusel]

Logs show the below error when running the sync function

Traceback (most recent call last): File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 30, in sync_woocommerce_orders create_order(woocommerce_order, woocommerce_settings) File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 164, in create_order so = create_sales_order(woocommerce_order, woocommerce_settings, company) File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 211, in create_sales_order "taxes": get_order_taxes(woocommerce_order, woocommerce_settings), File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 360, in get_order_taxes "account_head": get_tax_account_head(woocommerce_tax), File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 424, in get_tax_account_head tax_account = frappe.db.get_value("woocommerce Tax Account",
File "apps/frappe/frappe/database/database.py", line 495, in get_value result = self.get_values( File "apps/frappe/frappe/database/database.py", line 592, in get_values out = self._get_values_from_table( File "apps/frappe/frappe/database/database.py", line 822, in _get_values_from_table return self.sql(query, as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck) File "apps/frappe/frappe/database/database.py", line 218, in sql self._cursor.execute(query, values) File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 148, in execute result = self._query(query) File "env/lib/python3.10/site-packages/pymysql/cursors.py", line 310, in _query conn.query(q) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "env/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_query_result result.read() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 1156, in read first_packet = self.connection._read_packet() File "env/lib/python3.10/site-packages/pymysql/connections.py", line 725, 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.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'b'Tax' ORDER BY modified DESC LIMIT 1' at line 1")

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "apps/woocommerceconnector/woocommerceconnector/api.py", line 52, in sync_woocommerce_resources sync_orders() File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 15, in sync_orders sync_woocommerce_orders() File "apps/woocommerceconnector/woocommerceconnector/sync_orders.py", line 37, in sync_woocommerce_orders if e.args and e.args[0] and e.args[0].decode("utf-8").startswith("402"): AttributeError: 'int' object has no attribute 'decode'

[vithusel]

Willing to pay to get this fixed as its the only block for me being able to sync.

Setup a new instance of ERPNext and the issue is still happening.

[sptechcue]

You must delete .decode("utf-8") in sync_orders.py

[drzewkopl]

Fixed in this repo: https://github.com/drzewkopl/WooCommerceConnector