Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Unknown Column 'order_Id' In 'field List' (1054) Rate Topic   - - - - -

 
  • Samanthar
  • Junior Member
  • Members
  • Join Date: 01-Mar 10
  • 51 posts

Posted 04 November 2015 - 08:40 PM #1

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' <b>(1054)</b>
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.



 
  • Hungryweb
  • Senior Member
  • Authorized Reseller
  • Join Date: 10-Feb 12
  • 1277 posts

Posted 04 November 2015 - 10:07 PM #2

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,
 
---
Valentin
part of hungryweb.net 



 
  • Samanthar
  • Junior Member
  • Members
  • Join Date: 01-Mar 10
  • 51 posts

Posted 04 November 2015 - 11:26 PM #3

Thanks. All working now



 
  • N8CAM
  • Newbie
  • Trial users
  • Join Date: 06-Jan 16
  • 2 posts

Posted 06 January 2016 - 04:30 PM #4

How do you run SQL Code???



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21996 posts

Posted 11 January 2016 - 08:37 AM #5

How do you run SQL Code???

 

You can run this query in the phpMyAdmin software


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)