POS error completing payment
-
When adding multiple custom products to the checkout and trying to complete the transaction the system dies.
This is the error:
exception: "Illuminate\Database\QueryException"
file: "/var/www/vhosts/xxxx/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
line: 664
message: "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'custom-2019-10-01-19:34:37' for key 'products_sku_unique' (SQL: insert into products (type, attribute_family_id, sku, updated_at, created_at) values (simple, 1, custom-2019-10-01-19:34:37, 2019-10-01 19:34:37, 2019-10-01 19:34:37))"
trace:
-
The 'sku' field needs to be unique, so you'll need to add something to the end of your string to make it more unique, i.e 'custom-2019-10-01-19:34:27-1234' where the 1234 is a random number or an incremental string.