Unexpected Token (SQL Error)

  • Hi, I’m using the latest version of WooCommerce POS and it seems whenever I initiate a checkout specifically with the POS System, I get an error for “Unexpected token < in JSON at position 0”. This doesn’t happen when a checkout is initiated through the website’s front-end.

    When I expand the details with the “i” button, I get this:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 WHERE post_id='202715' AND meta_key='_sku' LIMIT 1' at line 1]
SELECT meta_value FROM 0 WHERE post_id='202715' AND meta_key='_sku' LIMIT 1

{"id":217488,"parent_id":0,"number":"217488","order_key":"wc_order_5be62281aecb0","created_via":"rest-api","version":"3.4.7","status":"completed","currency":"USD","date_created":"2018-11-09T17:12:49","date_created_gmt":"2018-11-10T00:12:49","date_modified":"2018-11-09T17:12:50","date_modified_gmt":"2018-11-10T00:12:50","discount_total":"0.00","discount_tax":"0.00","shipping_total":"0.00","shipping_tax":"0.00","cart_tax":"0.23","total":"2.72","total_tax":"0.23","prices_include_tax":false,"customer_id":0,"customer_ip_address":"","customer_user_agent":"","customer_note":"","billing":{"first_name":"","last_name":"","company":"","address_1":"","address_2":"","city":"","state":"","postcode":"","country":"","email":"","phone":""},"shipping":{"first_name":"","last_name":"","company":"","address_1":"","address_2":"","city":"","state":"","postcode":"","country":""},"payment_method":"pos_cash","payment_method_title":"Cash","transaction_id":"","date_paid":"2018-11-09T17:12:50","date_paid_gmt":"2018-11-10T00:12:50","date_completed":"2018-11-09T17:12:50","date_completed_gmt":"2018-11-10T00:12:50","cart_hash":"","meta_data":[{"id":4738725,"key":"_pos","value":"1"},{"id":4738726,"key":"_pos_user","value":"4"},{"id":4738727,"key":"_pos_user_name","value":"(Redacted) "},{"id":4738728,"key":"_pos_cash_amount_tendered","value":"2.7216"},{"id":4738729,"key":"_pos_cash_change","value":"0"},{"id":4738734,"key":"_pos_payment_result","value":"success"},{"id":4738735,"key":"_pos_payment_message","value":""}],"line_items":[{"id":716,"name":"(Redacted)","product_id":202715,"variation_id":0,"quantity":1,"tax_class":"","subtotal":"2.49","subtotal_tax":"0.23","total":"2.49","total_tax":"0.23","taxes":[{"id":1,"total":"0.2316","subtotal":"0.2316"}],"meta_data":[],"sku":"W0900","price":2.4900000000000002131628207280300557613372802734375,"composite_parent":"","composite_children":[],"meta":[]}],"tax_lines":[{"id":717,"rate_code":"AZ-SALES TAX-1","rate_id":1,"label":"Sales Tax","compound":false,"tax_total":"0.23","shipping_tax_total":"0.00","meta_data":[]}],"shipping_lines":[],"fee_lines":[],"coupon_lines":[],"refunds":[],"cashier":{"id":"4","first_name":"(Redacted)","last_name":""},"payment_details":{"result":"success","message":"","redirect":"","method_id":"pos_cash","method_title":"Cash","paid":true,"method_pos_cash":{"tendered":"2.7216","change":"0"}},"note":"","total_discount":"0.00","total_shipping":"0.00","order_number":"217488","updated_at":"2018-11-09T17:12:50","billing_address":{"first_name":"","last_name":"","company":"","address_1":"","address_2":"","city":"","state":"","postcode":"","country":"","email":"","phone":""},"shipping_address":{"first_name":"","last_name":"","company":"","address_1":"","address_2":"","city":"","state":"","postcode":"","country":""},"completed_at":"2018-11-09T17:12:49","_links":{"self":[{"href":"(Redacted)"}],"collection":[{"href":"(Redacted)"}]}}
    • This topic was modified 6 years, 3 months ago by iObject.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter iObject

    (@iobject)

    To add a bit more detail, if that makes it easier to respond to, the orders still post on the “Orders” section of our backend. The only thing this error prevents us from doing is printing the receipt and opening the cash drawer automatically.

    Plugin Author kilbot

    (@kilbot)

    Hi,

    It seems there is an error when WooCommerce tries to retrieve the SKU for the product. Two things to check:

    1. Are you using any plugins that may effect the product SKU? If so you could try temporarily disabling the plugin to see if it fixes the error.
    2. Does this error only show for this one product (ID = 202715), or does it effect all products?
    Thread Starter iObject

    (@iobject)

    1) None of my plugins affect product SKUs, but not all products have an SKU. Regardless, the error I posted above was for a product that had an SKU on it.
    2) It affects all products.

    As for plugins, here are my WooCommerce-specific plugins:
    The official WooCommerce Wishlists plugin
    The official WooCommerce Composite Products plugin
    USPS (Basic) WooCommerce Shipping

    The only one of these that I could see potentially being a problem is the Composite Products plugin, but something also tells me it’s not that.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Unexpected Token (SQL Error)’ is closed to new replies.