Error message now that I added CVV2 module

[franticstamper]

I followed all the instructions to add cvv2, and now I get this error message. I don't know what else to do.

(I'm really trying to help myself by reading this board, but everytime I fix 1 thing, I goof up another)

 

--------------------------------

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

 

select 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_cvv2, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '9'

 

[TEP STOP]

---------------------------------

 

so what am I missing?

 

Thanks!

Fran :'(

[franticstamper]

I figured out (after an afternoon of reading), that I am probably missing a field in a database somewhere.

 

My problem is, I don't know what, where, or how to fix it.

I don't know anything about db's, phpmyadmin, or such stuff. I'm not a programmer.

 

If some kind soul would be willing to help me, maybe walk me thru this on the phone, that would be fantastic. Please e-mail me at [email protected]

 

Thanks

[Guest]

I figured out (after an afternoon of reading), that I am probably missing a field in a database somewhere.

 

My problem is, I don't know what, where, or how to fix it.

I don't know anything about db's, phpmyadmin, or such stuff. I'm not a programmer.

 

If some kind soul would be willing to help me, maybe walk me thru this on the phone, that would be fantastic. Please e-mail me at [email protected]

 

Thanks

 

I figured out how to run the query in phpMyAdmin, for those of you who need help see the attached document; http://www.malavi.com/images/phpmyadmin%20DB%20.pdf

[Guest]

I figured out (after an afternoon of reading), that I am probably missing a field in a database somewhere.

 

My problem is, I don't know what, where, or how to fix it.

I don't know anything about db's, phpmyadmin, or such stuff. I'm not a programmer.

 

If some kind soul would be willing to help me, maybe walk me thru this on the phone, that would be fantastic. Please e-mail me at [email protected]

 

Thanks

how to import new SQL (usually something.sql) into the database

 

 

Go to your phpMyAdmin

Choose your osC database on the left in the pull-down menu

On the right side, click on the SQL tab at the top

Then paste the code below into the textarea on that page or browse to the sql file on your pc

Click on the GO button and you are done

[my scrap shop G]

thank you so much! stupid me went the to button that had "query" rather than "sql". I mean, how stupid of me really, when told to run a query to hit the "query" button!!!! OMG who devises these programs.... rant rant rant... off to bed now, but happy that it's all fixed. :)

[lyndat]

HELP - I am trying to help a customer, added the cvv2 code everywhere it told me to, but get this same error 1054. I think the main problem is I don't have a clue how to get or even find the phpmyadmin????? If I could find how to run that query, I think I might be ok?

LDT

 

 

 

I followed all the instructions to add cvv2, and now I get this error message. I don't know what else to do.

(I'm really trying to help myself by reading this board, but everytime I fix 1 thing, I goof up another)

 

--------------------------------

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

 

select 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_cvv2, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '9'

 

[TEP STOP]

---------------------------------

 

so what am I missing?

 

Thanks!

Fran :'(

[Guest]

see answer to your other post