You have an error in your SQL syntax

[yashodhank]

Status
Error


Method
sync_erpnext_customers


Message
Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 110, in sync_erpnext_customers
    update_customer_to_shopify(customer, shopify_settings.last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 154, in update_customer_to_shopify
    update_address_details(customer, last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 167, in update_address_details
    customer_addresses = get_customer_addresses(customer, last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 195, in get_customer_addresses
    return frappe.db.sql(address_query, as_dict=1)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 165, in sql
    self._cursor.execute(query)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
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 'Grady'' at line 4")


Request Data
{"shopify_customer_id": "4056078662", "name": "Gerald O'Grady", "customer_name": "Gerald O'Grady "}

Status
Error


Method
sync_erpnext_customers


Message
Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 110, in sync_erpnext_customers
    update_customer_to_shopify(customer, shopify_settings.last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 154, in update_customer_to_shopify
    update_address_details(customer, last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 167, in update_address_details
    customer_addresses = get_customer_addresses(customer, last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 195, in get_customer_addresses
    return frappe.db.sql(address_query, as_dict=1)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 165, in sql
    self._cursor.execute(query)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
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 'souza'' at line 4")


Request Data
{"shopify_customer_id": "3178328710", "name": "Daniel  D'souza", "customer_name": "Daniel  D'souza"}

Status
Error


Method
sync_erpnext_customers


Message
Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 110, in sync_erpnext_customers
    update_customer_to_shopify(customer, shopify_settings.last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 154, in update_customer_to_shopify
    update_address_details(customer, last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 167, in update_address_details
    customer_addresses = get_customer_addresses(customer, last_sync_datetime)
  File "/home/frappe/frappe-bench/apps/erpnext_shopify/erpnext_shopify/sync_customers.py", line 195, in get_customer_addresses
    return frappe.db.sql(address_query, as_dict=1)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 165, in sql
    self._cursor.execute(query)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
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 's'' at line 4")


Request Data
{"shopify_customer_id": "5098751622", "name": "Chandrakant Kadam Ck's", "customer_name": "Chandrakant Kadam Ck's "}