Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error message now that I added CVV2 module


franticstamper

Recommended Posts

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 :'(

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 8 months later...
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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 weeks later...

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. :)

Link to comment
Share on other sites

  • 10 months later...

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 :'(

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...