Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'cc_cvv2' in 'field list'


kudviss

Recommended Posts

hi everyone

Could you please help me fix this error :

 

1054 - Unknown column 'cc_cvv2' in 'field list'

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, ................................................

 

 

I have CPANEL is it useful to fix this error?

please email me the solution to [email protected] if possible

Link to comment
Share on other sites

That means you don't have a column in your database to store the cc_cvv2. Add that to your database table order. Use this to fix this error:

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 ) NULL DEFAULT NULL AFTER `cc_expires`;

Link to comment
Share on other sites

  • 4 months later...
That means you don't have a column in your database to store the cc_cvv2. Add that to your database table order. Use this to fix this error:
ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 ) NULL DEFAULT NULL AFTER `cc_expires`;

 

 

im a newbie i was trying to add `cc_cvv2` to my database but i cant get to add it

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...