Problem with CVV contribution

[vertmonkee]

Hi I have just tried to install the CVV for cc.php contribution

 

http://www.oscommerce.com/community/contributions,99

 

when I try to place an order I get this error message after I click on the confirm order button.

 

1054 - Unknown column 'cvvnumber' 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, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, cvvnumber, date_purchased, orders_status, currency, currency_value) values ('3', 'Name', '', 'Address', 'Suburb', 'Town', 'Post code', 'County', 'United Kingdom', 'Telephone', 'email address', '1', 'Name', '', 'Address', 'Suburb', 'Town', 'Post code', 'County', 'United Kingdom', '1', 'Name', '', 'Address', 'Suburb', 'Town', 'Post code', 'County', 'United Kingdom', '1', 'Credit Card', 'Master Card', 'Card holder name', 'card number', 'expiry date', '', now(), '1', 'GBP', '1.00000000')

 

[TEP STOP]

 

I have replaced all the details near the end for obviouse security reasons. E.g. instead of Ian i have put Name in etc.

 

Does anyone know how to sort this out please

 

thanks very much

[thetraveller]

Hi I have just tried to install the CVV for cc.php contribution

 

http://www.oscommerce.com/community/contributions,99

 

when I try to place an order I get this error message after I click on the confirm order button.

 

1054 - Unknown column 'cvvnumber' 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, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, cvvnumber, date_purchased, orders_status, currency, currency_value) values ('3', 'Name', '', 'Address', 'Suburb', 'Town', 'Post code', 'County', 'United Kingdom', 'Telephone', 'email address', '1', 'Name', '', 'Address', 'Suburb', 'Town', 'Post code', 'County', 'United Kingdom', '1', 'Name', '', 'Address', 'Suburb', 'Town', 'Post code', 'County', 'United Kingdom', '1', 'Credit Card', 'Master Card', 'Card holder name', 'card number', 'expiry date', '', now(), '1', 'GBP', '1.00000000')

 

[TEP STOP]

 

I have replaced all the details near the end for obviouse security reasons. E.g. instead of Ian i have put Name in etc.

 

Does anyone know how to sort this out please

 

thanks very much

<{POST_SNAPBACK}>

 

 

You are missing a field in your database. Did you follow the install procedure exactly and make the necessary changes to your database?

 

John

[vertmonkee]

I did follow the instructions but guess I have slipped up along the way.

 

How do you suggest fixing the problem?

 

Please bear in mind I am not at all great with mysql

 

thanks for the quick response I always appreciate the great help I get here