Recent Topics

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))"

  • 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.

Log in to reply