Guest Checkout throws error: User_Id cannot be null

Laraship Questions › Category: Technical › Guest Checkout throws error: User_Id cannot be null

Nischal asked 5 years ago

Hi, I am getting integrity contraint error when trying to checkout as guest when hitting next on address page. Kindly advice. {"notification":{"level":"error","message":"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_id' cannot be null (SQL: insert into ecommerce_orders (amount, currency, order_number, billing, status, user_id, created_by, updated_by, updated_at, created_at) values (255, USD, ORD-000002, { Thanks Nischal

1 Answers

0 Vote Up Vote Down

laraship Staff answered 5 years ago

Hello,

Thank for eaching us, our team has identified the issue, as for a workaround, tun the following sql in your phpmyadmin or sql client,

update ecommerce_orders

ALTER TABLE ecommerce_orders MODIFY user_id  int(10) UNSIGNED ;