admin order page problem

**jschafer52** · 02-13-2006, 03:55 AM

i am having a problem with my admin order page. i installed the upgrade to cvv number, now when i go to the order page in my admin section, and select an order i get this error

1054 - Unknown column 'cvvnumber' 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_expires, cvvnumber, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '22'

can anyone please help me?

thanks,
JIM

**met00** · 02-13-2006, 09:56 AM

did you add cvvnumber to the orders table?

**jschafer52** · 02-13-2006, 11:09 AM

yes i figured that out just after i sent this, but i am still having problems, the credit card mod is not working. and the buy now buttons on my site are not working ether now.

if anyone can take a look please.

www.fukkenwaxfinish.com

and click buy now for one of the products.

thanks,
JIM

**met00** · 02-13-2006, 03:38 PM

buy now seems to be working. added items to cart.

**jschafer52** · 02-13-2006, 03:50 PM

I think i had some old orders in the database that where screwing it up. thanks for checking.

**jschafer52** · 02-15-2006, 03:53 PM

sorry to ask, but i seem to have a problem with the buy now button when you are logged into your account, any ideas? if you have an account and are logged in when you push the buy no button you get error...

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

delete from customers_wishlist WHERE customers_id=1 AND products_id=

[TEP STOP]