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.