Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 3 of 3

Thread: Admin Order error

  1. #1

    Default Admin Order error

    Hi Everybody,
    During the testing of my Admin. I have notice the follow error when I go to Customers/orders and than click on either edit, invoice or packing slip;

    1054 - Unknown column 'verisign_ref' 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, comments, currency, currency_value, verisign_ref, date_purchased, orders_status, last_modified from orders where orders_id = '5'

    [TEP STOP]

    Would anybody know what this error message is or what is causing it? I am using the verisign 9.67 addon module.
    Thank You for the help,

  2. #2
    osCMax Developer

    Admin Order error

    Join Date
    Jul 2002
    Phoenix, AZ
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power


    You need to add the db mods that are included with the verisign mod. It should have a sql file that you need to run in phpmyadmin.

  3. #3


    Hi Msasek, yes I was just reading the Advanced Setup Section of the installation instructions and there are a couple of things that need to be done, that I over looked However I am having a problem with one of the steps. Which is I need to add the column to the database however when I try to enter the requires statement I get the following error message:


    SQL-query :

    ALTER GiftsUniqueShop.orders ADD verisign_ref TINYTEXT

    MySQL said:

    Something is wrong in your syntax près de 'GiftsUniqueShop.orders ADD verisign_ref TINYTEXT' à la ligne 1

    this is the install statement copy and paste from the instruction. Would you know what is wrong with it? By the way I'm trying to do this on my local machine first to make sure everything is working ok before I install this on my live site. That is way the db name is just GiftsUniqueShop.

    Thank you for any help.

Similar Threads

  1. Manual order in Admin
    By daffodil in forum osCmax v2 Installation issues
    Replies: 4
    Last Post: 09-12-2006, 01:48 AM
  2. Update Order Status in Admin and Tax
    By daffodil in forum osCmax v2 Installation issues
    Replies: 0
    Last Post: 06-26-2006, 09:23 AM
  3. problem in admin with Create Order
    By joanstead in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 03-25-2006, 01:33 PM
  4. admin updating order problem
    By neil in forum osCMax v2 Features Discussion
    Replies: 4
    Last Post: 03-05-2006, 02:38 PM
  5. Admin Order Editting
    By n30 in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 10-10-2003, 10:08 PM



Posting Permissions

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