Guest Checkout throws error: User_Id cannot be null

Laraship QuestionsCategory: TechnicalGuest 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
laraship Staff answered 5 years ago


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 ;