osCmax v2.5 User Manual
Results 1 to 7 of 7

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

      
  1. #1
    Member
    Join Date
    Sep 2005
    Posts
    82
    Rep Power
    0


    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

  2. #2
    osCMax Development Team met00's Avatar
    Join Date
    Oct 2005
    Location
    wherever I happen to be at the moment
    Posts
    854
    Blog Entries
    2
    Rep Power
    26


    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

  3. #3
    Member
    Join Date
    Sep 2005
    Posts
    82
    Rep Power
    0


    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

  4. #4
    osCMax Development Team met00's Avatar
    Join Date
    Oct 2005
    Location
    wherever I happen to be at the moment
    Posts
    854
    Blog Entries
    2
    Rep Power
    26


    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

  5. #5
    Member
    Join Date
    Sep 2005
    Posts
    82
    Rep Power
    0


    Default RE: admin order page problem

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

  6. #6
    Member
    Join Date
    Sep 2005
    Posts
    82
    Rep Power
    0


    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]

  7. #7
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default RE: admin order page problem

    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

Similar Threads

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •