Error when editing coupons


  • Your avatar
    seyi    
     5 years ago
    0

    Hi,

    I tried to edit an existing coupon and I get the following error when saving:

    DB function failed with error number 1054
    Unknown column 'template_id' in 'field list' SQL=UPDATE `jos_awocoupon` SET `coupon_code`='ERL11G1',`parent_type`='first',`coupon_value_type`='amount',`coupon_value`='20.00000',`coupon_value_def`=NULL,`function_type`='giftcert',`function_type2`=NULL,`num_of_uses_type`=NULL,`num_of_uses`=NULL,`min_value`=NULL,`discount_type`=NULL,`user_type`=NULL,`function_type2_mode`=NULL,`startdate`=NULL,`expiration`=NULL,`exclude_special`=NULL,`exclude_giftcert`='1',`order_id`=NULL,`template_id`=NULL,`published`='1',`note`=NULL WHERE id='5'

    We`re using J 1.5.22, AwoCoupon Pro 1.3.4 and VM 1.1.8

    Please fix this and/or let me know how to hot-fix this in our installation.

    Carsten
  • Your avatar
    seyi    
     5 years ago
    0

    please run this code in mysql
    ALTER TABLE jos_awocoupon ADD COLUMN `template_id` INT AFTER order_id;

  • Default avatar
    a42486    
     5 years ago
    0

    'ALTER TABLE...' worked.
    I updated from 1.3.2 to 1.3.4, probably this field was missing by this.