error while attempting to set up gift card


  • Your avatar
    seyi    
     4 years ago
    0

    i receive an error when setting up a gift card from VM.

    DB function failed with error number 1054
    Unknown column 'exclude_giftcert' in 'field list' SQL=UPDATE `jos_awocoupon_giftcert_product` SET `product_id`='25',`profile_id`='3',`coupon_value`='20.00000',`expiration_number`=NULL,`expiration_type`=NULL,`exclude_giftcert`=NULL,`published`='1' WHERE id='1'

  • Your avatar
    seyi    
     4 years ago
    0

    Hi Jim,

    Running this on your database should fix the problem:
    alter table jos_awocoupon_giftcert_product add column `exclude_giftcert` TINYINT(1);