Guest Checkout throws error: User_Id cannot be null

Guest Checkout throws error: User_Id cannot be null

Laraship QuestionsCategory: TechnicalGuest Checkout throws error: User_Id cannot be null
Nischal asked 4 months 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 4 months 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 ;