Unknown Column 'order_Id' In 'field List' (1054)

Now getting this error which is preventing people from checking out of the shopping cart.

Database (error)
Error: Unknown column 'order_id' in 'field list' (1054)
Query: UPDATE cscart_user_session_products SET order_id = 4110 WHERE session_id = '2c477036b43446886f9eb211b086e77f' AND type = 'C'

Have emailed support a couple of days ago but still waiting, in the meantime shop is closed and no sales. If anyone could help that would be great.

you will need to run sql code bellow to fix this issue

ALTER TABLE `cscart_user_session_products` ADD COLUMN `order_id` INT DEFAULT 0 NOT NULL

I hope that helps

Keep on smiling,

part of hungryweb.net

Thanks. All working now

How do you run SQL Code???

How do you run SQL Code???

You can run this query in the phpMyAdmin software