osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

admin order page problem

This is a discussion on admin order page problem within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; i am having a problem with my admin order page. i installed the upgrade to cvv number, now when i ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 02-13-2006, 04:55 AM
Member
 
Join Date: Sep 2005
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jschafer52
Default admin order page problem

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 02-13-2006, 10:56 AM
Active Member
 
Join Date: Oct 2005
Location: wherever I happen to be at the moment
Posts: 468
Thanks: 4
Thanked 79 Times in 73 Posts
Rep Power: 8
met00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nice
Default RE: admin order page problem

did you add cvvnumber to the orders table?
__________________
so endith the lesson
<think>sometimes I just sit's and thinks</think>
"Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 02-13-2006, 12:09 PM
Member
 
Join Date: Sep 2005
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jschafer52
Default RE: admin order page problem

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 02-13-2006, 04:38 PM
Active Member
 
Join Date: Oct 2005
Location: wherever I happen to be at the moment
Posts: 468
Thanks: 4
Thanked 79 Times in 73 Posts
Rep Power: 8
met00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nicemet00 is just really nice
Default RE: admin order page problem

buy now seems to be working. added items to cart.
__________________
so endith the lesson
<think>sometimes I just sit's and thinks</think>
"Here you are with a hand full of holes, a thumb up your ass, and a big grin to pass the time of day with." - TWB
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #5  
Old 02-13-2006, 04:50 PM
Member
 
Join Date: Sep 2005
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jschafer52
Default RE: admin order page problem

I think i had some old orders in the database that where screwing it up. thanks for checking.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #6  
Old 02-15-2006, 04:53 PM
Member
 
Join Date: Sep 2005
Posts: 82
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jschafer52
Default RE: admin order page problem

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]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #7  
Old 02-15-2006, 08:33 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,982
Thanks: 80
Thanked 345 Times in 324 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default RE: admin order page problem

bugtracker:
http://bugtrack.oscmax.com/view.php?id=11
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
CVV2/CSC # not showing up in My admin order page - help! markymrk22 osCommerce 2.2 Modification Help 1 05-01-2006 02:45 PM
problem in admin with Create Order joanstead osCMax v2 Installation issues 2 03-25-2006 01:33 PM
admin updating order problem neil osCMax v2 Features Discussion 4 03-05-2006 02:38 PM
Coupon problem in Order Admin Section. the_error_king osCMax v1.7 Discussion 0 01-25-2006 09:46 AM
Loggin into Admin page PROBLEM PSE HELP Chippy osCMax v1.7 Installation 2 07-08-2004 03:47 AM


All times are GMT -8. The time now is 12:31 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax